Rehoming a Physical Standby DB

Posted on 2007-10-12
Last Modified: 2013-12-19
Hi All

I have just finished building a a Physical Standby DB in oracle 10g, however i now need to ship the (as in physically send the server) to its new home in a remote Data Centre.

Will i have any issues when i restart the server in its new home ? or will FAL just grab all the logs it needs ?

Any gotchas you know about ?

there really isnt a cut and dry answer for this, but i will try to share the points fairly ;-)
Question by:Geraint_M_Jones
    LVL 27

    Expert Comment

    why don't you test it at it's current location.

    Shutdown both databases.

    shutdown both computers.


    Restart both computers, check if both databases come up properly (the physical standby database knows about itself and will not "open" the database by itself)

    Then check if all redo logs are applied.

    I'm doing this with oracle grid control. It allows me to see the current status of the both databases, the status of the redo log transmission + a handy benchmark to test performance of the data replication.

    Just be aware that the amount of redo logs is growing fast into gigabytes during that benchmark, so turn it off after some minutes.

    LVL 1

    Author Comment

    No no, i know it "works" what i am concerned about is when i move the box that when it gets to its new home that it wont just start applying but will have to have some manual intervention to get the gap closed.

    Does that make sense ?

    ie if oracle has 10gb of redo it needs to ship - it just wont bother and the standby will do nothing!
    LVL 27

    Expert Comment

    Ok got it.

    LVL 27

    Expert Comment

    You could test that if you turn off just the physical database server and switch it on after 1- 2 hours.

    If the master DB will not transfer the missing redos at once you have to remove the connection and reestablish the replication  after the standby server is on it's new place.
    LVL 5

    Accepted Solution

    I'll suggest to unset log_archive_dest_X parameter on the primary database if you don't use Data Guard Broker, otherwise set LOG_TRANSPORT to this database to be disabled. This way you'll avoid a lot of errors in the primary database alert log. During the rehoming copy your newly created archived redo logs on another machine using rsync or ftp to have it somewhere else also.

    When you start the physical standby again , set log_archived_dest.. on primary db and watch in the alert logs if archived redo gap will be resolved. If not, then copy manually newly created archived redo logs and register them using something like this:


    for every log.

    Verify that media recovery is ok on the physical standby.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Init.ora File Points to SPFILE 6 50
    How can I use listagg with distinct. 4 44
    UNIX SCP 5 27
    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now