Skip to Content

Oracle Upgrade 10g to 12c with Data Guard

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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 08, 2016 at 03:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded