Database Administration (MOSC)

MOSC Banner

Remote Hot Restore / Duplicate of PDB setting a UNTIL TIME timestamp

edited Dec 21, 2022 4:06PM in Database Administration (MOSC) 5 commentsAnswered

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}';

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