Re: to much archivelog

"zeb" <thierry.constant2_at_wanadoo.fr> wrote in message news:b0mvvk$qc6$1_at_news-reader10.wanadoo.fr...
> Hi,
>
> We have a datawarehouse, ( 8.1.7, AIX 4.3.3 )
> the database is in archivelog and we have disk space problem.
> we have a lot of archive we don't need
> we only need them to do the hot backup.
>
> do you know a method to get the archive only for the backup
> something like:
> - noarchive log
> - put the database archive log
> - do the hot backup
> - put the database no archive log
>
> Is a good method ???

Why not run in archivelog mode and removing all generated archive logs by a small script (which check every 5 minutes and removes every archive log found). You just need to disable the script while your hot backup is running.
In my experience, the archiver cause only small system load compare to the updating processes and keep up with lgwr easily in enough log files are configured (>4-6).

Pros:

• no DB restart required Cons:
• overhead of archiver still there
• synchronization of hot backup and delete script required

Stephan Received on Thu Jan 23 2003 - 01:49:19 CST