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', 5,'SNAPSHOT', 6,'DOWNSTREAM', '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', 6,'LOGICAL 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(DSSRL,0,'NO', 'YES'),             -- SRL VARCHAR2(3)
  DSDBUN,                                  -- DB_UNIQUE_NAME VARCHAR2(30)
  decode(                                  -- SYNCHRONIZATION_STATUS VARCHAR2(22)
    DSPRC, 1, 'CHECK CONFIGURATION', 2, 'CHECK STANDBY REDO LOG', 3, 'CHECK CONNECTIVITY', 4, 'DESTINATION HAS A GAP', 5, 'OK', 'STATUS NOT AVAILABLE'),
  decode(                                  -- SYNCHRONIZED VARCHAR2(3)
    DSPRT, 1, 'YES', 2, 'YES', decode(DSSYNC, 1, 'YES', 'NO')),
  decode(                                  -- GAP_STATUS VARCHAR2(24)
    DSGAP, 1, 'NO GAP', 2, 'LOG SWITCH GAP', 3, 'RESOLVABLE GAP', 4, 'UNRESOLVABLE GAP', 5, 'LOCALLY UNRESOLVABLE GAP', NULL) 
from
  x$kcrrdstat