Oracle 12c: Show PDB saved state

As of PSU 12.1.0.2, 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;

CON_NAME		       INSTANCE_NAME		      STATE
------------------------------ ------------------------------ --------------
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 12.1.0.2, since the original startup trigger was more of a workaround than a real solution.

Comments

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 12.1.0.2, it is possible to save a PDB state so this workaround is no longer […]