2 Replies Latest reply: Jan 14, 2013 9:31 AM by vlethakula RSS

    Upgrading dataguard database

    christian41936
      Hello,

      I administer a dataguard database, and I plan to make an upgrade of that database very soon.

      The version used is now:
      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
      PL/SQL Release 10.2.0.4.0 - Production
      CORE 10.2.0.4.0 Production
      TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
      NLSRTL Version 10.2.0.4.0 - Production

      I have as choice to apply the patch 49P [as explained in the Note 342443.1] 32-Bit Patch:13928775, or apply the 10.2.0.5.0 patch.

      The problems I list with the 10.2.0.4.0 version are:
      - the dbconsole is not secured
      - Bug 6347745: 10204/WIN: 10106 WINDOWS OMS ..DISK UTILIZATION SHOWS > THAN 100%

      Should I proceed directly with the 10.2.0.5.0 patch or not?

      Second question:
      I have printed the two readme and read all two carefully.
      How should I proceed for the dataguard?
      Stopping the primary, making the upgrade as noted in the readme file, relaunching the primary database ?
      Stopping the second server, making the upgrade as noted in the readme file, relaunching the standby database?

      Thanks for help, I will do the upgrade on the next few days
        • 1. Re: Upgrading dataguard database
          Rob_J
          Hello Christian,

          I have in-depth notes about [url http://ora00600.com/articles/data-guard-physical-standby-upgrade.html]upgrading from 10g to 11g with a physical standby database, which details exactly how I did it. And I also have written a [url http://www.ora00600.com/articles/10g-to-11g-database-upgrade.html]step-by-step oracle 10g to 11g upgrade guide

          Are you just updating the standby DBs? Are they physical or logical? With a physical standby you can't upgrade it without upgrading the primary DB, because it's an identical copy, unless there is a way that I don't know of?

          Also, personal opinion, why are you going to 10.2.0.5 and not up to 11g? 10g is out of support and if you are taking the time to make an upgrade you might as well go up the a newer version because you will just have to upgrade to 11 in the end anyway.

          Hope that helps,
          Rob
          • 2. Re: Upgrading dataguard database
            vlethakula
            Regarding upgrading a datagabase with physical standby in place

            http://docs.oracle.com/cd/E11882_01/server.112/e10700/upgrades.htm#CHDBJAGG

            Do you use dataguard broker ?