在Oracle 12C中执行卸载命令后,如果执行PDB的OPEN操作,将会提示错误,如下:
SQL> alter pluggable database pdb01 unplug into '/opt/oracle/pdb01.xml';
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE pdb01 OPEN;
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database
处理办法是先drop掉,然后插入此PDB。
SQL> drop pluggable database pdb01;
Pluggable database dropped.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL> create pluggable database pdb01 using '/opt/oracle/pdb01.xml' nocopy;
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB01 MOUNTED
SQL> alter pluggable database pdb01 open;
Pluggable database altered.