This discussion is archived
6 Replies Latest reply: Apr 11, 2012 6:27 AM by mseberg RSS

upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place

618746 Newbie
Currently Being Moderated
Hi All,

We have configured Oracle DG 10.2.0.1 on Oracle Sun Sparc machine with 2 Physical Standby in place.
Now we want to upgrade the whole DG Environment (Primary and all physical Standbys) to 10.2.0.4

Shall we upgrade standby first and then primary DBs.
Can anybody give me the steps.
Kindly suggest.

Regards,
Muhammad Shakeel Azeem
  • 1. Re: upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl follow the steps in the README for 10.2.0.4. This MOS Doc may also be helpful.

    Applying Patch Sets / Interim Patches with Physical Standby Database in Place in Oracle 9i [ID 187242.1]     
    How do you apply a Patchset,PSU or CPU in a Data Guard Physical Standby configuration [ID 278641.1]     
         

    HTH
    Srini
  • 2. Re: upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place
    mseberg Guru
    Currently Being Moderated
    Hello;
    Disable log shipping from the Primary
    Shutdown Standby
    Install patch software on Standby
    Startup Standby in recovery mode (do NOT run any SQL at the standby)
    Shutdown Primary
    Install patch software on Primary
    Run SQL for patch on the  Primary
    Re-enable log shipping
    Monitor the redo apply from Primary
    As you can see all you really do is install software on the Standby and let the redo apply handle the rest.


    Please close your question(s) when complete.

    Best Regards

    mseberg
  • 3. Re: upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place
    Shivananda Rao Guru
    Currently Being Moderated
    Please refer the MOS document *How To Upgrade A Primary Database And A Physical Standby To Oracle10gR2 (10.2) [ID 407040.1]*

    Please update us about your other thread standby redologs on Physical Standby

    If you feel that your doubt has been clarified, then provide appropriate points and close the thread rather than keeping it open.
  • 4. Re: upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place
    618746 Newbie
    Currently Being Moderated
    Hi All,
    I have followed the steps outlined in the following metalink note
    How To Upgrade A Primary Database And A Physical Standby To Oracle10gR2 (10.2) [ID 407040.1]

    1. Stop the standby database from applying redo logs
    2. Stop the redo logs from being shipped
    3. Upgrade the executables for the primary database server
    4. Upgrade the executables for the standby database server
    5. Upgrade the primary database using DBUA or using the upgrade scripts (see Note:316889.1)
    6. Mount the standby database
    7. re-enable the shipping of redo from primary to standby
    8. restart the managed recovery process on the standby database to progress redo apply

    Upgrade was successful but i still have a confusion
    In Step 5 primary db has been upgraded (not the standby)
    why standby db not required to be upgraded?

    Another question:
    it takes time (e.g. 2 Hours) to upgrade primary db which is not acceptable in production
    i think we should upgrade standby db first ,switchover to standby(just upgraded) and then upgrade the old primary
    Steps:

    1. At Standby Stop the standby database from applying redo logs
    2. At Primary Stop the redo logs from being shipped
    3- Stop all services (db,em,lsnrctl) at Standby
    4- Upgrade the executables for the standby database server
    5-Upgrade DB for the standby database server
    6-Switchover to Upgraded Standby
    7-Upgrade old primary

    Please suggest!

    thanks
  • 5. Re: upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place
    618746 Newbie
    Currently Being Moderated
    thanks
    I have successfully upgraded my DB by implementing the steps you provided but it requires some downtime based on db size (1-2hours)

    I think we can do
    1- upgrade physical standby first (using transient logical standby)
    2-switchover
    3- then upgrade the old primary

    Kindly comment

    regards,
    Muhammad Shakeel Azeem
  • 6. Re: upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place
    mseberg Guru
    Currently Being Moderated
    Hello again;

    Too complex.

    You install the software on the Primary and Standby and run either DBUA or the upgrade scripts on the Primary only.

    Restart ( Start Mount ) the Standby on the new Oracle home ( upgraded )

    Startup the Primary and let the redo apply upgrade the Standby.

    Simple.

    Best Regards

    mseberg


    h1. The last one I did was

    from Oracle 11.2.0.1 to 11.2.0.2.


    Pre-Upgrade - I ran the Pre-Upgrade Information Tool


    h2. Step by notes


    Step 1

    On the Primary database :

    alter system set log_archive_dest_state_2=defer;

    Step 2

    Shutdown the Standby database.


    SQL> alter database recover managed standby database cancel;

    Database altered.

    SQL> shutdown
    ORA-01109: database not open

    Step 3

    Install 11.2.0.2 on Standby (if not already done)

    Step 4

    Shutdown Primary

    Should be shutdown using old profile.

    Step 5

    Install 11.2.0.2 on Primary (if not already done)


    Step 6 and 7 ( were additional patches needed for 11 )

    p10157249_112020_Generic
    12828071


    Step 8

    Run dbua for the Primary database.

    Set profile to 11.2.0.2 and start dbua.

    Step 9

    Shutdown Primary and double check listener on both servers :


    ( Since I was using a new home I made copies for the new home and changed as needed )


    Step 10

    Startup Standby in recovery mode




    Step 11

    Monitor the redo apply from Primary to Standby --- this will also upgrade the Standby data dictionary


    After thoughts

    If using a new home made sure you have a copy of the password file there.


    On Oracle 11 watch out for problem noted in 977512.1

    Edited by: mseberg on Apr 11, 2012 8:20 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points