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', 'UNKNOWN'),
decode                   -- SCHEDULE VARCHAR2(8)
  (ADSCH, 0, 'INACTIVE', 1, 'PENDING', 2, 'ACTIVE', 3, 'LATENT', 'UNKNOWN'),
ADDNM,                   -- DESTINATION VARCHAR2(256)
to_number (ADLSQ),       -- LOG_SEQUENCE NUMBER
to_number (ADROP),       -- REOPEN_SECS NUMBER
to_number (ADDLY),       -- DELAY_MINS NUMBER
to_number (ADNTT),       -- NET_TIMEOUT NUMBER
decode                   -- PROCESS VARCHAR2(10)
  (ADWHO, 0, 'ARCH', 1, 'LGWR', 2, 'FOREGROUND', 3, 'RFS', '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') 
from
x$kcrrdest
home |  up  |  mailbox