Oracle Cloud Infrastructure Documentation

RMAN Cross-Platform Transportable PDB

This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and the Database service database are compatible.

To migrate an Oracle Database 12c PDB to a PDB in an Oracle Database 12c database on a Database service deployment using the RMAN cross-platform transportable PDB 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 on the cloud database.

  3. On the on-premises database host, invoke RMAN and connect to the root. Execute the BACKUP FOR TRANSPORT PLUGGABLE DATABASE command.

  4. Use a secure copy utility to transfer the XML file and the backup set to the Database service compute node.

  5. On the Database service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.

  6. the Database service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.

  7. the Database service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

For more information, see " Performing Cross-Platform Data Transport in CDBs and PDBs" in Oracle Database Backup and Recovery User's Guide for Release 12.2 or 12.1.