Oracle 10gR2 Multi-Terabyte Database Cross-Plathform Migration Method
Date: Thu, 10 Apr 2008 11:08:32 +0300
We have one 10.2.0.3 database on Tru64(source, server A, location X) and another new AIX(target, server B, location Y). This is our CRM database, with xx TB data and 7*24 availability needs. To reduce the downtime of this multi-terabyte database cross-plathform migration, IBM advised an async change data capture method(this is not Oracle's CDC, IBM prefers to work with the company called Goldengate).
But Goldengate has several important constraints related to some Oracle native data types and table types. So we started to study a B plan, the summary of this plan is as below;
- take a tape backup of source database at Tru64(server A, location X) and restore it to target AIX(server B, location Y).
- mount AIX's filesystems to another Tru64(server C, location Y) over NFS.
- open restored database as a physical standby on Server C and apply archives to catch up production.
- activate database on Server C as primary.
- create a new instance on Server B(AIX).
- take tablespaces to read-only mode on Server C and export metadata(standart cross-platform transportable tablespace step 1).
- use RMAN convert command on Server B for the datafiles of Server C(in fact these files are on Server B and server C sees them over NFS).
- finish convert and import metadata on Server B, and open the database.
During these steps since the datafiles will be transfered over local area we plan to have at most 8 hours downtime.
We will be testing these steps in details, but I wanted to have your comments also.
http://www.freelists.org/webpage/oracle-l Received on Thu Apr 10 2008 - 03:08:32 CDT