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/E...s.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.

DG problem wrote:
What is to be gained by upgrading on the same system? During a major
upgrade like this I would also take the opportunity to upgrade to the
latest stable version of your operating system as well since it's
probably several years stale, too. In that case, you'd want to use the
export/import data pump (expdp and impdp) commands to first export your
db from Oracle db version 9, install the new OS and db revs, then
import your data. If you have a physical standby you could always use
it as the basis for the new OS and software so you still have the
original old versions as a fallback just in case.

-Gary

On Aug 24, 2:16*pm, Gary <ga... (AT) efn (DOT) org.spamsux> wrote:
The OS for both the production and DR site will be upgraded to the
latest version before 11g is installed. Once 11g is fully installed I
will be upgrading both databases and thus I was wondering if anyone
else had followed the procedure that I had referenced. I'm guessing
that upgrading 2TB of database on both sites would take less than a
weekend, and hopefully under 8 hours. Data Pump would take much much
longer, probably closer to a week?

I'm a bit rusty on Data Pump as I haven't used it for nearly four
years Is it possible to expdp on a 9i database? Isn't it
recommended to use the same version exp as the database? Are there
some new features of Data Pump that allow it to effectively clone a
running production database to 11g? Now that would be funky

At the moment I'm still leaning towards a weekend of downtime and
upgrade using the standard Oracle procedures.