--OraCheck.sh

#!/bin/bash

#Usage: sh OraCheck.sh alertlogfile days

#Example: sh OraCheck.sh $ORACLE_BASE/admin/SID/bdump/alert_sid.log 30

ERRORLOGFILE=$1
GAPDAYS=$2
ORAFILE=/tmp/oraerror.log

OSDAY=`date -d "-$GAPDAYS days"|awk '{print $3}'`
if [ $OSDAY -lt 10 ]; then

#For 10.2.0.4
DAY_B4_30D=`date -d "-$GAPDAYS days"|awk '{print $1,$2," "$3}'`

#For 10.2.0.5 or above

#DAY_B4_30D=`date -d "-$GAPDAYS days"|awk '{print $1,$2,"0"$3}'`

else
DAY_B4_30D=`date -d "-$GAPDAYS days"|awk '{print $1,$2,$3}'`
fi

TODAY=`date |awk '{print $3}'`
if [ $TODAY -lt 10 ]; then

#For 10.2.0.4
TODAYDATE=`date |awk '{print $1,$2," "$3}'`

#For 10.2.0.5 or above

#TODAYDATE=`date |awk '{print $1,$2,"0"$3}'`

else
TODAYDATE=`date |awk '{print $1,$2,$3}'`
fi

YEAR=`date |awk '{print $6}'`

cat $ORAFILE

ITPub博客

Monitor-Get ORA errors by given days