5 Replies Latest reply: Nov 23, 2012 7:34 AM by onedbguru RSS

    data migration from 10RAC to 11gRAC

    LANCERIQUE
      Hi Gurus,

      We need to migrate Data from 10gRAC to 11gRAC without downtime. Migration need to performed from AIX to LINUX i.e. Big to little endian format.Also, 10gRAC is non ASM where 11gRAC is using ASM for storage. Both DB are at different locations. Please let me know different approaches, ideas for the migration.


      Below are the specification's.

      Old DB

      DB - 10g RAC
      OS - AIX.
      DB prod size - 250GB
      Schema size - 150Gb

      New DB

      DB - 11g RAC
      OS - RHEL 6.2

      Regards,
      Nikhil Mehta.

      Edited by: LANCERIQUE on Nov 21, 2012 10:34 PM
        • 1. Re: data migration from 10RAC to 11gRAC
          P.Forstmann
          See Re: DB upgrade 11g without stop the database

          I think that you cannot use transient logical standby because of the platform change: but you should be able to use Streams or Golden Gate.

          Edited by: P. Forstmann on 22 nov. 2012 13:10
          • 2. Re: data migration from 10RAC to 11gRAC
            LANCERIQUE
            Hi Forstmann,

            Thanks for your reply.

            We are not having provision for golden gate. Is it possible to use any of the 11gR2 features like RMAN, impdp, traditional imp/exp??

            Regards,
            NM
            • 3. Re: data migration from 10RAC to 11gRAC
              user12028775
              LANCERIQUE wrote:
              Hi Forstmann,

              Thanks for your reply.

              We are not having provision for golden gate. Is it possible to use any of the 11gR2 features like RMAN, impdp, traditional imp/exp??
              See this:
              http://levipereira.wordpress.com/2011/01/23/how-convert-full-database-10g-linux-x86-64bit-to-aix-64bit-different-endian-format/
              Old DB
              DB - 10g RAC
              OS - AIX.
              New DB
              DB - 11g RAC
              OS - RHEL 6.2
              We need to migrate Data from 10gRAC to 11gRAC without downtime.
              No, with RMAN is not possible without downtime. (zero downtime with cross-platform is pretty hard, why you need zero downtime????)
              • 4. Re: data migration from 10RAC to 11gRAC
                LANCERIQUE
                Thanks for your time.

                Zero down time is required as client don't want to have current production down impacting business. Idea is to make data migration online from DB end, change the pointers of current web,app server to new servers meanwhile take incremental backup on current production and then restore the same.

                Issue is we cant take incremental backup through exp/imp. If we take through RMAN, how we will change the backup to be compatible on cross platform.

                Regards,
                Nikhil Mehta.
                • 5. Re: data migration from 10RAC to 11gRAC
                  onedbguru
                  LANCERIQUE wrote:
                  Thanks for your time.

                  Zero down time is required as client don't want to have current production down impacting business. Idea is to make data migration online from DB end, change the pointers of current web,app server to new servers meanwhile take incremental backup on current production and then restore the same.
                  If this was like-for-like platforms, this might be a possibility. however, you now have an endian change making this tenuous at best. How big is the database? What is the schema complexity (ie: triggers, foreign key constraints etc...)?

                  Issue is we cant take incremental backup through exp/imp. If we take through RMAN, how we will change the backup to be compatible on cross platform.
                  You **might** be able to use expdp (data pump) - again depending on schema complexity. Bottom line is that there WILL be downtime and to expect ZERO downtime is quite unrealistic.
                  Regards,
                  Nikhil Mehta.