GV$ARCHIVE_DEST definition in Oracle Database 10.2 / www.oracledba.ru
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 -- REGISTER VARCHAR2(3)
(ADREG, 0, 'NO', 'YES'),
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 -- AFFIRM VARCHAR2(3)
(ADAFF, 0, 'NO', 'YES'),
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 -- VERIFY VARCHAR2(3)
(ADVER, 0, 'NO', 'YES')
from
x$kcrrdest