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.
本文出自 “知行合一” 博客，请务必保留此出处http://dovelauren.blog.51cto.com/9876026/1718235
Oracle 12c迁移pluggable database到异库
原文：http://dovelauren.blog.51cto.com/9876026/1718235