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

Home -> Community -> Mailing Lists -> Oracle-L -> DB Movement from Sun to AIX ?

DB Movement from Sun to AIX ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 25 Jul 2005 22:49:00 +0530
Message-ID: <B5587533FCBD4344ADB8290B3EDDA122072FFA85@kecmsg14.ad.infosys.com>

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

Received on Mon Jul 25 2005 - 12:23:04 CDT

Original text of this message

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