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