My Oracle Support Banner

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

Last updated on AUGUST 13, 2024

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Expectation is that the reader is familiar with the concepts of Oracle Multitenant and Oracle Recovery Manager (RMAN) and basic terminology and functionality.






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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Considerations
 Process
 Source Backup
  Destination Restore
References

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