Re: Compress Offline Redo Logs on Windows?

On Nov 8, 11:18 am, "basis_consult..._at_hotmail.com" <basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> We have many Oracle databases running on Win2003 (Some on
> Win2000). Due to disk space issues, I manually zip some of the
> offline redo logs using Winzip. The logs are 20MB or 50MB in size.
>
> Now, I want to automate the procedure of zipping the offline logs,
> and to use a utility such as 7z, gzip or tar (For Windows) to do so.
>
> Has anybody come across problems using any specific zip
> utility for Windows to zip Oracle offline logs, or has anybody
> used these utilities to zip and unzip the logs without
> any problems?
>
> Thanks,
> DF

I've used the PowerArchiver command line utility with the MS windows utility forfiles.exe for compressing archived redo logs. If they are being shipped to a remote site for business continuity/disaster recovery the cpu burned on compression does make sense. One could drive such a script off of v$archived_log to avoid conflicts.

-bdbafh Received on Thu Nov 08 2007 - 14:17:41 CST