← Data Guard
Oracle · Data Guard
How to check Data Guard status messages and recent errors in Oracle
Read Oracle Data Guard status messages from V$DATAGUARD_STATUS, filtered to the last 10 minutes for quick incident triage.
Tested on11g12c18c19c21c23ai26ai
V$DATAGUARD_STATUS is Data Guard''s own message log — every configuration change, gap notification, and error lands here. First query dumps everything; second filters to the last 10 minutes for fast incident triage.
-- All messages currently visible
SELECT message FROM v$dataguard_status;
-- Just the last 10 minutes with timestamps
SET PAGESIZE 2000 LINES 2000
COL message FORMAT a90
SELECT message, timestamp
FROM v$dataguard_status
WHERE timestamp > SYSDATE - 1/6/24;data guardv$dataguard_statuserrors