Quick script to start troubleshooting Data Guard gap/lag

Scenario: you are connected to the primary database and want to know if one or more of your standby databases are lagging behind? The script below will show the log sequences involved and even how many hours wide is the gap, for each thread of each standby database:

*Remember to Like/Share if you copy the script. Thanks!

DataGuard Gap Script

This is a sample output for it, it shows three two-node standby databases:

   DEST_ID    THREAD#    PRIMARY  MAXTRANSF    STANDBY MINTRANSF_GAP  APPLY_GAP   HOURSGAP
---------- ---------- ---------- ---------- ---------- ------------- ---------- ----------
         2          1      45798      45798      45798             0          0          0
         3          1      45798      45798      45798             0          0          0
         4          1      45798      45798      45798             0          0          0
         2          2      45606      45606      45605             0          1          0
         3          2      45606      45606      45605             0          1          0
         4          2      45606      45606      45605             0          1          0

Advertisements