Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Monitoring archive log apply to physical standby database.

Nirmalkumar
Frequent Advisor

Monitoring archive log apply to physical standby database.

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.