After CDB restarts, PDBs is in mounted state by default
Sql>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------pdb$seed Read ONLYPDB1 read WRITEPDB2 read W Ritesql>shutdown immediate;database closed. Database dismounted. ORACLE instance shut down. SQL>Startup ORACLE instance started. Total System Global Area1174405120bytesfixed Size2923680bytesvariable Size436208480Bytesdatabase Buffers721420288Bytesredo Buffers13852672bytesdatabase mounted. Database opened. SQL>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------pdb$seed READ ONLYPDB1 MOUNTEDPDB2 mountedsq L>
The command "Alter pluggable database ... save state" enables the PDB to maintain its pre-shutdown status after the CDB is restarted.
Cancel the settings using "Alter pluggable database ... discard state".
Sql>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------pdb$seed Read ONLYPDB1 read WRITEPDB2 Mounte DSQL>Alter pluggable database PDB1 save state; Pluggable database altered. SQL>shutdown immediate;database closed. Database dismounted. ORACLE instance shut down. SQL>startup; ORACLE instance started. Total System Global Area1174405120bytesfixed Size2923680bytesvariable Size436208480Bytesdatabase Buffers721420288Bytesredo Buffers13852672bytesdatabase mounted. Database opened. SQL>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------pdb$seed Read ONLYPDB1 read WRITEPDB2 Mounte DSQL>
Oracle 12C--PDBs auto-start when CDB is set up