Oracle Upgrade 10g to 12c with Data Guard

[former_member204618]

Hi All,

Me again.

I am now looking at how to upgrade our production environment which uses Oracle Data Guard.

I've read Upgrading Databases in a Data Guard Configuration which applies to 11g but presumably this is also true for 12c?

How do you perform the install on the physical standby? 

From the document it says shutdown both primary and standby install Oracle on standby then mount the standby database. 

From SAP perspective presumably before mounting apply SBP's.

Mount from the new Oracle home?

Then install and upgrade the primary database and the upgrade will transfer to the standby via the redo logs.

Is it really that simply?

Thanks

Craig

[Reagan · Accepted solution]

The installation is an online operation as you install the software to a new filesystem and it is a same like you do on the primary DB node. You do not need the databases to be shutdown.

The steps in short

1 - Install Oracle on Primary and Standby

2 - Apply the latest SBP on Primary and Standby

3 - Perform the pre-upgrade tasks on primary

Before starting the upgrade on Primary using DBUA

4 - Adapt the environment variables of the Standby database for the Oracle user

5 - Restart the Standby in mount with the new ORACLE_HOME

6 - Put the standby into managed recovery operation

7 - Upgrade the Primary

[former_member204618 · Accepted solution]

Hi Reagan

Perfect thanks very much, I thought it might be like that but just wanted to be sure.

Thanks

Craig