GV$ARCHIVE_DEST definition in Oracle 8i / www.oracledba.ru
GV$ARCHIVE_DEST
select
inst_id, -- INST_ID NUMBER
to_number (ADDID), -- DEST_ID NUMBER
decode -- STATUS VARCHAR2(9)
(ADSTS, 1, 'VALID', 2, 'INACTIVE', 3, 'DEFERRED', 4, 'ERROR', 5, 'DISABLED', 6, 'BAD PARAM', 'UNKNOWN'),
decode -- BINDING VARCHAR2(9)
(ADMND, 0, 'OPTIONAL', 'MANDATORY'),
decode -- NAME_SPACE VARCHAR2(7)
(ADSES, 0, 'SYSTEM', 'SESSION'),
decode -- TARGET VARCHAR2(7)
(ADRMT, 0, 'PRIMARY', 'STANDBY'),
to_number (ADROP), -- REOPEN_SECS NUMBER
ADDNM, -- DESTINATION VARCHAR2(256)
to_date -- FAIL_DATE DATE
(ADFDT, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (ADFSQ), -- FAIL_SEQUENCE NUMBER
to_number (ADFBK), -- FAIL_BLOCK NUMBER
ADFER -- ERROR VARCHAR2(256)
from
x$kcrrdest