RE: DB Movement from Sun to AIX ?

Vivek,  

Your best bet (for speed) is probably a combination of CTAS and export/import.  

First of all, you can probably move all of your lookup and reference tables anytime.

Secondly, I would begin to look at the big tables. Are any partitioned? Are some of the partitions old and not updateable any more? Do any of the large tables contain very old data that can be moved now via a where clause (where create_date < 1990)?  

And then for maximum thoughput, I would probably perform CTAS on several tables at the same time along with export/import for the really large tables.  

It's all a matter of slicing the pie to make sure you can perform the whole thing in the time given to you. Don't forget to take into consideration the creation of the indexes as part of the time you need to get this thing done.  

Good Luck!  

Tom  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Monday, July 25, 2005 1:19 PM
To: oracle-l_at_freelists.org
Subject: DB Movement from Sun to AIX ?  

Folks  

Need to migrate an Online (near 24x7) Hybrid application from 8.1.7 on Sun to 9.2 on AIX.  

Source Database is on Sun with Oracle 8.1.7

Target DB needs to go to AIX on Oracle 9.2

DB size - 1 TB approx

Application - Online Hybrid Banking Application

Num of Users - a few thousand Bank Staff users

Application is NOT on the internet. Hence can be brought down for about 6-8 hours  

What are the advisable Options?  

1. Is Shareplex Tool from Quest Software a Good Option? Has it been tried & Tested?

How does it go about replicating the Database across the heterogeneous O.S. given the large amount of existing Historical data in the database?  

2) Export/import  

3) CTAS over DB Link - Will it be fast enough as compared to export/import with a 1 GB interconnect between the SUN-AIX machines?  

(Transportable Tablespaces seemingly do NOT work across Unix Flavors in Oracle 9.2)  

I will provide any info needed.  

Thanks in advance  

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l