Home » RDBMS Server » Backup & Recovery » clone CDB and rename PDB
clone CDB and rename PDB [message #678558] Fri, 13 December 2019 09:54 Go to next message
jbeckstrom
Messages: 8
Registered: January 2011
Junior Member
We are just getting into multi-tenant and have a question about RMAN duplicate. We would clone using a backupset of the CDB so no active duplicate.

If I have source:
CDB1
PDB1_PROD

If I want target
CDB2
PDB1_TEST

What duplicate command do I run to duplicate CDB1 to CDB2 while renaming the PDB? We use an RMAN catalog so thinking of connecting to CDB2 and the RMAN catalog and running:

duplicate database CDB1 to CDB2

However, won't that create PDB1_PROD inside of CDB2
Re: clone CDB and rename PDB [message #678559 is a reply to message #678558] Fri, 13 December 2019 10:55 Go to previous message
John Watson
Messages: 8274
Registered: January 2010
Location: Global Village
Senior Member
I wouldn't do it that way. I would create a new CDB, and then clone the PDB into it.

If you really want to do it with an RMAN duplicate, you can rename the PDB afterwards. You could automate this with an AFTER CLONE ON PLUGGABLE DATABASE trigger.
Previous Topic: Usage of RMAN
Next Topic: Recover to Cloud VM DB Error
Goto Forum:
  


Current Time: Wed Jun 03 10:14:40 CDT 2020