CDB中plug PDB

CDB中plug PDB 先决条件:

·CDB要能够访问之前被unplugged 的pdb的xml文件。如果不能访问，需要使用dbms_pdb.recover创建一个xml文件

·CDB要能够访问到该pdb的数据文件

 

#将之前unplugged pdb重新plug，所以使用了关键nocopy

SQL> create pluggable database clonedb using '/u12/app/oracle/unplug/unplugdb/unplugdb.xml' nocopy;

Pluggable database created.

SQL> create pluggable database clonedb using '/u12/app/oracle/unplug/unplugdb/unplugdb.xml' nocopy;

Pluggable database created.

SQL> select name,open_mode,total_size from v$pdbs;

NAME                           OPEN_MODE  TOTAL_SIZE
------------------------------ ---------- ----------
PDB$SEED                       READ ONLY   283115520
YB                             MOUNTED             0
YB1                            MOUNTED             0
CLONEDB                        MOUNTED             0

SQL> alter session set container=clonedb ;

Session altered.

SQL> startup 
Pluggable Database opened.
SQL> 

plug以后，建议备份pdb