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

Last updated on MARCH 10, 2023

Applies to:

Goal

   The following steps will show you how to perform a backup of a container database (CDB), including only the pieces required to migrate a subset of pluggable databases (PDB) with no disruption of application activity to the source PDBs.  The backup and all datafiles contained in it will be consistent to a single point in time.  Other than during the database backup, this operation requires no connection to the source CDB.  The process makes use of Oracle Recovery Manager (RMAN) functionality to create the backup and create a clone of the CDB and specific PDBs within that container database.  Once the CDB clone is created, the PDB(s) in the clone can be unplugged and plugged into a different CDB. 

   The RMAN backup can be created while the source CDB and PDB are active.  Archive logs are included in the backupset to ensure that the cloned CDB can be recovered to a consistent point in time.  Upon completion, the backup can be made accessible to some other heterogeneous hardware to be used for the restore process. 

   The RMAN DUPLICATE functionality is used to create the clone of the CDB.  It uses data from the backupset to determine the consistency point for recovery and which datafiles need to be restored and which datafiles should be skipped and removed from the clone.  This process is viable for Oracle RDBMS 12.1.0.2 and later.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.