Difference between revisions of "Recent errors in database alert log"
From dbawiki
| Line 12: | Line 12: | ||
Day=TMP[1] | Day=TMP[1] | ||
Month=TMP[2] | Month=TMP[2] | ||
| − | NoDay=TMP[3] | + | NoDay=TMP[3] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
} | } | ||
| + | {NoDayM=NoDay-1} | ||
| + | NF==5 && $2==Month && ($3==(NoDayM) || $3==(NoDayM)) {Flg=1} | ||
| + | Flg==1 {print $0} | ||
| + | ' DATE="$DT" $file | awk ' | ||
| + | /^ORA-/ || /cannot/ {print DATE print $0} | ||
| + | NF==5 {DATE=$0} | ||
' >> $dest | ' >> $dest | ||
done | done | ||
exit 0 | exit 0 | ||
Latest revision as of 20:13, 6 December 2011
#!/bin/ksh
printf "Enter Destination File: "
read dest
files="/*/u??/oradata/$ORACLE_SID/oralogs -name alert_$ORACLE_SID.log"
for file in $(find $files)
do
DT=$(date)
awk '
BEGIN {Flg=0}
NR==1 {
R=split(DATE,TMP," ")
Day=TMP[1]
Month=TMP[2]
NoDay=TMP[3]
}
{NoDayM=NoDay-1}
NF==5 && $2==Month && ($3==(NoDayM) || $3==(NoDayM)) {Flg=1}
Flg==1 {print $0}
' DATE="$DT" $file | awk '
/^ORA-/ || /cannot/ {print DATE print $0}
NF==5 {DATE=$0}
' >> $dest
done
exit 0
