Re: Hot backup question !

From: Manu <emmanuel.pl.bontemps_at_wanadoo.fr>
Date: Mon, 16 Aug 1999 15:04:07 +0200
Message-ID: <7p9299$dj5$1@oceanite.cybercable.fr>

Hi Tapan,

The dynamic view V$LOG_HISTORY can help you to know the frequency of switch log.
In the same way, have a look on alert<sid>.log, where each swich log are recorded.
Normally, log archiving does not affect performances althought is relatively consummer
of CPU and disk IO.
Your are able to optimize archiving performances by ajusting parameters : log_archive_buffer_size and log_archive_buffers. Archiving process should be slower as possible whithout causing switch log synchronisation problem.

Have a nice day.

Emmanuel

Tapan Trivedi a écrit dans le message <37B80179.F272E3FF_at_abbnm.com>...
>Hey Gurus,
> I have a question . I have to put several of my baseline databases into
>hotbackup mode. I want to know is there any way I can know how much the
>redo log files will grow to (archived redo logs that is). I want to
>arrive at the optimum redo log file size for the same so that I can
>estimate how much disk space will be needed and that the redo logs do
>not take away a lot of resources (other than disk space).
>
> Any comments, suggestions, experiences are welcome. Thanks a lot
>everybody.
>
> Tapan H Trivedi
Received on Mon Aug 16 1999 - 08:04:07 CDT