← Data Guard
Oracle · Data Guard

How to check Data Guard apply rate in Oracle

Show the current active and average redo apply rate (MB/sec) from V$RECOVERY_PROGRESS on an Oracle Data Guard physical standby.

Tested on11g12c18c19c21c23ai26ai

V$RECOVERY_PROGRESS reports MRP''s apply throughput. Active Apply Rate is the instantaneous rate; Average Apply Rate is smoothed over the run. Compare against redo generation on the primary — if apply < generation, the lag grows.

SELECT TO_CHAR(start_time, 'DD-MON-RR HH24:MI:SS') AS start_time,
       item,
       ROUND(sofar / 1024, 2) AS "MB/Sec"
FROM   v$recovery_progress
WHERE  item IN ('Active Apply Rate', 'Average Apply Rate');
data guardapply ratev$recovery_progress