GV$ARCHIVE_DEST_STATUS

select
inst_id,                 -- INST_ID NUMBER
to_number (DSDID),       -- DEST_ID NUMBER
DSDXX,                   -- DEST_NAME VARCHAR2(256)
decode                   -- STATUS VARCHAR2(9)
  (DSSTS, 1, 'VALID', 2, 'INACTIVE', 3, 'DEFERRED', 4, 'ERROR', 5, 'DISABLED', 6, 'BAD PARAM', 'UNKNOWN'),
decode                   -- TYPE VARCHAR2(14)
  (DSTYP, 1, 'LOCAL', 2, 'PHYSICAL', 3, 'LOGICAL', 4, 'CROSS-INSTANCE', 'UNKNOWN'),
decode                   -- DATABASE_MODE VARCHAR2(15)
  (DSDMD, 1, 'STARTED', 2, 'MOUNTED', 3, 'MOUNTED-STANDBY', 4, 'OPEN', 5, 'OPEN_READ-ONLY', 'UNKNOWN'),
decode                   -- RECOVERY_MODE VARCHAR2(23)
  (DSRMD, 1, 'IDLE', 2, 'MANUAL', 3, 'MANAGED', 4, 'MANAGED REAL TIME APPLY', 5, 'LOGICAL REAL TIME APPLY', 'UNKNOWN'),
decode                   -- PROTECTION_MODE VARCHAR2(20)
  (DSPRT, 0, 'MAXIMUM PERFORMANCE', 1, 'MAXIMUM PROTECTION', 2, 'MAXIMUM AVAILABILITY', 3, 'RESYNCHRONIZATION', 'UNKNOWN'),
DSDNM,                   -- DESTINATION VARCHAR2(256)
to_number (DSCNT),       -- STANDBY_LOGFILE_COUNT NUMBER
to_number (DSACT),       -- STANDBY_LOGFILE_ACTIVE NUMBER
to_number (DSLTA),       -- ARCHIVED_THREAD# NUMBER
to_number (DSLSA),       -- ARCHIVED_SEQ# NUMBER
to_number (DSLTR),       -- APPLIED_THREAD# NUMBER
to_number (DSLSR),       -- APPLIED_SEQ# NUMBER
DSERR,                   -- ERROR VARCHAR2(256)
decode                   -- SRL VARCHAR2(3)
  (DSSRL, 0, 'NO', 'YES'),
DSDBUN,                  -- DB_UNIQUE_NAME VARCHAR2(30)
decode                   -- SYNCHRONIZATION_STATUS VARCHAR2(22)
  (DSPRC, 1, 'CHECK CONFIGURATION', 2, 'CHECK STANDBY REDO LOG', 3, 'CHECK NETWORK', 4, 'DESTINATION HAS A GAP', 5, 'OK', 'STATUS NOT AVAILABLE'),
decode                   -- SYNCHRONIZED VARCHAR2(3)
  (DSPRT, 1, 'YES', 2, 'YES', 'NO') 
from
x$kcrrdstat
home |  up  |  mailbox