Get Previous day error from alertlog

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get Previous day error from alertlog
# 1  
Old 01-27-2014
Get Previous day error from alertlog

Hi All,

I want to get the all ORA- related errors from attached logfile for previous day. Pls help. Thanks !

# 2  
Old 01-27-2014
Originally Posted by kamauv234
I want to get the all ORA- related errors from attached logfile for previous day
Going by your requirement, a simple grep would suffice?
grep ORA alertlog_sample.txt

# 3  
Old 01-27-2014
Thanks for the reply. simple grep statement will collect all the ORA- errors from alertlog file (Contains all records) .. But I need only previous day ORA- errors ...
# 4  
Old 01-27-2014
This quick dirty one liner would look for previous day pattern (as given in the sample) and start reading till the end.
awk -v p="$(date --date '1 day ago' +'%a %b %d')" '$0 ~ p {f=1} f==1 && /ORA-/ {print}' alert_log_file

Does your script run daily ? or multiple times in a day?

I think, you don't want to repeat the alert if you already did. If that's your requirement, then you can probably do something like,

- Read the file
- Grep for errors and store the last_line_no somewhere.
- Next time read the file after the last_line_no.
- Since, alert_log file can be archived too, so need to handle the following simple case,

if ( last_line_no > total_current_lines ) {
  # new alert_log file
  # last_line=0
} else {
  # normal processing

Hope it helps
# 5  
Old 01-27-2014
Thanks for the reply. I am getting below error while using the above code

$ awk -v p="$(date --date '1 day ago' +'%a %b %d')" '$0 ~ p {f=1} f==1 && /ORA-/ {print}' alert_APDSPRD.log
date: illegal option -- date
usage:  date [-u] mmddHHMM[[cc]yy][.SS]
        date [-u] [+format]
        date -a [-]sss[.fff]
awk: syntax error near line 1
awk: bailing out near line 1

$ uname -a
SunOS sgaygipora100 5.10 Generic_150400-03 sun4v sparc sun4v

Last edited by Scrutinizer; 01-28-2014 at 03:12 AM.. Reason: code tags
# 6  
Old 01-28-2014
You don't have GNU date. For non GNU, I have found this quick alternative. Try if that works

awk -v p="$(TZ=GMT+24; date +'%a %b %d')" '$0 ~ p {f=1} f==1 && /ORA-/ {print}' alert_APDSPRD.log

For a more robust solution, I suggest to use perl or search for various date arithmetic threads in this forum.
# 7  
Old 01-28-2014
And on Solaris 10 use

This User Gave Thanks to Scrutinizer For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to get previous day from UNIX AIX?

Does anybody know how to get previous day on UNIX AIX? I tried TZ=XYZ+24 date '+%y%m%d' But it doesn't understand Thanks for contribution (6 Replies)
Discussion started by: digioleg54
6 Replies

2. Shell Programming and Scripting

View file on previous day

Hi Expert, I am new to UNIX , I am looking for a script which can show me list of file created on previous date within specified directory. Regards, Mack (9 Replies)
Discussion started by: mackjack
9 Replies

3. UNIX for Dummies Questions & Answers

Move the files between Current day & a previous day

Hi All, I have a requirement where I need to first capture the current day & move all the files from a particular directory based on a previous day. i.e move all the files from one directory to another based on current day & a previous day. Here is what I am trying, but it gives me errors.... (2 Replies)
Discussion started by: dsfreddie
2 Replies

4. Shell Programming and Scripting

Script to check if last modified day is previous day

Hi, I would like to write a script that checks if a file ('counter') was modified the previous day, if so erase its contents and write 00000000 into it. For e.g. if the file 'counter' was last modified at 11.30pm on 24th May and the script runs at 12.15am of 25th May, it should erase it's... (1 Reply)
Discussion started by: hegdepras
1 Replies

5. Shell Programming and Scripting

getting previous day.

Hi, i am developing a script for my project. In my script i need to check some conditions based upon some values. in that one value is the previous date. with the previous date i need to check and process some values. I have a function with me retrieve the yesterdays date. But now i have a... (6 Replies)
Discussion started by: intiraju
6 Replies

6. Shell Programming and Scripting

Script to find previous month last day minus one day timestamp

Hi All, I need to find the previous month last day minus one day, using shell script. Can you guys help me to do this. My Requirment is as below: Input for me will be 2000909(YYYYMM) I need the previous months last day minus 1 day timestamp. That is i need 2000908 months last day minus ... (3 Replies)
Discussion started by: girish.raos
3 Replies

7. Shell Programming and Scripting

Display month for Previous day

Hello - I have one question regarding the date. I wanted to display the month name for previous day. The output should be as follows... 5-Feb-09 => February 1-Feb-09 => January 28-Feb-09=> February Here is the code i am using to get the output.... date '+%m %d %Y' | { read MONTH DAY... (4 Replies)
Discussion started by: govindts
4 Replies

8. Shell Programming and Scripting

get date and error from alertlog

Hi I need to print oracle alertlog messages and get date and ORA- error on the same line I use bash on solaris 10 I hope you can help me out Br Tom (3 Replies)
Discussion started by: ludvig
3 Replies

9. Shell Programming and Scripting

next/Previous business day

Hello, Can you please help me how do i get previous and next working day of the week for a given date excluding saturday and sunday. Ex: if the given date is monday, i should get friday and tuesday's date if the given date is friday, i should get thrusday and monday's date. Thanks,... (4 Replies)
Discussion started by: kotasateesh
4 Replies

10. Shell Programming and Scripting

Previous day's date in Perl?

Hi All, I want to find the previous day's date and store that in a variable, which will be usuful for further processing. Any help please. Regards, raju (4 Replies)
Discussion started by: rajus19
4 Replies
Login or Register to Ask a Question