Oracle Data Guard 11gR2 Administration Beginner's Guide

Time for action – applying a patch on logical standby

1. Disable log shipping in a standby database and stop SQL Apply in it. First we need to stop SQL Apply in the standby database and disable log shipping from the primary database as follows:

   SQL> select db_unique_name,database_role from v$database;
   DB_UNIQUE_NAME  DATABASE_ROLE
   --------------- ----------------
   turkey_un       PRIMARY
   SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2='DEFER';
   System altered.
   SQL>

2. Stop SQL Apply in the logical standby database as follows:

   SQL> select db_unique_name,database_role from v$database;
   DB_UNIQUE_NAME  DATABASE_ROLE
   --------------- ----------------
   INDIA_UN        LOGICAL STANDBY
   SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;
   Database altered.
   SQL>

3. Stop the database services ...