Skip to Content
avatar image
Former Member

How to upgrade oracle 10g to 11g considering the data-guard

Hi All,

We had sucessfully upgraded our development and quality environment from 10G to 11G; but our production environment is consist of ORACLE DATA GUARD so in that case how to upgrade the oracle database in standby server without recreating it?

From,

Ketan Kapadi

+91-9099956182

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 29, 2012 at 08:51 AM

    Hi Ketan,

    Check the document, below;

    http://docs.oracle.com/cd/E11882_01/server.112/e17022/upgrades.htm

    It has been explained very well, in the steps.

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      As I understand it :

      - You "synced" your db in 10g right before upgrading the rdbms and dictionnary on your primary.

      - You installed the binaries on the primary and played the dbua script on your primary. This lead to generating archived log.

      - You installed the 11g binaries on your standby db.

      The next step would be to set the environment variables on your standby db to use 11G binaries.

      Then you copy the "dbua" generated archived logs to your standby and restart the "recover managed standby database" in order to get them back in sync on 11g.

      Best regards,

      Steve.