Database Administration (MOSC)

MOSC Banner

Is there a way to identify snapshot PDB when mounted?

edited Sep 17, 2021 9:50AM in Database Administration (MOSC) 5 commentsAnswered
Hello Everyone, 
When I create snapshot pluggable database:
create pluggable database PDB2 from PDB snapshot copy file_name_convert=('/pdb/','/pdb2/');
Pluggable database created.
I cannot find any relevant information, that the created database was of snapshot type, when the PDB is in mounted state:
col name for a15
select con_id,name,open_mode, snapshot_parent_con_id from v$pdbs;

 CON_ID NAME OPEN_MODE SNAPSHOT_PARENT_CON_ID
---------- --------------- ---------- ----------------------
      2 PDB$SEED          READ ONLY
      4 PDB2              MOUNTED
      5 PDB1              READ ONLY
The column SNAPSHOT_PARENT_CON_ID gets populated only when you open the PDB:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center