通过shell监控告警日志

65 阅读 0 评论 43 点赞

我是靠谱客的博主粗犷美女，最近开发中收集的这篇文章主要介绍通过shell监控告警日志，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

自动监控oracle的告警日志，使用crontab 每小时自动执行一次，每次执行的时候检查告警日志的最后100行，如发现错误的话，会自动发送错误信息和时间到指定的邮箱。
crontab：
#check alert log file
00 */1 * * * sh -x /home/oracle/sbin/ch_alert_log.sh orcl

#!/bin/bash
# -------------------------------------------------------------------------- +
#                  CHECK ALERT LOG FILE                                       |
#    Filename: ck_alert_log.sh                                                    |
#       ./ck_alert_log.sh $ORACLE_SID                                         |
# --------------------------------------------------------------------------+
#
# --------------------------
#   Check SID
# --------------------------

if [ -z "${1}" ];then
    echo "Usage: "
    echo "      `basename $0` ORACLE_SID"
    exit 1
fi

export ORACLE_SID=$1
export MACHINE=`hostname`
export USER_MAIL="XXXXX@outlook.com"

# ----------------------------------------------
# check the database is running, if not exit
# ----------------------------------------------

db_status=`ps -ef | grep pmon_$ORACLE_SID | grep -v grep| cut -f3 -d_`
if [ -z "$db_status" ]; then
    date >/tmp/db_${ORACLE_SID}_stauts.log
    echo " $ORACLE_SID is not available on ${MACHINE} !!!" >>/tmp/db_${ORACLE_SID}_stauts.log
    mailx -s "$ORACLE_SID is not available" ${USER_MAIL} < /tmp/db_${ORACLE_SID}_stauts.log
    exit 1
fi;

# ----------------------------------------
# Define archive directory and log file
# ----------------------------------------
ora_date=`date +%Y%m%d`
ALERT_DIR=/opt/oracle/admin/$ORACLE_SID/bdump
ALERT_LOG=${ALERT_DIR}/alert_${ORACLE_SID}.log
ARCH_DIR=${ALERT_DIR}/${ora_date}
NEW_ALERT_LOG=/tmp/${ora_date}_alert_${ORACLE_SID}.log
TEMP_ALERT_LOG=${ALERT_LOG}.temp

if [ ! -d "${ARCH_DIR}" ] ; then
    mkdir $ARCH_DIR
fi

# -------------------------------------
# Check alert log file and send email
# -------------------------------------
tail -n 100 ${ALERT_LOG} | grep -B 1 'ORA-' > ${NEW_ALERT_LOG}
if [ -s "${NEW_ALERT_LOG}" ];then
        mailx -s "${ora_date} Found errors in ${ORACLE_SID} on ${MACHINE}" ${USER_MAIL} < ${NEW_ALERT_LOG}
else
        echo "${ora_date} no error in ${ORACLE_SID} on ${MACHINE}"
fi

# --------------------------------
# delete NEW_ALERT_LOG every day
# --------------------------------

yesterday=`date -d "1 day ago" +%Y%m%d`

if [ -e /tmp/${yesterday}_alert_${ORACLE_SID}.log ];then
        rm /tmp/${yesterday}_alert_${ORACLE_SID}.log
else
        echo "file is not exists"
fi

# --------------------------------
# Backup current alert log file
# --------------------------------

#if [ -e ${ARCH_DIR}/alert_${ORACLE_SID}.log ];then
#       echo "ALERT_LOG is exists"
#else
#       mkdir ${ALERT_DIR}/${ora_date}
#       cp ${ALERT_LOG} ${ARCH_DIR}
#fi
exit

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

转载于:http://blog.itpub.net/28881244/viewspace-1394099/