This discussion is archived
7 Replies Latest reply: Oct 22, 2013 9:36 PM by MahirM.Quluzade RSS

Starup of active dataguard in RAC

789987 Newbie
Currently Being Moderated

Hi,

 

i have a setup of active dataguard in RAC. This is my first time implementing dataguard in RAC.

 

Primary - RAC

Standby - RAC with active dataguard

 

when ever standby server(anyone of the RAC instance) reboots it is getting till mount state. And after that how can i get the database be opened and put in recovery mode to do redo apply.

 

I tried to push manual script as a startup script . Intially i kept sleep command for 15-20min and then connect to db instance and try to recovery from mounted database. But my mounted database is taking 15-30min to comeup once the server is rebooted.

 

please help me how we configure startup statements once the RAC is in mount state(cluster is getting till this point) after server reboot.

  • 1. Re: Starup of active dataguard in RAC
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    If you are not using Data Guard Broker you need to open the standby database and set it in read only mode and then start the managed recovery as shown below.

     

    SQL> shutdown immediate;

     

     

    SQL> startup

     

    SQL> recover managed standby database using current logfile disconnect;

     

    With broker its like this :

     

    Stop redo apply with the following command from Data Guard Broker

     

    DGMGRL> EDIT DATABASE '?' SET STATE='APPLY-OFF';

     

    Open standby read-only via SQL*Plus

     

    SQL> alter database open read only;

     

    Restart redo apply via broker

     

    DGMGRL> EDIT DATABASE '?' SET STATE='APPLY-ON';

     

     

    Best Regards

     

    mseberg

  • 2. Re: Starup of active dataguard in RAC
    789987 Newbie
    Currently Being Moderated

    Thanks mseberg for your reply.

     

    Im aware of the commands to open and put it in recovery mode.

     

    My be i asked question wrongly. How can i automate these 2 sql statments once the instance/cluster is started after server reboot.

  • 3. Re: Starup of active dataguard in RAC
    mseberg Guru
    Currently Being Moderated

    My mistake.

     

    Have you seen this:

     

     

    (Data Guard & Oracle Restart in 11gR2 | The Oracle Instructor)

     

    Best Regards

     

    mseberg

  • 4. Re: Starup of active dataguard in RAC
    789987 Newbie
    Currently Being Moderated

    Unfortunely we will be not using Oracle Restart option.

     

    Now i was able to open the standby(RAC) for active dataguard by doing small change.

    srvctl config database -d DBNAME -s open  -- from this command after server reboot standby instance is going up to open state.

     

    Only thing im stuck up with recovery sql statement. Is there a way can you recommend how to invoke this statement once the RAC instance is restarted, with out manual process.

    alter database recover managed standby database disconnect from session;

  • 5. Re: Starup of active dataguard in RAC
    MahirM.Quluzade Guru
    Currently Being Moderated

    Hi,

     

    Only thing im stuck up with recovery sql statement. Is there a way can you recommend how to invoke this statement once the RAC instance is restarted, with out manual process.

    alter database recover managed standby database disconnect from session;


    This command start Redo apply process. I  understand you want start Redo apply process after startup database automatically.

    As you know, on broker  managed data guard, Redo apply process starting automatically on standby database after restart.

     

    You databases RAC databases, and oracle recommend for RAC databases broker managed data guard.

    Then you can use Broker Managed Data Guard.

     

    Regards

    Mahir M. Quluzade

  • 6. Re: Starup of active dataguard in RAC
    789987 Newbie
    Currently Being Moderated

    After registering to dataguard broker. its working.thanks for your helpful answers.

  • 7. Re: Starup of active dataguard in RAC
    MahirM.Quluzade Guru
    Currently Being Moderated

    Then if your question answered, then please mark answered your thread for clear forum, please.

     

    Regards

    Mahir M. Quluzade

Legend

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