6 Replies Latest reply: Apr 11, 2012 8:27 AM by mseberg RSS

    upgrade from 10.2.0.1 to 10.2.0.4 with Physical Standby Database in place

    618746
      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
          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
            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
              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
                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
                  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
                    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