Thanks for the question, Rajeshwaran.
Asked: September 19, 2017 - 1:15 am UTC
Last updated: September 19, 2017 - 5:58 am UTC
Version: 11.2.0.2
Viewed 1000+ times
You Asked
Team:
We have two oracle databases
Source database - DB1 running on HP Unix platform, version is 11.2.0.2 having 20+ TB of data.
Target database - DB2 running on Linux platform, version is 11.2.0.4 having no data for now.
Our goal is to clone (a subset of 25 schema) from Source database to Target database.
the size of those 25 schema in the source database is around 14+ TB.
Here are the options we are planning for this activitiy.
a) RMAN Duplicate database - then drop the un-needed schema in the Target database , not sure if that can be used in a cross platform - please confirm.
b) Transportable Tablespaces from Source to Target, and then drop the un-needed schema in the Target database
c) Datapump Export from the source for the subset of 25 schema and then import them back into the Target database.
We also have licensed for Oracle Golden Gate on both Source and Target database, can that be used for this clone activitiy ?
Please help us with the easy/fast/right option to clone from Source database to Target database with minimal downtime/resource.
Also let us know if we have any other alternate option in addition to the above.
with LiveSQL Test Case:
and Connor said...
I was involved in a cross-platform migration from AIX to Linux.
You can see the details of that here
https://connor-mcdonald.com/2015/06/06/cross-platform-database-migration/ (After plenty of testing) I found the process very reliable, easily repeated, and small downtime.
So for me, I'd be recommending cross-platform transportable tablespaces (using RMAN to convert the files) plus cross-platform incremental backups.
One thing to check is whether 11.2.0.2 is viable for this strategy - you'd need to speak to Support on that one.
Others welcome to add their thoughts.