Dataguard Archivelog Gap
673115Aug 17 2010 — edited Aug 18 2010I am using Oracle 10g R2 on Red Hat Enterprise Edition 4 with data guard (Physical Standby). Today while performing routine morning tasks, I found archivelog gap on my primary database by running this query:
SELECT MAX(SEQUENCE#), MAX(COMPLETION_TIME), APPLIED FROM V$ARCHIVED_LOG GROUP BY APPLIED;
There is difference on 20 days. I searched internet where most of the people talk about finding archivelog gap by querying v$archive_gap view as first step. I do the same on primary and standby like this:
SELECT * FROM V$ARCHIVE_GAP;
But no record is returned. Can anyone suggest me so that I can start moving and applying logs to standby.