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
home |  up  |  mailbox