Pluggable Database Saved State in Oracle

Pluggable Database Saved State in Oracle

Saved State is a feature in 12.1.0.2 for saved the OPEN state of all PDBS when CDB is restart.
It will bring PDBs to same state if it open then it bring the PDB in Open State or if PDB is closed when CDB restart then it bring PDB in closed state.
open the database in READ-WRITE/READ-ONLY mode it save state.

Check the Save State for PDBS

select a.name,b.state from v$pdbs a , dba_pdb_saved_states b where a.con_id = b.con_id;

SELECT con_name, instance_name, state FROM cdb_pdb_saved_states;

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

Save the existing State of PDB

alter pluggable database PDB1 save state;
Pluggable database altered.

Discard or unsave the existing state of PDB

alter pluggable database HYDB discard state;
Pluggable database altered.

Show the pdbs

Show pdbs

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.