归档告警频繁监控脚本
归档监控脚本做了一下改动，发现的告警信息如下：
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
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博客 ” ，链接：https://blog.itpub.net/29446986/viewspace-1768750/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
SHELL NR与FNR区别
下一篇：
oraccle statspack 使用
请登录后发表评论
登录
全部评论
