Hello,
I have done an active data guard setup for many oracle databases, this includes making sure that the primary database is always in sync with standby for recoverability purposes, making sure that MRP0 is applying, and automating scripts to manage log gaps to help proactivity manage.
in addition, i have configured backups to ZDLRA using the redo transport user.
kindly find below sample script to monitor ADG gap.
"set linesize 150 pagesize 150;\n
SELECT a.thread# "Thread", \n
b. last_seq "Recieved", \n
a.applied_seq "Applied", \n
to_char(a.last_app_timestamp,'DD-MON-YY -> HH24:MI:SS')\n "Timestamp",\n
b.last_seq-a.applied_seq "Arc_Difference"\n
FROM \n
(SELECT thread#, MAX(sequence#) applied_seq, MAX(next_time)\n last_app_timestamp FROM gv$archived_log WHERE
applied = 'YES' GROUP BY thread#) a, (SELECT thread#, MAX\n(sequence#) last_seq FROM gv$archived_log GROUP BY\n thread#) \n
b WHERE a.thread# = b.thread#\n
order by a.thread# asc;\n"