千家信息网

Oracle 12c迁移pluggable database到异库

发表于:2025-01-22 作者:千家信息网编辑
千家信息网最后更新 2025年01月22日,1.源库:SQL> show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---
千家信息网最后更新 2025年01月22日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.


0