Difference between revisions of "Recent errors in database alert log"
From dbawiki
(Created page with " #!/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) ...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 8: | Line 8: | ||
awk ' | awk ' | ||
BEGIN {Flg=0} | BEGIN {Flg=0} | ||
| − | NR==1 {R=split(DATE,TMP," ") | + | NR==1 { |
| − | + | R=split(DATE,TMP," ") | |
| − | + | Day=TMP[1] | |
| − | + | Month=TMP[2] | |
| + | NoDay=TMP[3] | ||
| + | } | ||
{NoDayM=NoDay-1} | {NoDayM=NoDay-1} | ||
NF==5 && $2==Month && ($3==(NoDayM) || $3==(NoDayM)) {Flg=1} | NF==5 && $2==Month && ($3==(NoDayM) || $3==(NoDayM)) {Flg=1} | ||
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
