Remote Hot Restore / Duplicate of PDB setting a UNTIL TIME timestamp
Hi,
Question with a case study
- CDBSOURCE containing one PDB (pdbprod)
- CDBDEST containing 2 PDB (pdbtesta, pdbtestb)
I would like to find a way to duplicate/restore/clone the pdbprod@CDBSOURCE in CDBDEST but with an older timestamp than the current one.
So if today we are the 21-DEC-22 11.00am, I would like to have to copy pdbprod in the CDBDEST container set UNTIL TIME 21-DEC-22 08:00am.
With a non-cdb, I was using the following command with RMAN.
set until time "to_date('${TIMESTAMP}','${NLS_DATE_FORMAT}')" duplicate database SOURCEDB to TESTDB backup location '${BKPDIR}';