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 Oracle Database Classic Cloud Service database are compatible.
To migrate an Oracle Database 12c PDB to a PDB in an Oracle Database 12c database on an Oracle Database Classic Cloud Service deployment using the RMAN cross-platform transportable PDB method, you perform these tasks:
-
On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.
-
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. -
On the on-premises database host, invoke RMAN and connect to the root. Execute the
BACKUP FOR TRANSPORT PLUGGABLE DATABASE
command. -
Use a secure copy utility to transfer the XML file and the backup set to the Database Classic Cloud Service compute node.
-
On the Database Classic Cloud Service compute node, invoke RMAN and connect to the root. Execute the
RESTORE ALL FOREIGN DATAFILES
command. -
the Database Classic Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the
CREATE PLUGGABLE DATABASE
command. -
the Database Classic Cloud 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.