Hi Folks,
I am working on Oracle 12.0.2.1 Data Guard (Both Primary and Physical Standby are 2-Node RAC)
Can anyone please guide me how can I query the archive log gap from Primary Database.
I am trying following command, but Its not picking the correct information.
select thread#, applied,max(sequence#) from gv$archived_log group by thread#,applied;
Although, I have the query which shows the exact gap when I connect to standby server.
SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE#-APPL.SEQUENCE#) "Difference"
FROM
(SELECT THREAD# ,SEQUENCE# FROM GV$ARCHIVED_LOG
WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME)
FROM GV$ARCHIVED_LOG
GROUP BY THREAD#
)
) ARCH,
(SELECT THREAD# ,SEQUENCE#
FROM GV$LOG_HISTORY
WHERE (THREAD#,FIRST_TIME)
IN (SELECT THREAD#,MAX(FIRST_TIME) FROM GV$LOG_HISTORY GROUP BY THREAD#)
) APPL
WHERE ARCH.THREAD#=APPL.THREAD# ORDER BY 1;
Please guide me.
Thanks
Deep