6 Replies Latest reply: Nov 2, 2012 7:42 PM by Satishbabu Gunukula RSS

    Methods of database upgrade

    user503988
      Please let me know which one is the best and most convinient way of upgrading a database and why?

      1. DBUA
      2. Manual upgrade by catupgrd.sql
      3. Export Import
      4. DB links
        • 1. Re: Methods of database upgrade
          Srini Chavali-Oracle
          Pl post details of OS and database versions on source and target.
          user503988 wrote:
          Please let me know which one is the best and most convinient way of upgrading a database and why?

          1. DBUA
          This is the recommended approach as all tasks are automated
          2. Manual upgrade by catupgrd.sql
          This requires manual running of many scripts, and is prone to human errors
          3. Export Import
          See #2 above (there are some advantages to this approach - see doc link below)
          4. DB links
          Pl elaborate on how one can upgrade using database links

          http://docs.oracle.com/cd/E11882_01/server.112/e23633/preup.htm#i694345

          HTH
          Srini
          • 2. Re: Methods of database upgrade
            moslee
            It really depends on your scenario, such as the available business downtime, dataabse size, network transfer rate etc..

            You can refer to Oracle document "Different Upgrade Methods For Upgrading Your Database - ID 419550.1" to understand each method in details.
            • 3. Re: Methods of database upgrade
              kuljeet singh -
              user503988 wrote:
              Please let me know which one is the best and most convinient way of upgrading a database and why?

              1. DBUA
              2. Manual upgrade by catupgrd.sql
              3. Export Import
              4. DB links
              it also depend on your database size,small size few GB database can be upgrade easily by expdp/impdp.
              • 4. Re: Methods of database upgrade
                Satishbabu Gunukula
                If the database is big i would recommend using DBUA, i dont recommend using manual as it can lead to human errors.
                If the database is small then go for export/import as you no need to run pre-upgrade, post-upgrade steps...etc. Instead of export/import i would recommend datapump.

                Regards,
                http://www.oracleracexpert.com
                See the solution for ORA-19755 during recovery/DB startup
                http://www.oracleracexpert.com/2009/09/ora-19755-could-not-open-change.html
                Oracle data pump export/import with examples.
                http://www.oracleracexpert.com/2009/08/oracle-data-pump-exportimport.html
                • 5. Re: Methods of database upgrade
                  Srini Chavali-Oracle
                  How "big" is big ? How "small" is small ? In some shops, 1 TB would be small, while in others 250 G would be big.

                  HTH
                  Srini
                  • 6. Re: Methods of database upgrade
                    Satishbabu Gunukula
                    I hope you know each shop has its own measurements. If I give some size based upon my exp, it may not for him.
                    The user has to make his assessment based upon his downtime/mainteance window.

                    Hope this helps,

                    Regards,
                    http://www.oracleracexpert.com
                    RMAN Debug and Trace
                    http://www.oracleracexpert.com/2012/11/rman-debug-and-trace.html
                    Time for Change: Migrate your Non-RAC Database to RAC
                    http://www.oracleracexpert.com/2012/10/time-for-change-migrate-your-non-rac.html