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')