← 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