- Change the PDB State.
- Unplug the PDB.
- Set default tablespace.
- Set default temporary tablespace.
- Enable (disable) logging.
- Change status of datafile (online/offline).
Change the PDB State:
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 SALESPDB MOUNTED
5 PDBTEST MOUNTED
7 PDBNODATA MOUNTED
SQL> SELECT con_name, instance_name, state FROM dba_pdb_saved_states;
no rows selected
SQL> alter pluggable database pdbtest open;
Pluggable database altered.
SQL> alter pluggable database pdbtest save state;
Pluggable database altered.
SQL> col CON_NAME for A15
SQL> col instance_name for A15
SQL> col state for A20
SQL> SELECT con_name, instance_name, state FROM dba_pdb_saved_states;
CON_NAME INSTANCE_NAME STATE
--------------- --------------- --------------------
PDBTEST orcl OPEN
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 SALESPDB MOUNTED
5 PDBTEST READ WRITE NO
7 PDBNODATA MOUNTED
SQL> startup force
ORACLE instance started.
Total System Global Area 1660944384 bytes
Fixed Size 2925072 bytes
Variable Size 989859312 bytes
Database Buffers 654311424 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 SALESPDB MOUNTED
5 PDBTEST READ WRITE NO
7 PDBNODATA MOUNTED
