This discussion is archived
5 Replies Latest reply: Dec 9, 2012 2:48 PM by Srini Chavali-Oracle RSS

4 TB database cross platform upgrade

vlethakula Expert
Currently Being Moderated
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
    808420 Explorer
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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