select
  FACILITY,                                -- FACILITY VARCHAR2(24)
  SEVERITY,                                -- SEVERITY VARCHAR2(13)
  DEST_ID,                                 -- DEST_ID NUMBER
  MESSAGE_NUM,                             -- MESSAGE_NUM NUMBER
  ERROR_CODE,                              -- ERROR_CODE NUMBER
  CALLOUT,                                 -- CALLOUT VARCHAR2(3)
  TIMESTAMP,                               -- TIMESTAMP DATE
  MESSAGE                                  -- MESSAGE VARCHAR2(256)
from
  GV$DATAGUARD_STATUS
where
  inst_id = USERENV('Instance')