clone CDB and rename PDB [message #678558] |
Fri, 13 December 2019 09:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 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.
|
|
|