SQL> ALTER PLUGGABLE DATABASE hrpdb close immediate; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE hrpdb UNPLUG INTO '/u10/EXAM/bkp_pdb/hrpdb.xml'; Pluggable database altered.
SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 SALESPDB READ WRITE NO 5 PDB2 READ WRITE NO 6 HRPDB MOUNTED SQL>
SQL> alter pluggable database hrpdb open; alter pluggable database hrpdb open * ERROR at line 1: ORA-65086: cannot open/close the pluggable database SQL>
SQL> drop pluggable database hrpdb; Pluggable database dropped. SQL> CREATE pluggable DATABASE hrpdb USING '/u10/EXAM/bkp_pdb/hrpdb.xml' NOCOPY; Pluggable database created. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 SALESPDB READ WRITE NO 5 PDB2 READ WRITE NO 6 HRPDB MOUNTED SQL> alter pluggable database hrpdb open; Pluggable database altered. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 SALESPDB READ WRITE NO 5 PDB2 READ WRITE NO 6 HRPDB READ WRITE NO SQL>