7 Replies Latest reply: Oct 22, 2013 11:36 PM by Mahir M. Quluzade RSS

    Starup of active dataguard in RAC

    789987

      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

          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

            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

              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

                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
                  Mahir M. Quluzade

                  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

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

                    • 7. Re: Starup of active dataguard in RAC
                      Mahir M. Quluzade

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

                       

                      Regards

                      Mahir M. Quluzade