5 Replies Latest reply: Dec 9, 2012 4:48 PM by Srini Chavali-Oracle RSS

    4 TB database cross platform upgrade

    vlethakula
      I would like to know the best practices, here is the scenario:

      source:

      database size: 4TB
      storage : File system
      OS: Solaris
      Endian Format : Big
      DB version : 10.2.0.4

      Target:
      storage:ASM
      OS: Linux x86_64
      Endian: Little
      DB version: 11.2.0.3.2

      Edited by: vlethakula on Nov 21, 2012 1:34 PM
        • 1. Re: 4 TB database cross platform upgrade
          Alfonso Vicente
          The endian difference means you can't restore backup pieces with RMAN... you need to use other method like expdp/impdp or CTAS

          Approach 1: expdp to filesystem -> scp -> impdp from filesystem (very slow)

          Approach 2: expdp schema, create schema in the new database, create a db_link, and finally perform insert from select @olddb (slow and risky because REDO logs)

          Approach 3: Mount a NFS filesystem and use named pipes as expdp output an impdp input ... in this way you can move the database "on the fly"

          Approach 4: Migrate the 10g database to 11g, and then build a logical standby in the new system (see Standby Database on a Source and target of different endian formats

          In any way, you need to test very well the solution
          • 2. Re: 4 TB database cross platform upgrade
            onedbguru
            First of all, doing a file-by-file conversion of a 4TB db is going to be very painful. I would try to stay with Solaris if I could - the systems are much more robust in terms of sheer CPU and I/O performance. But, companies don't always make the right choices.

            I would test this a couple of times before I would call it good. That being said, start here:

            http://docs.oracle.com/cd/B19306_01/backup.102/b14191/dbxptrn.htm
            http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-platformmigrationtts-129296.pdf

            While the version is 10.2 in these docs, they still apply in 11gR2.
            • 3. Re: 4 TB database cross platform upgrade
              Victor Armbrust
              I just done the same migration few months later (difference it was to exadata)

              I would suggest you to use TTS (transportable tablespace) it is the most effective way.

              You should use the MOS note below



              How to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1]    

              - Check platform

              SQL> COLUMN PLATFORM_NAME FORMAT A32
              SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM;

              PLATFORM_ID PLATFORM_NAME                    ENDIAN_FORMAT
              ----------- -------------------------------- --------------
                        1 Solaris[tm] OE (32-bit)          Big
                        2 Solaris[tm] OE (64-bit)          Big
                        7 Microsoft Windows IA (32-bit)    Little
                       10 Linux IA (32-bit)                Little
                        6 AIX-Based Systems (64-bit)       Big
                        3 HP-UX (64-bit)                   Big
                        5 HP Tru64 UNIX                    Little
                        4 HP-UX IA (64-bit)                Big
                       11 Linux IA (64-bit)                Little
                       15 HP Open VMS                      Little
                        8 Microsoft Windows IA (64-bit)    Little
                        9 IBM zSeries Based Linux          Big
                       13 Linux 64-bit for AMD             Little
                       16 Apple Mac OS                     Big
                       12 Microsoft Windows 64-bit for AMD Little
                       17 Solaris Operating System (x86)   Little


              To convert datafiles you should use RMAN CONVERT

               CONVERT DATAFILE
              '/oradata/orsfzpr/datafile/tbs_data_02.299.722854833',
              '/oradata/ORSFZPR/datafile/o1_mf_tbs_data_6ng6q008_.dbf',
              ...
              ....
              ....
                    TO PLATFORM="Linux x86 64-bit"
                    FROM PLATFORM="HP-UX IA (64-bit)"
                    FORMAT '+DATA/db/datafile/%u_%p_%c'
                    PARALLELISM=20;

              It is not a complicated procedure but you shoulday attention in every step in order to convert the database from Solaris to Linux.

              I wrote a full step by step to do this migration however it is in portuguese.

              Victor
              • 4. Re: 4 TB database cross platform upgrade
                mrmessin
                Have you considered the use of Golden Gate, that might be an option for the migration of such a large database to minimize the downtime.
                • 5. Re: 4 TB database cross platform upgrade
                  Srini Chavali-Oracle
                  There are various options discussed in this presentation that show you how to limit downtime.

                  http://apex.oracle.com/pls/apex/f?p=202202:2:::::P2_SUCHWORT:migrate112

                  Almost all of them, like the use of Goldengate, will require additional licenses/costs, which may or may not be affordable.

                  HTH
                  Srini