Upgrading Oracle Database with a Logical Standby Database In Place [ID 437276.1]
		修改时间 01-JUN-2009     类型 HOWTO     状态 PUBLISHED

In this Document
  Goal
  Solution
  References

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.3 to 11.1
Information in this document applies to any platform.
The instructions within this document are supported for the following upgrade scenarios:

10.1.0.x => 10.1.0.x
10.1.0.x => 10.2.0.x
10.2.0.x => 10.2.0.x
10.x.x.x => 11.1.0.x

Goal

This document describes the traditional method for upgrading your Oracle Database software with a logical standby database in place. A second method in Chapter 12, "Using SQL Apply to Upgrade the Oracle Database" of the Data Guard Concepts and Administration guide describes how to upgrade with a logical standby database in place in a rolling fashion to minimize downtime. Use the steps from only one method to perform. the complete upgrade. Do not attempt to use both methods or to combine the steps from the two methods as you perform. the upgrade process.

Solution

Perform. the following steps to upgrade to the newest release of the Oracle Database when a logical standby database is present in the configuration:

1. Review and perform. the steps listed in the "Preparing to Upgrade" chapter of the Oracle Database Upgrade Guide or in the appropriate patchset README.
   
   
2. Set the data protection mode to MAXIMUM PERFORMANCE at the primary database, if needed:
   
   SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
   
   
3. On the primary database, stop all user activity and defer the remote archival destination associated with the logical standby database. (For this procedure, it is assumed that LOG_ARCHIVE_DEST_2 is associated with the logical standby database):
   
   SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER SCOPE=BOTH;
   
   
4. Stop SQL Apply on the standby database:
   
   SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;
   
   
5. On the primary database install the newer release of the Oracle software as described in the Oracle Database Upgrade Guide or appropriate patchset README.
   
   
6. On the logical standby database, install the newer release of the Oracle software as described in Oracle Database Upgrade Guide or appropriate patchset README.
   
   Steps 5 and 6 can be performed concurrently (in other words, performed at the same time) to reduce downtime during the upgrade procedure.
   
   
7. On the upgraded logical standby database, restart the database and restart SQL Apply. If you are using Oracle RAC, start up the other standby database instances:
   
   If the upgrade was done to any release of 10.2.0.x, the following will need to be set on the logical standby to avoid ORA-1403 on startup of SQL Apply:
   
   SQL> ALTER SYSTEM SET EVENTS '1348 trace name context forever, level 1073741824';
   
   Once SQL apply has successfully started, this event will be unset on the next instance bounce or by stopping SQL apply again and running:
   
   SQL> ALTER SYSTEM SET EVENTS '1348 trace name context off';
   
   
   
   SQL> STARTUP
   SQL> ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
   
   If standby redo logs were not configured on the logical standby, the IMMEDIATE clause should be dropped.
   
   
   
8. Startup the upgraded primary database and allow users to connect. If you are using Oracle RAC, start up the other primary database instances.
   
   Also, enable archiving to the upgraded logical standby database, as follows:
   
   SQL> STARTUP
   SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
   
   
9. Optionally, reset to the original data protection mode if you changed it in Step 2.

References