GV$ARCHIVE_DEST definition in Oracle Database 11.2
GV$ARCHIVE_DEST
select
inst_id, -- INST_ID NUMBER
to_number(ADDID), -- DEST_ID NUMBER
ADDXX, -- DEST_NAME VARCHAR2(256)
decode( -- STATUS VARCHAR2(9)
ADSTS,1,'VALID', 2,'INACTIVE', 3,'DEFERRED', 4,'ERROR', 5,'DISABLED', 6,'BAD PARAM', 7,'ALTERNATE', 8,'FULL', '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', 1,'STANDBY', 2,'LOCAL', 3,'REMOTE', 'UNKNOWN'),
decode( -- ARCHIVER VARCHAR2(10)
ADPRC,0,'ARCH', 1,'LGWR', 2,'FOREGROUND', 3,'RFS', 4,'ONDEMAND', 'UNKNOWN'),
decode( -- SCHEDULE VARCHAR2(8)
ADSCH,0,'INACTIVE', 1,'PENDING', 2,'ACTIVE', 3,'LATENT', 'UNKNOWN'),
decode( -- DESTINATION VARCHAR2(256)
ADOMF, 0, ADDNM, 'USE_DB_RECOVERY_FILE_DEST'),
to_number(ADLSQ), -- LOG_SEQUENCE NUMBER
to_number(ADROP), -- REOPEN_SECS NUMBER
to_number(ADDLY), -- DELAY_MINS NUMBER
to_number(ADMCS), -- MAX_CONNECTIONS NUMBER
to_number(ADNTT), -- NET_TIMEOUT NUMBER
decode( -- PROCESS VARCHAR2(10)
ADWHO,0,'ARCH', 1,'LGWR', 2,'FOREGROUND', 3,'RFS', 4,'ONDEMAND', 'UNKNOWN'),
decode(ADREG,0,'NO','YES'), -- REGISTER VARCHAR2(3)
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
to_number(ADFCT), -- FAILURE_COUNT NUMBER
to_number(ADMXF), -- MAX_FAILURE NUMBER
ADFER, -- ERROR VARCHAR2(256)
ADALT, -- ALTERNATE VARCHAR2(256)
ADDPD, -- DEPENDENCY VARCHAR2(256)
ADRFT, -- REMOTE_TEMPLATE VARCHAR2(256)
to_number(ADQSZ), -- QUOTA_SIZE NUMBER
to_number(ADQSD), -- QUOTA_USED NUMBER
ADMID, -- MOUNTID NUMBER
decode( -- TRANSMIT_MODE VARCHAR2(12)
ADLAB,0, decode(ADPAR,0,'SYNCHRONOUS', 'PARALLELSYNC'), 'ASYNCHRONOUS'),
to_number(ADLAB), -- ASYNC_BLOCKS NUMBER
decode(ADAFF,0,'NO','YES'), -- AFFIRM VARCHAR2(3)
decode( -- TYPE VARCHAR2(7)
ADDTG,0,'PUBLIC','PRIVATE'),
decode( -- VALID_NOW VARCHAR2(16)
ADNOW,1,'YES', 2,'WRONG VALID_TYPE', 3,'WRONG VALID_ROLE', 4,'INACTIVE', 'UNKNOWN'),
decode( -- VALID_TYPE VARCHAR2(15)
ADVLD,11,'ONLINE_LOGFILE', 12,'ONLINE_LOGFILE', 13,'ONLINE_LOGFILE', 21,'STANDBY_LOGFILE', 22,'STANDBY_LOGFILE', 23,'STANDBY_LOGFILE', 31,'ALL_LOGFILES', 32,'ALL_LOGFILES', 33,'ALL_LOGFILES', 'UNKNOWN'),
decode( -- VALID_ROLE VARCHAR2(12)
ADVLD,11,'PRIMARY_ROLE', 12,'STANDBY_ROLE', 13,'ALL_ROLES', 21,'PRIMARY_ROLE', 22,'STANDBY_ROLE', 23,'ALL_ROLES', 31,'PRIMARY_ROLE', 32,'STANDBY_ROLE', 33,'ALL_ROLES', 'UNKNOWN'),
ADDBUN, -- DB_UNIQUE_NAME VARCHAR2(30)
decode(ADVER,0,'NO','YES'), -- VERIFY VARCHAR2(3)
decode( -- COMPRESSION VARCHAR2(7)
ADCMP,0,'DISABLE','ENABLE')
from
x$krstdest