Recent errors in database alert log

From dbawiki
Revision as of 20:10, 6 December 2011 by 127.0.0.1 (talk) (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) ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
#!/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