Automatic PDB opening during CDB instance startup

Automatic PDB opening during CDB instance startup

By default the PDB will be in mounted state when the CDB instance is started up. We need to manually open all the cdb’s. The automatic opening of PDB can be achieved by saving the last known state.

SQL> select name, open_mode from V$pdbs;

NAME                           OPEN_MODE

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

PDB$SEED                        READ ONLY

PDB_PURCHASE                    READ WRITE

PDB_HR                          READ WRITE

3 rows selected.

SQL> alter pluggable database all save state;

Pluggable database altered.

SQL> select con_name, INSTANCE_NAME, state, restricted from CDB_PDB_SAVED_STATES;

CON_NAME     INSTANCE_N STATE             RES
——————– ———-          ————–     —
PDB_HR                   seccdb         OPEN                  NO
PDB_PURCHASE seccdb          OPEN                  NO

2 rows selected.

SQL> alter pluggable database PDB_PURCHASE close;

Pluggable database altered.

SQL> select name, open_mode from V$pdbs;

NAME         OPEN_MODE
——————————   ———-
PDB$SEED     READ ONLY
PDB_PURCHASE MOUNTED
PDB_HR       READ WRITE

3 rows selected.

SQL> alter pluggable database PDB_PURCHASE save state;

Pluggable database altered.

SQL> select con_name, INSTANCE_NAME, state, restricted from CDB_PDB_SAVED_STATES;

CON_NAME INSTANCE_N STATE RES
——————– ———- ————– —
PDB_HR seccdb OPEN NO

To revert back to the default behavior we can use discard state.

SQL> alter pluggable database all discard state;

Pluggable database altered.

SQL> select con_name, INSTANCE_NAME, state, restricted from CDB_PDB_SAVED_STATES;

no rows selected