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