Re: Archive log compress

badrinathn_at_yahoo.com wrote in message news:<f643a33e.0303040857.34870964_at_posting.google.com>...
> Archive log question
> Hi,
>
> I have a question on Archive logs. I am compressing the archive logs
> with a cron job. What will happen if arch process has just started to
> create a new file and the compress cron job start compressing it.
>
> As the arch file being written has compressed, will the oracle write
> to a different arch file or will it hang and fail.
>
> Badrinath

Badrinath, modify your shell to not compress the most recent n number of archive log files and then you do not have to worry about potentially corrupting the archived log file.

The wc command can be used to quickly count the number of files and an ls -ltr can be used to list them in time order so your read loop stops short of the full number.

HTH -- Mark D Powell -- Received on Wed Mar 05 2003 - 16:24:10 CET