Thanks for the question, Steve.
Asked: May 12, 2020 - 8:01 pm UTC
Last updated: May 13, 2020 - 3:54 am UTC
Version: 12.1.0.2.0
Viewed 1000+ times
You Asked
We are migrating to the cloud. We have two databases, one 550GB (CP1) and one 150GB (CP2), both 12c. The databases have been combined in the cloud for simplification, creating PROD. We have done initial testing on PROD with a limited data set. The plan, so far, is to send a drive with full data pump dumps from both databases, CP1 and CP2, to our cloud group. A new production area will spun up, and the two dumps are to be imported into the new cloud PROD database. From the time of the data pump dumps we are to "capture" all changes to the two databases CP1 and CP2. After the new PROD database is established in the cloud, we are to then update it with the changes that were "captured" from the CP1 and CP2 databases since the initial data pump dump. Estimated time to "capture" data is approximately one week.
So the question is, what is the best approach, and tools to use, in accomplishing this task of capturing data, then applying it.
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment