Monitoring archive log apply to physical standby database.

[Nirmalkumar]

Hi all,

i have prepared sql script for montoring archive log apply to physical standby database.


My sql script
--------------
select a "countapply" from (SELECT (MAX(B.SEQUENCE#)-MAX(A.SEQUENCE#)) a
FROM V$ARCHIVED_LOG A,V$ARCHIVED_LOG B WHERE A.THREAD#=1 AND A.APPLIED='YES'
AND B.THREAD#=1 AND B.APPLIED='NO') a;

i have planned to send a mail if more than 10 archive log is not applied to the physical standby database by scheduling the script in scheduled tasks.

can some body help me to prepare the batch script part for my requirement.

My primary and physical standy-by database are running in windows platform.

Thanks
Nirmal.