get date and error from alertlog

Shell Programming and Scripting
1

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

2

We can help you only if YOU can help US to help you.
Pls post a sample log and desired result based on the sample

3

something like this

Sun Aug 22 02:31:12 2004
ARC0: Beginning to archive log# 3 seq# 15338
ARC0: Completed archiving log# 3 seq# 15338
Sun Aug 22 02:31:45 2004
ORA-00600: internal error code, arguments: [kccchb_1], [87478], [87469],
Sun Aug 22 02:32:14 2004
Shutting down instance (abort)
License high water mark =3D 2
Instance terminated by USER, pid =3D 12911
lter tablespace RBS begin backup
Completed: alter tablespace RBS begin backup
Sun Aug 22 02:18:15 2004
alter tablespace SYSTEM begin backup
Completed: alter tablespace SYSTEM begin backup

i need a result like this on one line with date first

Sun Aug 22 02:31:45 2004 ORA-00600: internal error code, argument .........

thanks
Tom

4

assuming the date preceeds the ORA error:

nawk '/^ORA-/ { print prev, $0; next} { prev=$0}' myOracleLogFile.log