Frank van Bortel wrote:
> basis_consultant_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
>>
> Apart from wise words from wise men,
> offline redo logs, as you call them, make me believe
> you run in archive log mode.
>
> Backing up the archived redo log files is the appropriate
> way to, preferably using RMAN, which can delete your
> archived redo log files after backing up.
>
did I really not say that, that was a bit awful really. I'm sure I had
something in there about backing up archive logs as frequently as
necessary - we do it hourly on some systems..
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Thu Nov 08 2007 - 16:57:18 CST
