Oracle 12c遷移pluggable database到異庫

1.源庫：

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB  READ WRITE NO

4 TEST  READ WRITE NO

2.目標庫：

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB  READ WRITE NO

SQL> 

把源庫的TEST遷移到目標庫中。

源庫上操作:

SQL> alter pluggable database test close immediate;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB  READ WRITE NO

4 TEST  MOUNTED

SQL> alter pluggable database test unplug into '/u01/test/test.xml';

Pluggable database altered.

目標庫:

[oracle@ora12cA cdb]$ mkdir  /u01/app/oracle/oradata/cdb/test

[oracle@ora12cA cdb]$ mkdir  /u01/test

源庫:

[oracle@ora12c ~]$ scp -r /u01/test/test.xml oracle@192.168.10.32:/u01/test/test.xml

[oracle@ora12c ~]$ scp -r /u01/app/oracle/oradata/cdb/test/* oracle@192.168.10.32:/u01/app/oracle/oradata/cdb/test/

目標庫:

SQL> create pluggable database test using '/u01/test/test.xml' nocopy tempfile reuse;

Pluggable database created.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB  READ WRITE NO

4 TEST  MOUNTED

SQL>  exec DBMS_PDB.SYNC_PDB();

PL/SQL procedure successfully completed.