This article was written by Skant Gupta and Joel Perez in Oracle OTN.

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

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 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 Cloud 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. Creating the Database Cloud Service database.
  5. Use a secure copy utility to transfer the XML file and the backup set to the Database Cloud Service compute node.
  6. On the Database Cloud Service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.
  7. The Database Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.
  8. The Database Cloud Service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB: Example

This example is to migrate an On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB

In this example, the on-premises database is on a Linux host.

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

[oracle@cloud ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 4 11:47:11 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

If you want to read rest to the article, go across this link :Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB

If you want to be updated with all our articles send us the Invitation or Follow us:



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.