Database DataWarehousing (MOSC)

MOSC Banner

How to create point in time PDB copy to another PDB?

Hello,
I have a Oracle 19c Exadata OCI Gen2 database using ASM. I have a requirement to create a point in time copy of a pdb as another pdb. There is a monthly application process that updates the pdb and business requires the copy to be as of the time that  monthly application process finishes. 
I have tried the following:
1) create pluggable database pdb2 from pdb1 - pluggable created in 15 minutes and pdb2 data was as of time that create pluggable finished. business rejected since there are updates that occur during this 15 minutes and did not want these updates in pdb2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center