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 open; 

alter pluggable database test open

*

ERROR at line 1:

ORA-65086: cannot open/close the pluggable database

SQL> select pdb_name,status from dba_pdbs;

PDB_NAME     STATUS

-------------------- ---------

PDB     NORMAL

PDB$SEED     NORMAL

TEST     UNPLUGGED

之前做过alter pluggable database ... unplug into '...';但不知道unplug into的xml文件到哪个目录了。

可以重新执行一次alter pluggable database ... unplug into '...';

SQL> alter pluggable database test unplug into '/u01/test/test.xml';

Pluggable database altered.

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> alter pluggable database test open;

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  READ WRITE NO