Oracle Data Guard cpu/psu Patch Installation Tutorial

Non-Data guard patch installation tutorials refer to the [Oracle] cpu/psu patch installation tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows:

Stop log transport service at primary;

Close the standby database, standby software on the patch (note: Do not need to make a patch for the standby database), start standby for Mount state, do not enable managed recovery;

Close the primary, in the primary software and the database itself are patched;

Start the primary database and reopen the log transfer service;

In standby start Redo Apply, so that the primary patch script will automatically sync to standby;

Check to see if primary and standby have patches installed.

Here is a concrete example:

1. Stop log transport service at primary

Sys@epay>select database_role from V$database;  
      
Database_role  
----------------  
PRIMARY
      
sys@epay>show parameter log_archive_dest_3  
      
NAME                                 TYPE        VALUE  
-----------------------------------------------------------------------------  
log_ Archive_dest_3                   string      service=sta ASYNC valid_for= (O  
                                                 nline_logfiles,primary_role) D  
                                                 b_unique_ NAME=EPAYBK  
log_archive_dest_30                  string  
log_archive_dest_31                  string  
sys@epay>alter System set Log_archive_dest_state_3=defer Scope=both;  
      
System altered.

2. Patch The Oracle software in standby

2.1 Close Database instance, listener,asm instance, etc.

2.2 View the Opatch version, if not enough, to download the latest version

2.3 Patching on standby Oracle software

2.4 Boot standby to mount state, start listener

(Note: Standby does not need to be patched to the database itself)

3. Patching on the primary

3.1 Close database instance, listener,asm instance, etc.

3.2 View the Opatch version, if not enough, to download the latest version

3.3 Patching on primary Oracle software

3.4 Patching for the primary database itself

CD $ORACLE _home/rdbms/admin  
sqlplus/nolog  
sql> connect/as SYSDBA sql>  
STARTUP sql>  
@ Catbundle.sql PSU apply  
sql> QUIT