Duplicating a PDB to an existing CDB at a point in time in the recent past

Let's say I have a CDB with 3 PDB's.

Something happens yesterday, a bug, an erroneous update, whatever and I need to restore just ONE of my PDB's to yesterday at noon to test or dev for troubleshooting.

I am not sure how I restore just the ONE PDB to yesterday at 11:59 so I can see the data as it existed at that time.

I am aware of several different means of transferring data from Prod to Test but none of them go back 24 hours (that I'm aware of).

1. Export Prod / Import to Test (good for current data, not for yesterday)
2. Duplicate the PDB over a database link (this is current data, not yesterday)
3. Restore the whole CDB to another database, unplug the PDB you want, plug it into test (this blows my mind, that means I need to provision double the disk space just for this process).

So, short of doubling disk allocation to the server to perform #3, is there any other way to duplicate a PDB from Prod to test to a point in time in the past.

I have been reading all I can find in the Documentation and notes at Oracle Support but I'm not finding any ideas here with a clear example.

I have raised an SR with Support, but the engineer I'm working with isn't giving me a lot of information and what I am getting back are short one sentence answers.

I have seen some pages on assorted sites like:

https://oracle-base.com/articles/12c/recovery-manager-rman-database-duplication-enhancements-12cr1 https://oracle-base.com/articles/18c/multitenant-duplicate-a-pdb-to-an-existing-cdb-18c

Oracle Documentation on this is here:
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-duplicating-databases.html#GUID-23205E75-CFA8-4BCE-AC50-3D39DF040512

Maybe I'm misunderstanding what "FROM ACTIVE DATABASE" is meaning here. Can you combine UNTIL TIME or UNTIL SCN with FROM ACTIVE DATABASE to make it go read the RMAN catalog info from Prod and do the appropriate things to the new PDB in test ?

My ability to play with this is a little limited. The database I'm copying is 600 or 700 GB so anything I try isn't exactly a quick test.

Would appreciate insights from anyone running in this kind of configuration, the whole PDB thing is relatively new to me, we're just starting to look at converting from a non-CDB architecture into the multi-tenant world.

If it makes any difference, this is hosted in Oracle Cloud (but I don't have access to the cloud console).

Thanks
Steve

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived.

--
http://www.freelists.org/webpage/oracle-l






(image/gif attachment: image001.gif)