Skip to Main Content
  • Questions

  • Restore pdb with different name (restore duplicate)

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Minneci.

Asked: January 18, 2023 - 12:43 pm UTC

Last updated: February 14, 2023 - 11:29 pm UTC

Version: 19c

Viewed 1000+ times

You Asked

Hi Tom,
I using Oracle EE 19c in CDB with several PDB.
Sometime i need to restore from RMAN backup of one PDB under different name (kind of cloning) from the original one, permitting at users to search and compare datas between the two (original and old restored).
Currently i doing in two steps, using another CDB "scratch", where i doing restore from backup ,and after from the good one i doing a copy of the PDB restored into the "scratch".
It's work but it's time consuming .

Could you sugest to me a better way ?
Thank you
Guido

and Connor said...

To my knowledge the auxiliary instance is still needed as per MOS

Cloning a Pluggable Database from an RMAN Container Database Backup (Doc ID 2042607.1)

but I'll ask around internally and update this answer if I get a simpler option

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

MOS opened too

Guido Minneci, February 14, 2023 - 10:39 am UTC

Hi Connor,
i also opened a SR to the support and no solution, must crossing another CDB+PDB to doing Restore P.I.T (RMAN) and than move/copy PDB.
I feel this like a big limitation of the product :-( i asked an evolution for future releases.

Thank you for your time.

Connor McDonald
February 14, 2023 - 11:29 pm UTC

thanks for updating the thread with your findings
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database