Time for action – applying PSU on a physical standby database

1. Disable log transport and stop MRP in the standby database. Before disabling log transport in standby, cross-check the synchronization between the primary and standby database, as shown in the following screenshot:

   

2. Now cancel MRP using the broker; you can perform this step from any site as shown in the following screenshot:

   

3. Stop the database services of the primary and standby and perform a backup of ORACLE_HOME. Prior to shutting down all the services, gather the invalid objects of each schema to check the invalid objects after the patch has been applied using the following script:

   SQL> select owner,object_name,object_type,status from dba_objects  where status <> 'VALID' and OWNER !='PUBLIC' and OBJECT_TYPE!='SYNONYM';
   

4. Ensure that there is a latest and valid Cold/RMAN backup available prior to applying the patch. Also ensure that all the applications are down. You can check for active sessions from v$session as follows...