Recent errors in database alert log - Revision history

127.0.0.1 at 20:13, 6 December 2011

2011-12-06T20:13:47Z

127.0.0.1 at 20:12, 6 December 2011

2011-12-06T20:12:51Z

127.0.0.1: 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) ..."

2011-12-06T20:10:07Z

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) ..."

New page

#!/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

@@ Line 12: / Line 12: @@
           Day=TMP[1]
           Month=TMP[2]
-          NoDay=TMP[3]}
+          NoDay=TMP[3]
+      }
       ' >> $dest
   done
   exit 0

@@ Line 8: / Line 8: @@
       awk '
       BEGIN {Flg=0}
-      NR==1 {R=split(DATE,TMP," ")
+      NR==1 {
-     Day=TMP[1]
+         R=split(DATE,TMP," ")
-     Month=TMP[2]
+         Day=TMP[1]
-     NoDay=TMP[3]}
+         Month=TMP[2]
-     {NoDayM=NoDay-1}
+         NoDay=TMP[3]}
-     NF==5 && $2==Month && ($3==(NoDayM) || $3==(NoDayM)) {Flg=1}
+         {NoDayM=NoDay-1}
-     Flg==1 {print $0}
+         NF==5 && $2==Month && ($3==(NoDayM) || $3==(NoDayM)) {Flg=1}
-     ' DATE="$DT" $file | awk '
+         Flg==1 {print $0}
-     /^ORA-/ || /cannot/ {print DATE print $0}
+         ' DATE="$DT" $file | awk '
-     NF==5 {DATE=$0}
+         /^ORA-/ || /cannot/ {print DATE print $0}
       ' >> $dest
   done
   exit 0