1 Reply Latest reply: Apr 29, 2014 12:55 PM by mseberg RSS

    Re: Primary db shutdown with Standby db

    skyfox

      If the Application has a mandatory requirement to shutdown the primary database (for nightly app clean-up etc) for 1 HR daily, impact on standby database using Data Guard without Broker? Besides out of sync, standby db impacts, standby db resumes MRP sync after primary is UP? TIA

        • 1. Re: Primary db shutdown with Standby db
          mseberg

          Hello;

           

          Data Guard handles this very well. Generally once you startup the Primary it will just resume and the Standby will be back in sync in no time.

           

          The Standby alert will show waiting for log... while this outage occurs.

           

          I have done this on test many times without an issue. That said I would rather disable shipping and then shutdown, startup and enable again.

           

          You could also script your shutdown:

           

          stoprecovery.sh

           

           

          !/bin/bash

          ####################################################################

          #

          # To cancel Data Guard recovery and shuts down the databases.

          #

          # 2/4/2013

          #

          # Set the Environmental variable for the instance

          #

          . /u01/app/oracle/dba_tool/env/STANDBY.env

          #

          #

          ORACLE_SID=STANDBY

           

          $ORACLE_HOME/bin/sqlplus /nolog <<EOF

          connect sys/oracle as sysdba

          alter database recover managed standby database cancel;

          shutdown

          EOF

          echo `date`

           

          And your startup

           

          startrecovery.sh

           

          #!/bin/bash

          ####################################################################

          #

          # To start the databases in MOUNT and starts the Data Guard recovery.

          #

          # 2/4/2013

          #

          # Set the Environmental variable for the instances

          #

          . /u01/app/oracle/dba_tool/env/STANDBY.env

          #

          #

           

          ORACLE_SID=STANDBY

           

          $ORACLE_HOME/bin/sqlplus /nolog <<EOF

          connect sys/oracle as sysdba

          startup mount

          alter database recover managed standby database disconnect from session;

          EOF

          echo `date`

           

           

           

          Best Regards

           

          mseberg