Alert log errors occurred in b/w given time duration

All posts relating to Oracle database administration.

Moderator: Tim...

Alert log errors occurred in b/w given time duration

Postby Arunkumar » Tue Nov 27, 2012 8:08 pm

Hi,

Need shell script to get Alert log errors that occurred in past 24 hours & also b/w given time duration. I am using (Red Hat 4.1.2) and 11.1.0.7

For example: If we run the script it should prompt me for date/time, it should fetch me the errors occured during that time.

Date:27
Month:Nov
Year:2012
HH:08
MM:20
SS:43
It should fetch me the errors occured at this point of time from the alert log. If there are no errors just display a message "no errors" and display the actual text from alert log at that time as,
NO ERRORS
Actual message:
Tue Nov 27 08:20:43 2012
Archived Log entry 8354 added for thread 1 sequence 2710 ID 0x1ea92ad6 dest 1
Arunkumar
Member
 
Posts: 2
Joined: Tue Nov 27, 2012 7:35 pm

Re: Alert log errors occurred in b/w given time duration

Postby Tim... » Wed Nov 28, 2012 9:04 am

Hi.

Well, I never do this because I use EM (or Grid Control) to report on alter log errors, so I never have to manually parse the file.

If you plan to do this, you should probably use the ADRCLI command SHOW ALERT to output the relevant information.

http://docs.oracle.com/cd/B28359_01/ser ... m#BGBDCIHD

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Alert log errors occurred in b/w given time duration

Postby Arunkumar » Wed Nov 28, 2012 7:55 pm

Thanks for the information Tim., will look into the docs... but looks like it will be great if i get a script...
Arunkumar
Member
 
Posts: 2
Joined: Tue Nov 27, 2012 7:35 pm

Re: Alert log errors occurred in b/w given time duration

Postby Tim... » Sun Dec 02, 2012 12:03 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest