This discussion is archived
6 Replies Latest reply: Oct 22, 2012 3:32 AM by saurabh RSS

Physical Standby database switchover

938626 Newbie
Currently Being Moderated
Hi

We have one primary database and 2 physical standby databases.

We want to test the switch over scenario. If we switch over the primary with standby1, then what happened to standby2.

Once the switch over is occurred what is the state of other stand by database.

Any pointers to doc/steps how to proceed in this scenario.

Thanks in advance.

Thanks
Sree
  • 1. Re: Physical Standby database switchover
    mseberg Guru
    Currently Being Moderated
    Hello;

    If the log_archive_dest_n are set correctly standby2 should remain standby2.

    One method of dealing with this is to cascade :

    http://www.visi.com/~mseberg/Data_Guard_Cascading_Standby_Setup_and_Test.pdf

    For additional information see :

    http://www.oracle.com/technetwork/database/features/availability/maa10gr2multiplestandbybp-1-131937.pdf

    http://docs.oracle.com/cd/B19306_01/server.102/b14239/scenarios.htm



    Best Regards

    mseberg
  • 2. Re: Physical Standby database switchover
    expressoteam Newbie
    Currently Being Moderated
    Hi,

    For cascade method...i will use Release 11.2.0.2 or Above. because "Releases prior to 11.2.0.2 have several limitations for this feature that are not present in release 11.2.0.2"
    see doc...
    http://docs.oracle.com/cd/E11882_01/server.112/e10700/log_transport.htm#BEHBIGHF


    if you are not using cascade, you can write a custom scripts to determine when the swtichover occurs and automatically change necessary init. parameter on the second standby to receive logfiles from the new primary db.

    HTH
    Tobi
  • 3. Re: Physical Standby database switchover
    teits Journeyer
    Currently Being Moderated
    Hi,

    For cascade method...i will use Release 11.2.0.2 or Above. because "Releases prior to 11.2.0.2 have several limitations for this feature that are not present in release 11.2.0.2"
    see doc...
    http://docs.oracle.com/cd/E11882_01/server.112/e10700/log_transport.htm#BEHBIGHF

    --edited....
    if you are not using cascade, you can write a custom scripts to determine when the swtichover occurs and automatically change necessary init. parameter on the second standby to receive logfiles from the new primary db.

    check dataguard broker doc
    http://docs.oracle.com/cd/B28359_01/server.111/b28295/sofo.htm#BCGFBHJI

    "Redo Apply on all other standby databases not involved in the switchover automatically begin applying redo data from the new primary database"

    HTH
    Tobi

    Edited by: teits on Oct 19, 2012 8:35 PM
  • 4. Re: Physical Standby database switchover
    938626 Newbie
    Currently Being Moderated
    Hi

    Thanks to all for your reply.

    I am not using cascade.

    Log files are shipped directly from primary to both the standby databases.

    So if the init parameters are set correctly... I don't need to do any thing.

    Thanks
    Sree
  • 5. Re: Physical Standby database switchover
    teits Journeyer
    Currently Being Moderated
    935623 wrote:
    Hi

    Thanks to all for your reply.

    I am not using cascade.

    Log files are shipped directly from primary to both the standby databases.

    So if the init parameters are set correctly... I don't need to do any thing.

    Thanks
    Sree
    YES, if you use dataguard broker just do:
     SWITCHOVER TO <standby database name you want to switch to>; 
    the broker is going to configure the necessary init. parameter for the standby DB that did not participate in the switchover.

    Note
    your primary db should be in transport-on state
    your standby dbs should be in apply-on


    HTH
    Tobi
  • 6. Re: Physical Standby database switchover
    saurabh Pro
    Currently Being Moderated
    if you are not using cascaded dr then when you switch over your primary database to standby then you can switch any of the two standby databases. But after switchovering any of your standby to primary there are changes you need to do on both standby and primary.

    On new standby---- you need to add fal_client and fal_server entery

    on old standby you need to change fal_server entery

    on new primary log_archive_dest_2 and log_archive_dest_3 entery you need to add

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points