1. Administering Oracle Database Classic Cloud Service
  2. Migrating Oracle Databases to Database Classic Cloud Service
  3. Migration Methods
  4. Remote Cloning Non-CDB

Remote Cloning Non-CDB

You can use this method only if the on-premises platform is little endian, the on-premises database release is 12.1.0.2 or higher, and the on-premises database and Database Classic Cloud Service database have compatible database character sets and national character sets.

You can use the remote cloning method to copy an Oracle Database 12c non-CDB on-premises database to a PDB in an Oracle Database 12c database on Oracle Database Classic Cloud Service.

To migrate an Oracle Database 12c non-CDB database to a Database Classic Cloud Service database deployment using the remote cloning method, you perform these tasks:

  1. On the on-premises database host, invoke SQL*Plus and set the on-premises database to READ ONLY mode.

  2. On the Database Classic Cloud Service compute node, invoke SQL*Plus and create a database link that enables a connection to the on-premises database.

  3. On the Database Classic Cloud Service compute node, execute the CREATE PLUGGABLE DATABASE command to clone the on-premises non-CDB database.

  4. On the Database Classic Cloud Service compute node, execute the $ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql script.

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

  6. Optionally, on the on-premises database host invoke SQL*Plus and set the on-premises database back to READ WRITE mode.

For more information, see "Cloning a Remote PDB or Non-CDB" in Oracle Database Administrator's Guide for Release 12.2 or 12.1.