Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB

    Oct 19, 2017 10:59:07 AM by Skant Gupta

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


    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: 

    Tags: Oracle Cloud DBaaS

    Skant Gupta

    Written by Skant Gupta

    Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. He is also Technical Writer on http://www.oracle.com/technetwork/es/articles/index.html and http://www.oracle.com/technetwork/pt/articles/index.html with more than 30 article published in Oracle Technical Network.