V$FOREIGN_ARCHIVED_LOG definition in Oracle Database 11.2
V$FOREIGN_ARCHIVED_LOG
select
RECID, -- RECID NUMBER
STAMP, -- STAMP NUMBER
NAME, -- NAME VARCHAR2(513)
DEST_ID, -- DEST_ID NUMBER
THREAD#, -- THREAD# NUMBER
SEQUENCE#, -- SEQUENCE# NUMBER
RESETLOGS_CHANGE#, -- RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME, -- RESETLOGS_TIME DATE
RESETLOGS_ID, -- RESETLOGS_ID NUMBER
FIRST_CHANGE#, -- FIRST_CHANGE# NUMBER
FIRST_TIME, -- FIRST_TIME DATE
NEXT_CHANGE#, -- NEXT_CHANGE# NUMBER
NEXT_TIME, -- NEXT_TIME DATE
BLOCKS, -- BLOCKS NUMBER
BLOCK_SIZE, -- BLOCK_SIZE NUMBER
CREATOR, -- CREATOR VARCHAR2(7)
REGISTRAR, -- REGISTRAR VARCHAR2(7)
ARCHIVED, -- ARCHIVED VARCHAR2(3)
APPLIED, -- APPLIED VARCHAR2(3)
DELETED, -- DELETED VARCHAR2(3)
STATUS, -- STATUS VARCHAR2(1)
COMPLETION_TIME, -- COMPLETION_TIME DATE
DICTIONARY_BEGIN, -- DICTIONARY_BEGIN VARCHAR2(3)
DICTIONARY_END, -- DICTIONARY_END VARCHAR2(3)
END_OF_REDO, -- END_OF_REDO VARCHAR2(3)
ARCHIVAL_THREAD#, -- ARCHIVAL_THREAD# NUMBER
IS_RECOVERY_DEST_FILE, -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
COMPRESSED, -- COMPRESSED VARCHAR2(3)
FAL, -- FAL VARCHAR2(3)
END_OF_REDO_TYPE, -- END_OF_REDO_TYPE VARCHAR2(10)
SOURCE_DBID -- SOURCE_DBID NUMBER
from
GV$FOREIGN_ARCHIVED_LOG
where
inst_id = USERENV('Instance')