Migrate On-Premises Database to Oracle Cloud Database Using Remote Cloning

    Aug 24, 2017 8:43:00 AM by Skant Gupta

    This article shows how to use the remote cloning method to copy a pluggable database (PDB) from your on-premises Oracle Database 12c database to a PDB in a database-as-a-service (DBaaS) container database (CDB) in an Oracle Database Cloud Service deployment.

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

    Note: You can use this method only if the on-premises platform is little endian; the on-premises release is Oracle Database 12.1.0.2 or higher; and the on-premises database and Oracle Database Cloud Service database have compatible database character sets and national character sets.

    To copy an Oracle Database 12c PDB to a PDB in an Oracle Database Cloud Service deployment using the remote cloning method, you perform these tasks:

    1. On the on-premises database host, prepare the on-premises PDB by invoking SQL*Plus, closing the on-premises PDB, and then reopening the PDB in read-only mode.
    2. Create a new instance of Oracle Database Cloud Service.
    3. Connect to the Oracle Database Cloud Service compute node, invoke SQL*Plus, and create a database link that enables a connection to the on-premises database.
    4. On the Oracle Database Cloud Service compute node, execute the CREATE PLUGGABLE DATABASE command to clone the on-premises PDB.
    5. On the Oracle Database Cloud Service compute node, open the new PDB by executing the ALTER PLUGGABLE DATABASE OPEN command.
    6. Optionally, on the on-premises database host, invoke SQL*Plus and set the on-premises PDB back to read-write mode.

    The following sections provide a step-by-step demonstration of the tasks required to remotely clone an on-premises Oracle Database PDB into a new PDB in a DBaaS CDB.

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

     

    Prepare the On-Premises PDB

    1. On the on-premises database host, invoke SQL*Plus and log in to the on-premises database as the SYS user.

    [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>


    2. Close the on-premises PDB_PREM PDB.

    SQL> ALTER PLUGGABLE DATABASE pdb_prem CLOSE;
    Pluggable database altered.
    Open the on-premises PDB_PREM PDB in read-only mode.

    3. SQL> ALTER PLUGGABLE DATABASE pdb_prem OPEN READ ONLY;
    Pluggable database altered.

    For further Reading : Migrate On-Premises Database to Oracle Cloud Database Using Remote Cloning

    Source : Oracle Help

     

    Tags: Oracle Cloud

    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.