GV$ARCHIVED_LOG definition in Oracle Database 11.2
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(9)
bitand(alflg, 1024),0, (decode(bitand(alfl2, 16384),0,'NO','IN-MEMORY')),'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(bitand(alfl2,15)), -- BACKUP_COUNT NUMBER
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')),
decode( -- BACKED_BY_VSS VARCHAR2(3)
bitand(alfl2,4096), 0, 'NO', 'YES')
from
x$kccal