how to patch standby oracle database

how to patch standby :-

alter system set log_archive_dest_state_2=defer;

Brief steps:-

0. Disable log shipping from the Primary
1. Shutdown Standby
2. Install patch on Standby software only
3. Startup Standby in recovery mode (do NOT run any SQL at the standby)
4. Shutdown Primary
5. Install patch on Primary
6. Run SQL on Primary
7. Re-enable log shipping
8. Monitor the redo apply from Primary to Standby --- this will also upgrade the Standby

See Oracle support article : How do you apply a Patchset,PSU or CPU in a Data Guard Physical Standby configuration [ID 278641.1]

apply PSU patch :-


unzip p24732075_112040_<platform>.zip
cd 24732075
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

unzip p24732075_112040_<platform>.zip
cd 24732075
$ORACLE_HOME/OPatch/opatch apply

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
oracle@nodet1: /oraexp/p24732075_112040_HPUX-IA64.zip
 


Comments

Popular posts from this blog

Installing DBMS_JAVA package in Oracle and calling UTL_DBWS web services through Oracle database

Starting background process GTX4 and GLOBAL_TXN_PROCESSES

stick the job to the specific instance in Oracle RAC