How To Open The PDBS Automatically When CDB Restarts | Save State of PDBS

• Kiran Dalvi
• 23 Sep, 2020
• 0 Comments
• 1 Min Read

How To Open The PDBS Automatically When CDB Restarts | Save State of PDBS

In oracle 12c , when we startup the CDB, the PDBS will be in MOUNTED stage. We need to open them manually using alter pluggable PDB open. To make the PDBS open automatically, we can use the saved state option . This feature is available from Oracle 12.1.0.2  onwards 

Start the container database and you will find that all PDBS are in mount stage.

[oracle@prim ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 23 14:47:49 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1140850688 bytes
Fixed Size                  8791960 bytes
Variable Size             805308520 bytes
Database Buffers          318767104 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.
SQL>


SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBPRIM                        MOUNTED
         4 PDBPRIM2                       MOUNTED
         5 PDBPRIM4                       MOUNTED
         6 PDBPRIM5                       MOUNTED
SQL>

Connect to the pluggable database and start the pluggable database.

SQL> alter session set container=PDBPRIM;

Session altered.

SQL> startup
Pluggable Database opened.

Connect to Container database and save the state.

SQL>  alter session set container=CDB$ROOT;

Session altered.

SQL>
SQL>
SQL> alter pluggable database PDBPRIM save state;

Pluggable database altered.


Verify the state with view dba_pdb_saved_states.
 
SQL> select con_name, state from dba_pdb_saved_states;

CON_NAME           STATE
---------------   --------------
PDBPRIM            OPEN    


Bounce the container database and verify pluggable database should be in open mode.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> startup
ORACLE instance started.

Total System Global Area 1140850688 bytes
Fixed Size                  8791960 bytes
Variable Size             805308520 bytes
Database Buffers          318767104 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBPRIM                        READ WRITE NO
         4 PDBPRIM2                       MOUNTED
         5 PDBPRIM4                       MOUNTED
         6 PDBPRIM5                       MOUNTED

We can discard the state of pluggable database with following command.

SQL> alter pluggable database PDBPRIM discard state;

Pluggable database altered.


SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> startup
ORACLE instance started.

Total System Global Area 1140850688 bytes
Fixed Size                  8791960 bytes
Variable Size             805308520 bytes
Database Buffers          318767104 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.


SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBPRIM                        MOUNTED
         4 PDBPRIM2                       MOUNTED
         5 PDBPRIM4                       MOUNTED
         6 PDBPRIM5                       MOUNTED