Hello shell experts;


I have log-file name alert.log. This log file is updated frequently.

Here is the content:

view alert.log

..
..
..
Media Recovery Log /oracle/archives/arch_1_19_691513588.arc
Mon Jul 6 19:54:47 2009
Media Recovery Log /oracle/archives/arch_1_20_691513588.arc
Mon Jul 6 19:54:47 2009
Media Recovery Log /oracle/archives/arch_1_21_691513588.arc
Mon Jul 6 19:54:47 2009
Media Recovery Log /oracle/archives/arch_1_22_691513588.arc
Mon Jul 6 19:54:47 2009
Media Recovery Log /oracle/archives/arch_1_23_691513588.arc
Mon Jul 6 19:54:47 2009
Media Recovery Log /oracle/archives/arch_1_24_691513588.arc
Mon Jul 6 19:54:47 2009
Media Recovery Log /oracle/archives/arch_1_25_691513588.arc
Errors with log /oracle/archives/arch_1_25_691513588.arc
ORA-279 signalled during: ALTER DATABASE RECOVER automatic database using backup controlfile until cancel ...


---------------------------------------------------------------

In another server,I have directory /oracle/archives

$ ls /oracle/archives
arch_1_13_691513588.arc arch_1_17_691513588.arc arch_1_21_691513588.arc
arch_1_14_691513588.arc arch_1_18_691513588.arc arch_1_22_691513588.arc
arch_1_15_691513588.arc arch_1_19_691513588.arc arch_1_23_691513588.arc
arch_1_16_691513588.arc arch_1_20_691513588.arc arch_1_24_691513588.arc
arch_1_25_691513588.arc arch_1_26_691513588.arc arch_1_27_691513588.arc
arch_1_28_691513588.arc arch_1_29_691513588.arc arch_1_30_691513588.arc



What I want to do is, get the last applied number from alert.log which is 25.(Media Recovery Log /oracle/archives/arch_1_25_691513588.arc)
Copy the files from /oracle/archives
from number 25 to greatest number which is 30 to some other directory (/oracle/temp).

How can I write such a script? I gave these numbers as an example.

Thanks in advance

what have you got?

Ghostdog you helped me a lot before, I guess you will again help me in this issue
These numbers will always increment. I dont have any script yet and dont know how to start

no, i most probably will not help you, not if you put in effort. with 63++ posts, i will not assume you are a newbie anymore.

he means how far have you got on the script so far?

You are right ghostdog, but I havent decided how to start where to start, etc...
If I got somethings I will work on them.
I really aprreciate if you help me in this issue

Mon Jul 6 19:54:47 2009 Media Recovery Log /oracle/archives/arch_1_20_691513588.arc

Assuming the above log line is on one line and the file names don't change except the _20_:

for i in `cat alert.log | awk '{print $9}' | cut -b 25-26`;
do
echo "copying arch_1_"$i"_691513588.arc to /some/where"
done

I'm no expert and this is a rough but also an easy task. Of course you have to fix it up to make the copy actually happen. replacing the echo with your cp command etc. Think you can do it? It's a start'

logrotate

maybe?

I can get the last applied number from alert.log.
I am thinking to write this number to a file and rcp this file other server, read this number from file and copy logs from /oracle/archives.

Is there any other suggestion????

Sounds like your in the right direction. Post what you got so far and maybe we help further.