Oracle Data Guard cpu/psu Patch Installation Tutorial

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.