RE: Migrating 3TB size database from HP to AIX, also 9i to 10g.

From: "Powell, Mark D" <mark.powell@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 19 Sep 2007 11:55:28 -0400

If the 3T of data is spread across numerous objects I would consider
going back to the first plan but running a series of concurrent exports
into named pipes.  then I could grad these named pipes via a remote copy
(rcp) command into a named pipe on the new server from which I would
start a background imp task.
 
You are now concurrently exporting and importing and you can run a set
of these job tasks in parallel to reduce total necessary clock time.
 

-- Mark D Powell -- 
Phone (313) 592-5148 

 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Hallas
        Sent: Wednesday, September 19, 2007 7:47 AM
        To: sjaffarhussain@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
        Subject: RE: Migrating 3TB size database from HP to AIX, also 9i
to 10g.
        
        

        Once you get to 10g on HP you can use datapump which is much
faster

        Can a lot of the data be migrated in advance, i.e historical
data , leaving the current data to be moved during the planned outage.

         

         

        
________________________________


        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain
        Sent: 19 September 2007 11:44
        To: oracle-l@xxxxxxxxxxxxx
        Subject: Migrating 3TB size database from HP to AIX, also 9i to
10g.

         

        Hello list,

         

        I have a uphill taks of migrating our datawarehouse Oracle 9i
database, 3TB size, from HP Superdom to AIX, Oracle 10g.

        Since the migration is across platofrms, exp/imp is the obvious
option. But, 3TB size databse, exp/imp may take just too much time.

         

        I have thought the following:

         

        Upgrading 9i database on AIX to 10g (in place upgrade)

        Then, using the method of database cross platform conversion
from HP to AIX.

         

        The problem with this method is that the temporary space
required to hold the converted data files, it willd be difficult to have
3tb temporary sapce.

         

        Do you see any another solution for this task?

         

        Regards,

         

         

        Jaffar

        -- 
        Best Regards,
        Syed Jaffar Hussain
        Oracle ACE
        8i,9i & 10g OCP DBA
        
        http://jaffardba.blogspot.com/
        
http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:
126
        
------------------------------------------------------------------------
----------
        "Winners don't do different things. They do things differently."


        
________________________________


        BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1
2TW.
        Registered in England with company number 2777575.
        http://www.bjss.co.uk

References:
- RE: Migrating 3TB size database from HP to AIX, also 9i to 10g.
  - From: John Hallas

RE: Migrating 3TB size database from HP to AIX, also 9i to 10g.

Other related posts: