Oracle 11g standby database upgrade

[Former Member]

Hi All,

After Oracle 11g upgrade in Primary database for SAP ECC 6.0. How upgrade standby database where oracle running version 10.2.0.4 and SAP running version ECC 6.0.

Thanks

Manas

[Former Member]

Orkun - I suggest the third option is

Stop the log shipment process from Primary to secondary, upgrade your database on Primary, Install the 11G software on secondary, perform post upgrade steps, then start the log shipment (Here archive logs takes care of your DB upgrade).

With this option upgrade on standby can be skipped.

Regards,

Nick Loy

[Former Member]

Thanks Nick & Orkun .

Hi Nick,

At the point of time upgrade I start the database in mount mode that means in standby mode.

Thanks

Manas

[Former Member]

Hi Nick,

Your suggestion is ideal and feasible one. But as far as I understand from the first message, he already upgraded the primary. Because of this I didn't talk over your scenario.

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

Can you provided any document related to standby database upgrade?

Thanks

Manas

[Former Member]

Hi Manas,

Please find the information, below;

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/upgrades.htm#CHDGJIIA

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

Above document point no. 25

uses the command SQL> ALTER DATABASE OPEN;

If I run the above command after that I start the log apply.

any problem??

Thanks

Manas

[Former Member]

Hi Manas,

If you the data guard protection mode is "MAXIMUM PERFORMANCE", follow the guide, below;

http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/upgrades.htm#CHDGJIIA

Best regards,

Orkun Gedik

[Former Member]

Hi ,

I have no data guard protection mode it is normal standby database server.

Please suggest can I follow the your previous document???

Thanks

Manas

[Former Member]

Hi,

There are three protection modes, on Oracle;

1) Maximum Availability

2) Maximum Performance

3) Maximum Protection

It should be one of them. "Maximum Performance" is mostly used variant among of all. At least, at my customers.

Check the document, below to have detailed information abot protection modes;

http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/protection.htm

Best regards,

Orkun Gedik

[Former Member]

Hi,

There are two ways to upgrade standby. Find the major steps, below;

First one is; apply all the offline redologs. Stop the log shipment. Then, start the upgrade at the standby site. If there are some unapplied offline logs, you can apply them after the upgrade by chaning compatibility parameter. Then start the log shipment.

Second one is; stop the log shipment. Upgrade the database at the standby site. At the end of the respective upgrade, restore the database from primary system to the primary. Then start the logshipment

You can find the information in the document, below;

http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/upgrades.htm

Best regards,

Orkun Gedik