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