GV$DATAGUARD_STATUS

select
inst_id,                 -- INST_ID NUMBER
decode                   -- FACILITY VARCHAR2(24)
  (agfac, 1, 'Crash Recovery', 2, 'Log Transport Services', 3, 'Log Apply Services', 4, 'Role Management Services', 5, 'Remote File Server', 6, 'Fetch Archive Log', 7, 'Data Guard', 8, 'Network Services', 'UNKNOWN'),
decode                   -- SEVERITY VARCHAR2(13)
  (agsev, 1, 'Informational', 2, 'Warning', 3, 'Error', 4, 'Fatal', 5, 'Control', 'UNKNOWN'),
agdid,                   -- DEST_ID NUMBER
agseq,                   -- MESSAGE_NUM NUMBER
agoer,                   -- ERROR_CODE NUMBER
decode                   -- CALLOUT VARCHAR2(3)
  (bitand (agflg, 1), 0, 'NO', 'YES'),
to_date                  -- TIMESTAMP DATE
  (agdat, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
agtxt                    -- MESSAGE VARCHAR2(256)
from
x$kcrralg order by agseq
home |  up  |  mailbox