Oracle 12c: Show PDB saved state

As of PSU, Oracle introduced “PDB State Management Across CDB Restart”, which will automatically put a pluggable database in a previously defined state on database startup. To show the current saved state of the PDBs, you can query the documented view cdb_pdb_saved_states:

SQL> SELECT con_name, instance_name, state FROM cdb_pdb_saved_states;

------------------------------ ------------------------------ --------------
P1			       cdb2			      OPEN
P2			       cdb2			      OPEN

But beware: When you unplug and plug in the database, this saved state will be lost.

I think this is one of the more awesome improvements in, since the original startup trigger was more of a workaround than a real solution.


Oh no, new comments are currently disabled.
If you want to get in touch with me, please do so via e-mail:

Oracle 12c: AFTER STARTUP trigger to open PDBs – Simon Krenger, on 2015-02-17 11:00:19 (Website)

[…] Starting with Oracle, it is possible to save a PDB state so this workaround is no longer […]