Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migrating 3TB size database from HP to AIX, also 9i to 10g.

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

From: John Hallas <john.hallas_at_bjss.co.uk>
Date: Wed, 19 Sep 2007 12:46:37 +0100
Message-ID: <E02CB9B2777CF8459C86C49B48C48EC6024B6058@exchange.bjss.co.uk>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain Sent: 19 September 2007 11:44
To: oracle-l_at_freelists.org
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


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 19 2007 - 06:46:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US