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