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