GV$ARCHIVED_LOG

select
inst_id,                 -- INST_ID NUMBER
alrid,                   -- RECID NUMBER
alstm,                   -- STAMP NUMBER
alnam,                   -- NAME VARCHAR2(513)
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 (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(4)
  (bitand (alflg, 16), 16, 'ARCH', decode (bitand (alflg, 32), 32, 'FGRD', decode (bitand (alflg, 64), 64, 'RMAN', decode (bitand (alflg, 128), 128, 'RMAN', NULL)))),
decode                   -- REGISTRAR VARCHAR2(4)
  (bitand (alflg, 4), 4, 'RFS', decode (bitand (alflg, 16), 16, 'ARCH', decode (bitand (alflg, 32), 32, 'FGRD', decode (bitand (alflg, 64), 64, 'RMAN', decode (bitand (alflg, 128), 128, 'SRMN', NULL))))),
decode                   -- STANDBY_DEST VARCHAR2(3)
  (bitand (alflg, 8), 0, 'NO', 'YES'),
decode                   -- ARCHIVED VARCHAR2(3)
  (bitand (alflg, 2), 0, 'NO', 'YES'),
decode                   -- DELETED VARCHAR2(3)
  (bitand (alflg, 1), 0, 'NO', 'YES'),
to_date                  -- COMPLETION_TIME DATE
  (altsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') 
from
x$kccal
home |  up  |  mailbox