Hi All,

I am using below shell script using SQL*Plus to query the MAX(SEQUENCE#) from both databases V$LOG_HISTORY view.If the STANDBY appears to be falling behind by - 2, then alert mail should be sent...

How could I achieve it with improving the below script.

#!/usr/bin/ksh

v_standby=`sqlplus -s /nolog <<END
connect / as sysdba
select /*+ rule */ max(h.sequence#) logseq_on_standby
from v\$log_history h,
v\$parameter p
where h.thread# = to_number(decode(p.value,'0',1,p.value))
and p.name = 'thread';
EXIT;
END`

ssh xyz@hostname.domain
v_primary=`sqlplus -s /nolog <<END
connect / as sysdba
select /*+ rule */ max(h.sequence#) logseq_on_primary
from v\$log_history h,
v\$parameter p
where h.thread# = to_number(decode(p.value,'0',1,p.value))
and p.name = 'thread';
exit;
exit;

Thanks for your time!!

Regards,