Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error advancing redo logs
I quadrupled the size of the log files, and added another one, and the problem
is solved. Can you explain this in more detail? I had 3 logfiles, does this
mean that the checkpoint was still being processed for a log by the time it
was supposed to become active again?
What will happen here as far as redo info?
satar_at_my-dejanews.com wrote:
> You are switching log files faster than Oracle can update the checkpoint.
> Increase the number of redo logs or thier size, or both.
>
> In article <36388A6F.6911DDCE_at_bigfoot.com>,
> Doug Cowles <dcowles_at_bigfoot.com> wrote:
> > 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.
> >
> > dcowles_at_bigfoot.com
> >
> >
>
> --
> Oracle DBA/UNIX System Admin
> Advanced Enterprise Solutions
> (949) 756-0588
> Oracle Re-Seller
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Oct 30 1998 - 13:44:47 CST