归档告警频繁监控脚本

归档监控脚本做了一下改动，发现的告警信息如下：

c4oyy1a:150811_23:01:24 Warning: 归档目录/arch1:78%每10分种归档 21次,告警阀值20,请注意!

脚本：db_monitor.conf 增加内容

###归档频繁监控 
ARCHIVED_COUNT_MON=Y 
ARCHIVED_COUNT_ALERT=20 
ARCHIVED_ALERT=70 
脚本： db_monitor_sda.sh  增加内容
############## 归档频率监控 ################### 
if [ "X${ARCHIVED_COUNT_MON}" = "XY" ]; then 
DATE="`hostname`:`date +%y%m%d_%H:%M:%S` Warning: " 
ARC_COUNT=`$ORACLE_HOME/bin/sqlplus -S / as sysdba <<EOF 
set line 200 
SET PAGES 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF 
select count(*) from v\\\$archived_log where COMPLETION_TIME between sysdate-10/1440 and sysdate and thread#=SYS_CONTEXT('USERENV', 'INSTANCE') 
having count(*) >${ARCHIVED_COUNT_ALERT}; 
EOF` 
ARC_CATALOG=`$ORACLE_HOME/bin/sqlplus -S / as sysdba <<EOF 
set line 200 
SET PAGES 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF 
select substr(value,10) from v\\\$parameter where name='log_archive_dest_1'; 
EOF` 

SMS_INFO=`df -g |grep -e ${ARC_CATALOG} | awk -F"[ ]*|%" '{if ($4 > '${ARCHIVED_ALERT}'){print $NF ":" $4}}'` 
if [ "$SMS_INFO" != "" ] && [ "$ARC_COUNT" != "" ]; then 
echo "${DATE}归档目录${SMS_INFO}%每10分种归档${ARC_COUNT}次,告警阀值${ARCHIVED_COUNT_ALERT},请注意!"> $TEMPLOG 
TEMP=`cat $TEMPLOG` 
smswarn $HAND $TEMP 
cat $TEMPLOG >>$ALERTLOG 
fi 
fi

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29446986/viewspace-1768750/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29446986/viewspace-1768750/