1. Administering Oracle Database Classic Cloud Service
  2. Migrating Oracle Databases to Database Classic Cloud Service
  3. Migration Methods
  4. Unplugging/Plugging a PDB

Unplugging/Plugging a PDB

You can use this method only if the on-premises platform is little endian, and the on-premises database and Database Classic Cloud 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 an Oracle Database Classic Cloud Service database deployment.

If your source PDB is encrypted, you must export the master encryption key and then import it on the database deployment. See Exporting and Importing a Master Encryption Key for a PDB for details.

To migrate an Oracle Database 12c PDB to a PDB in the Oracle Database 12c database on a Database Classic Cloud 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 Database Classic Cloud Service.

  3. Use a secure copy utility to transfer the XML file and the datafiles to the Database Classic Cloud Service compute node.

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

  5. On the Database Classic Cloud 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.