Redirect Logs into Other file

[Khalid Shakoor]

Hi Guruz,

I want to create a script, which Capture the month, year from my alert database log file and redirect the output in another txt file of other location as backup logs.

If someone have this kind of Script please share with me.

Thanks in Advance.
Khalid

[Horia Chirculescu]

Hello,

If you are talking about some unix script, you should use the shell's redirect functions (the shell that you use in the script).

Best regards,
Horia.

[James R. Ferguson]

Hi:

> I want to create a script, which Capture the month, year from my alert database log file and redirect the output in another txt file of other location as backup logs.

Perhaps if you showed us your input and your desired output we could help. I assume that you know basic shell concepts.

Regards!

...JRF...

[Khalid Shakoor]

Hi

Thanks for your Response

Now i am attaching a log file,Its have two month log June and July,
I want to split June and July year 2009 and redirect into another file.

I try it but its showing me only date like

Sun Jun 21 18:38:47 2009
Sun Jun 21 18:45:08 2009
Sun Jun 21 18:51:30 2009
Sun Jun 21 18:57:50 2009

Please help me to split these logs using month and year filter.

Thanks
Khalid

[Khalid Shakoor]

I don't know why its not submit my attachemt.

Please find below the sample of Logs file

============================================
Tue Jun 30 23:51:39 2009
Copy of datafile 28 complete to datafile copy /u02/rbkp/u01/oradata/iiris_web.dbf
checkpoint is 88164327751
Tue Jun 30 23:51:47 2009
alter database create standby controlfile as '/u02/rbkp/u01/oradata/control01.ctl.stdby' reuse
Clearing standby activation ID 3180359789 (0xbd90706d)
The primary database controlfile was created using the
'MAXLOGFILES 255' clause.
There is space for up to 245 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl6.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl7.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl8.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl9.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl10.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl11.f' SIZE 104857600;
Completed: alter database create standby controlfile as '/u02
Tue Jun 30 23:53:56 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Tue Jun 30 23:59:02 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:00:03 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:05:09 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:10:17 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:15:23 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:20:30 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:25:37 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:30:44 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
Wed Jul 1 00:35:51 2009
Errors in file /ora/app/oracle/admin/kic/bdump/kic1_arc0_1042007.trc:
ORA-12541: TNS:no listener
============================================

Thanks
Khalid

[Dennis Handly · Accepted solution]

Depending on your timestamp format and locale, you could use something like:
awk '
# assume timestamp is first
BEGIN {
getline
logname = $5 "_" $2 ".log"
print $0 > logname
}
# assume this matches timestamp
NF == 5 && length($1) == 3 && length($2) == 3 && length($4) == 8 && length($5) == 4 {
logname2 = $5 "_" $2 ".log"
if (logname2 != logname) {
close(logname)
logname = logname2
}
print $0 > logname
next
}
{
print $0 > logname
}' input-log

This will create files with YYYY_MMM.log.

[Khalid Shakoor]

Thanks Dennis,

Its working for me.

Regards
Khalid

[Horia Chirculescu]

Hello,

You can check also a more complex solution:

http://logdistiller.sourceforge.net/

It has log parsing facilities.

Best regards,
Horia.

[Khalid Shakoor]

Dear All,
Thanks a lot.

Khalid Shakoor