Upgrade from 9i to 11g with a physical standby as well

From: DG problem <skatefree_at_gmail.com>
Date: Tue, 17 Aug 2010 18:56:34 -0700 (PDT)
Message-ID: <2416c411-d296-4694-8df5-1b9d2dffca40_at_f6g2000pro.googlegroups.com>



HP-UX, 9.2.0.8 (still) EE, Running a physical standby

I'm just confirming the Oracle documentation and I'm also looking for any extra tips in particular about upgrading from 9i to 11g with a standby as well.

What home should be used when mounting the standby in step 8?

Has anyone done this before from 9i to 11gR2?

http://download.oracle.com/docs/cd/E11882_01/server.112/e10700/upgrades.htm#CHDBJAGG

B.2 Upgrading Oracle Database with a Physical Standby Database In Place

Perform the following steps to upgrade to Oracle Database 11g Release 2 (11.2) when a physical 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.
  2. Shut down the primary database.
  3. Shut down the physical standby database(s).
  4. Stop all listeners, agents and other processes running in the Oracle homes that are to be upgraded. Perform this step on all nodes in an Oracle Real Application Clusters (RAC) environment.
  5. If Oracle Automatic Storage Management (Oracle ASM) is in use, shut down all databases that use Oracle ASM, and then shut down all Oracle ASM instance(s).
  6. Install the new release of the Oracle software into a new Oracle home on the physical standby database and primary database systems, as described in the Oracle Database Upgrade Guide.
  7. Restart all listeners, agents, and other processes stopped in step 4.
  8. Mount the physical standby database(s). Note: The standby database(s) should not be opened until the primary database upgrade is completed.
  9. Start Redo Apply on the physical standby database(s).
  10. Upgrade the primary database as described in the Oracle Database Upgrade Guide. Note that the physical standby database(s) will be upgraded when the redo generated by the primary database as it is upgraded is applied.
  11. Open the upgraded primary database.
  12. If Active Data Guard was being used prior to the upgrade, then refer to Section 9.2.1 for information about how to reenable it after upgrading.
Received on Tue Aug 17 2010 - 20:56:34 CDT

Original text of this message