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!
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
Nice!!
Thanks for the feedback! Feel free to comment, ask for additional information or even request a post on a specific subject.