Re: Redo Log File Error

In article <1992Jun15.163427.2118_at_mprgate.mpr.ca>, evanderw_at_mpr.ca (Eva Vanderwerf) writes:
> Hi, I've been getting the following message in by lgwr.trc file:
>
> ...
> Advanced to log sequence 5815 file /usr/local/oracle/dbs/log1P.dbf
> Advanced to log sequence 5816 file /usr/local/oracle/dbs/log2P.dbf
> Mon Jun 15 01:13:04 1992
> cannot allocate new log, seq 5817, needs checkpointing
> Advanced to log sequence 5817 file /usr/local/oracle/dbs/log1P.dbf
> ...
>
> I imagine that I need to either add another log-file, increase the
> size of the files, or decrease the log_checkpoint_interval variable.
> I have the default log-files right now: 2 of 500K.
> All my log-variables in INIT.ORA are defaults. I've read and mostly
> understood the chapters regarding Redo Logs in the DBA Manual, but was
> wondering if anyone else has any friendly words of advice, before I start
> changing things.
>
> Thanks in advance, please post or email.
>
> --
> --------------------------------+----------------------------------
> Eva Vanderwerf | Voice : (604) 293-6072
> MPR Teltech Ltd. 8999 Nelson Way| FAX : (604) 293-5787
> Burnaby, BC, Canada, V5A 4B5 | Internet : evanderw_at_mprgate.mpr.ca

Hello, Eva:

Those messages should not alarm you; they are just printed for information sake. If you see many of those in your LGWR trace file, then it is a sign that may be your log files might be too small. The message just means it has redo of a certain size to write to the log file but there isn't enough room in it. So it must perform a checkpoint and then switch to the next log where it has the entire file to write into.

• Kathy Jou