Managing a Pluggable Database

  • 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

Leave a Reply