GV$DATABASE

select
inst_id,                 -- INST_ID NUMBER
didbi,                   -- DBID NUMBER
didbn,                   -- NAME VARCHAR2(9)
to_date                  -- CREATED DATE
  (dicts, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (dirls),       -- RESETLOGS_CHANGE# NUMBER
to_date                  -- RESETLOGS_TIME DATE
  (dirlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (diprs),       -- PRIOR_RESETLOGS_CHANGE# NUMBER
to_date                  -- PRIOR_RESETLOGS_TIME DATE
  (diprc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- LOG_MODE VARCHAR2(12)
  (bitand (diflg, 1), 0, 'NOARCHIVELOG', 'ARCHIVELOG'),
to_number (discn),       -- CHECKPOINT_CHANGE# NUMBER
to_number (difas),       -- ARCHIVE_CHANGE# NUMBER
decode                   -- CONTROLFILE_TYPE VARCHAR2(7)
  (bitand (diflg, 256), 256, 'CREATED', decode (bitand (diflg, 1024), 1024, 'STANDBY', decode (bitand (diflg, 32768), 32768, 'CLONE', decode (bitand (diflg, 4096), 4096, 'BACKUP', 'CURRENT')))),
to_date                  -- CONTROLFILE_CREATED DATE
  (dicct, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
dicsq,                   -- CONTROLFILE_SEQUENCE# NUMBER
to_number (dickp_scn),   -- CONTROLFILE_CHANGE# NUMBER
to_date                  -- CONTROLFILE_TIME DATE
  (dickp_tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- OPEN_RESETLOGS VARCHAR2(11)
  (bitand (diflg, 4), 4, 'REQUIRED', decode (diirs, 0, 'NOT ALLOWED', 'ALLOWED')),
to_date                  -- VERSION_TIME DATE
  (divts, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- OPEN_MODE VARCHAR2(10)
  (didor, 0, 'MOUNTED', decode (didor, 1, 'READ WRITE', 'READ ONLY')),
decode                   -- PROTECTION_MODE VARCHAR2(20)
  (bitand (diflg, 65536), 65536, 'MAXIMUM PROTECTION', decode (bitand (diflg, 128), 128, 'MAXIMUM AVAILABILITY', decode (bitand (diflg, 134217728), 134217728, 'RESYNCHRONIZATION', decode (bitand (diflg, 8), 8, 'UNPROTECTED', 'MAXIMUM PERFORMANCE')))),
decode                   -- PROTECTION_LEVEL VARCHAR2(20)
  (diprt, 1, 'MAXIMUM PROTECTION', 2, 'MAXIMUM AVAILABILITY', 3, 'RESYNCHRONIZATION', 4, 'MAXIMUM PERFORMANCE', 5, 'UNPROTECTED', 'UNKNOWN'),
decode                   -- REMOTE_ARCHIVE VARCHAR2(8)
  (dirae, 0, 'DISABLED', 1, 'SEND', 2, 'RECEIVE', 3, 'ENABLED', 'UNKNOWN'),
to_number (diacid),      -- ACTIVATION# NUMBER
decode                   -- DATABASE_ROLE VARCHAR2(16)
  (bitand (diflg, 33554432), 33554432, 'LOGICAL STANDBY', decode (bitand (diflg, 1024), 1024, 'PHYSICAL STANDBY', 'PRIMARY')),
to_number (diars),       -- ARCHIVELOG_CHANGE# NUMBER
decode                   -- SWITCHOVER_STATUS VARCHAR2(18)
  (disos, 0, 'IMPOSSIBLE', 1, 'NOT ALLOWED', 2, 'SWITCHOVER LATENT', 3, 'SWITCHOVER PENDING', 4, 'TO PRIMARY', 5, 'TO STANDBY', 6, 'RECOVERY NEEDED', 7, 'SESSIONS ACTIVE', 'UNKNOWN'),
decode                   -- DATAGUARD_BROKER VARCHAR2(8)
  (didgd, 0, 'DISABLED', 'ENABLED'),
decode                   -- GUARD_STATUS VARCHAR2(7)
  (bitand (diflg, 1048576), 1048576, 'ALL', decode (bitand (diflg, 2097152), 2097152, 'STANDBY', 'NONE')),
decode                   -- SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(3)
  (bitand (diflg, 1073741824), 1073741824, 'YES', 'NO'),
decode                   -- SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3)
  (bitand (diflg, 131072), 131072, 'YES', 'NO'),
decode                   -- SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3)
  (bitand (diflg, 262144), 262144, 'YES', 'NO'),
decode                   -- FORCE_LOGGING VARCHAR2(3)
  (bitand (diflg, 268435456), 268435456, 'YES', 'NO') 
from
x$kccdi
home |  up  |  mailbox