GV$DATAGUARD_STATUS definition in Oracle Database 11.2
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$krstalg
order by
  agseq

home |  up