GV$ARCHIVED_LOG

select
inst_id,                 -- INST_ID NUMBER
alrid,                   -- RECID NUMBER
alstm,                   -- STAMP NUMBER
alnam,                   -- NAME VARCHAR2(513)
aldst,                   -- DEST_ID NUMBER
althp,                   -- THREAD# NUMBER
alseq,                   -- SEQUENCE# NUMBER
to_number (alrls),       -- RESETLOGS_CHANGE# NUMBER
to_date                  -- RESETLOGS_TIME DATE
  (alrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (alxlc),       -- RESETLOGS_ID NUMBER
to_number (allos),       -- FIRST_CHANGE# NUMBER
to_date                  -- FIRST_TIME DATE
  (allot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (alnxs),       -- NEXT_CHANGE# NUMBER
to_date                  -- NEXT_TIME DATE
  (alnxt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
albct,                   -- BLOCKS NUMBER
albsz,                   -- BLOCK_SIZE NUMBER
decode                   -- CREATOR VARCHAR2(7)
  (bitand (alflg, 16+32+64+128+256), 16, 'ARCH', 32, 'FGRD', 64, 'RMAN', 128, 'SRMN', 256, 'LGWR', 'UNKNOWN'),
decode                   -- REGISTRAR VARCHAR2(7)
  (bitand (alflg, 4), 4, 'RFS', decode (bitand (alflg, 16+32+64+128+256), 16, 'ARCH', 32, 'FGRD', 64, 'RMAN', 128, 'SRMN', 256, 'LGWR', 'UNKNOWN')),
decode                   -- STANDBY_DEST VARCHAR2(3)
  (bitand (alflg, 8), 0, 'NO', 'YES'),
decode                   -- ARCHIVED VARCHAR2(3)
  (bitand (alflg, 2), 0, 'NO', 'YES'),
decode                   -- APPLIED VARCHAR2(3)
  (bitand (alflg, 1024), 0, 'NO', 'YES'),
decode                   -- DELETED VARCHAR2(3)
  (bitand (alflg, 1), 0, 'NO', 'YES'),
decode                   -- STATUS VARCHAR2(1)
  (bitand (alflg, 1+2048+4096), 0, 'A', 1, 'D', 2048, 'X', 4096, 'U', '?'),
to_date                  -- COMPLETION_TIME DATE
  (altsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- DICTIONARY_BEGIN VARCHAR2(3)
  (bitand (alflg, 8192), 0, 'NO', 'YES'),
decode                   -- DICTIONARY_END VARCHAR2(3)
  (bitand (alflg, 16384), 0, 'NO', 'YES'),
decode                   -- END_OF_REDO VARCHAR2(3)
  (bitand (alflg, 32768), 0, 'NO', 'YES'),
to_number                -- BACKUP_COUNT NUMBER
  (bitand (alfl2, 15)),
altoa,                   -- ARCHIVAL_THREAD# NUMBER
alacd,                   -- ACTIVATION# NUMBER
decode                   -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
  (bitand (alfl2, 64), 0, 'NO', 'YES'),
decode                   -- COMPRESSED VARCHAR2(3)
  (bitand (alfl2, 128), 0, 'NO', 'YES'),
decode                   -- FAL VARCHAR2(3)
  (bitand (alflg, 512), 0, 'NO', 'YES'),
decode                   -- END_OF_REDO_TYPE VARCHAR2(10)
  (bitand (alfl2, 256+512+1024), 256, 'TERMINAL', 512, 'ACTIVATION', 1024, 'RESETLOGS', decode (bitand (alflg, 32768), 0, '', 'SWITCHOVER')) 
from
x$kccal
home |  up  |  mailbox