Skip to Main Content
  • Questions
  • Applying database changes after implementation of a full data pump dump

Breadcrumb

Question and Answer

Connor McDonald

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...

I'd strongly advise taking a look at our migration options.

https://www.oracle.com/au/database/technologies/cloud-migration.html

Many of the options have facilities that do a lot of the heavy lifting for you, whilst still using the technology you're familiar with (Data Pump etc).

But in a nutshell, to minimize downtime (and use DataPump) you'd be looking at

- take consistent exports and loading them into the target cloud environment
- noting the SCN point of that consistency
- Using Goldengate to transmit changes from that SCN point up to your cloud database and applying them there
- Then deciding on a cutover.

More details here

https://docs.oracle.com/en/middleware/goldengate/core/18.1/oracle-db/replicating-data-oracle-autonomous-data-warehouse-cloud.html#GUID-660E754E-B9A6-48DD-AA66-0D6B66A022CD



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.