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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Orkun Gedik,

Thank you very much for your support in our case following scenario exist,

Upgrading Oracle Database with a Physical Standby Database in Place

I am looking for more details on it specific to sap guide or sap note  can any one please provide more brief on that.

From,

Ketan Kapadi

[Former Member]

Hi Ketan,

As far as I know that there's no official SAP document regarding your case. On the other hand, you can check the document, below;

http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-transientlogicalrollingu...

Moreover, there are many resources over the internet, suitable with your needs.

Best regards,

Orkun Gedik

[former_member182307]

Hello,

SAP does not provide any guide related to this kind of upgrade.

You'll have to follow Oracle documentation provided by Orkun .

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

Best regards,

Steve.

[Former Member]

Dear All,

We have stopped SAP and Oracle and all its services both side i.e primary and secondary, and check the archived log sequence both in sync mode. after that we have upgraded oracle primary server  and run the dbua script in archive mode and copy that all archive log to dr site, install oracle binaries and apply opatch at DR side now how to apply this archive log?

From,

Ketan Kapadi

[former_member182307]

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.