Re: Error advancing redo logs

From: Martin Rapier <M.Rapier_at_shef.ac.uk>
Date: 29 Oct 1998 16:55:00 GMT
Message-ID: <71a6l4$c7g$1@bignews.shef.ac.uk>

In article <36388A6F.6911DDCE_at_bigfoot.com>, dcowles_at_bigfoot.com says...
>
>Can anyone give me any suggestions as to why the alert log would have
>several entries
>indicating "Thread 1 cannot allocate new log....checkpoint not complete"
>etc., ?
>Redo log files are on different disks, no known problems with them...
>any suggestions
>appreciated.

You need more online redo log files - there is a thread on this further back. If you only have three files and a lot of update activity, oracle sometimes has to hang around and wait for one to be freed up. Five work fine for us.

Cheers
Martin

--
Martin Rapier, Database Administrator
Corporate Information & Computing Services. University of Sheffield Tel 0114 222 1137 The opinions expressed here may be those of my employer, or they may not. Received on Thu Oct 29 1998 - 10:55:00 CST