在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.