← 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