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 of the primary and standby and perform a backup of ORACLE_HOME.

4. After applying a patch, more objects can become invalid. Hence. gather all the invalid objects and keep a count of them so that they can be recompiled...