Re: Hot backup question !

One quick way is to check the alert.log file in the background_dump_dest location. You will see messages like:
Mon Aug 2 09:38:20 1999
Thread 1 advanced to log sequence 165221   Current log# 7 seq# 165221 mem# 0:
/usr/local/app/oracle/oradata/mccoy/redo07.log

Note the log sequence number at the start and end of the period you wish to monitor. Take the difference of these two numbers and multiply by the size of your redo logs. The result is how much redo you will generate during the specified time period (more or less).

Tapan Trivedi wrote in 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 - 13:18:48 CDT