Oracle Cloud Infrastructure Documentation

Unplugging/Plugging a PDB

You can use this method only if the on-premises platform is little endian, and the on-premises database and the Oracle Cloud Infrastructure Database service database have compatible database character sets and national character sets.

You can use the unplug/plug method to migrate an Oracle Database 12c PDB to a PDB in an Oracle Database 12c database on a Database service database deployment.

To migrate an Oracle Database 12c PDB to a PDB in the Oracle Database 12c database on an Oracle Cloud Infrastructure Database service database deployment using the plug/unplug method, you perform these tasks:

  1. On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.

  2. On the on-premises database host, execute the ALTER PLUGGABLE DATABASE UNPLUG command to generate an XML file containing the list of datafiles that will be plugged in to the database on the Database service.

  3. Use a secure copy utility to transfer the XML file and the datafiles to the Databaseservice compute node.

  4. On the Database service compute node, invoke SQL*Plus and execute the CREATE PLUGGABLE DATABASE command to plug the database into the CDB.

  5. On the Database service compute node, open the new PDB by executing the ALTER PLUGGABLE DATABASE OPEN command.

For more information, see "Creating a PDB by Plugging an Unplugged PDB into a CDB" in Oracle Database Administrator's Guide for Release 12.2 or 12.1.