← Data Guard
Oracle · Data Guard
How to check Data Guard transport and apply lag in Oracle
Show Oracle Data Guard transport lag and apply lag values from V$DATAGUARD_STATS.
Tested on11g12c18c19c21c23ai26ai
V$DATAGUARD_STATS reports the two lag numbers that matter for RPO: transport lag (redo not yet shipped) and apply lag (redo shipped but not yet applied). Filter to %lag to get just the interesting rows.
SET LINESIZE 200
COL value FORMAT a30
SELECT name, value, time_computed, datum_time
FROM v$dataguard_stats
WHERE name LIKE '%lag';data guardlagv$dataguard_stats