Customer environment: running on AIX oracle10G, 2 RAC node, the data quantity is 700 g.
Requirements: migration to Linux two-node RAC environment, about five hours down time window,
Ask: this kind of background, what kind of migration scheme using more reliable?

CodePudding user response:

Impdp estimates have enough time, I here last month 300 gigabytes of data, impdp + link_network about 7 hours;

Try the original poster cold backup and the speed of the RMAN,

Cold backup, this may not be able to work, a different operating system is the location of the high and low;

CodePudding user response:

Do you have any special Suggestions under the offer?
I now is box expdp and impdp, but calculation, not enough time to fully,
But if using RMAN, table space conversion transmission, is not complete,

CodePudding user response:

See if the original poster can put some history table, first migration in the past, finally left a small amount of data, five hours to run with it;

CodePudding user response:

Well, the way of historical data + real-time data is more practicable methods, I find customer understanding of the historical data,
In addition, enhanced XTTS, source side is 10 g R2, the target segment is 11 g R2, can work? What do you think,

CodePudding user response:

reference 4 floor kanon_lgt response:

well, the way of historical data + real-time data is more practicable methods, I find customer understanding of the historical data,
In addition, enhanced XTTS, source side is 10 g R2, the target segment is 11 g R2, can work? What do you think,

This across the large version of the migration, I also haven't seen XTTS experiment, test a few times more;

Before seen Yang Zhihong an article, is probably said terabytes of library use XTTS, 2, 3 hours is enough, you search for this article;

CodePudding user response:

Ok, thanks!!!!!

CodePudding user response:

The history table migration, plan feasible
Read-only data can also migrate first
Historical data can also be first migration in the partition table

CodePudding user response:

Now only the length of time required, when haven't finish requirements, also can do DG, online synchronous with first

CodePudding user response:

AIX to Linux DG can do? Cross-platform,

CodePudding user response:

Well, to learn more about business to handle, more time-consuming,