Question with a case stury example
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}';
I would like to do the same for a PDB. MY Big problem: I would like to clone the source PDB (pdbprod) in a container (CDBDEST), which has already two other pdbs (pdbtesta, pdbtestb) that have to stay available. The source PDB (pdbprod) also has to stay available.
I know these 3 ways but any of them correspond to what i want to do.
1) SQL> create pluggable database pdbprod_cpy FROM pdbprod@cdbsource_link
2) RMAN> duplicate pluggable database pdbprod as pdbprod_copy to CBDDEST from active database
3) RMAN> duplicate database to cdbdest pluggable database pdbprod;
--for this solution I need a new & empty CDB
I repeat that CDBDEST and its pdbs has to stay available. The CDBDEST is not empty !
Is it possible to do it?
Thank you for your help.
Kind regards
C.R.