Patching (Primary & Standby)
To apply psu patch on physical standby database setup, 1st patch needs to be applied on standby, and then on primary. Below are the steps.
Check the database_role for both dbs (select database_role from v$database;)
Check log gap between primary and standby ( it should be zero)
DISABLE SHIPPING ON PRIMARY
CANCEL THE RECOVERY ON STANDBY
Shutdown the listener and database in standby
Check the patch conflict with ORACLE_HOME (prereq CheckConflictAgainstOHWithDetail)
Now apply the patch(on standby)
start the standby database in mount state and start the listener
Now shutdown the database and listener in primary
go to patch location and unzip the patch
Check the patch conflict with ORACLE_HOME
Now apply the patch on primary
Now start up open the database and listener.
Enable archive shipping in primary
Start the recovery(MRP) on standby:
Run the catbundle.sql script from PRIMARY
Check the registry history in primary( this patch should be listed there)
