In 18c, we can use RMAN command DUPLICATE to copy the PDB into an existing CDB. In previous releases we need to clone that to a new CDB and unplug and plug into a current CDB.
Only active database based duplication is allowed and only one PDB is supported. Log file name convert and spfile parameters also not supported.
Connect
AS TARGET
to the root of the source CDB as a common user with theSYSDBA
orSYSBACKUP
privilege.Connect
AS AUXILIARY
to the root of the destination CDB as a common user with theSYSDBA
orSYSBACKUP
privilege.DUPLICATE PLUGGABLE DATABASE pdb1dup TO cdb1
DB_FILE_NAME_CONVERT('cdb1','pdb1')
FROM ACTIVE DATABASE
SECTION SIZE 400M;
-Thanks
Suresh
Follow Me!!!