Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alert_sid.log file message...
Valued Gateway Customer wrote:
>
> This is from my alert_sid.log file...it appears to happen frequently.
>
> Is the message "Thread 1 cannot allocate new log, sequence 17978
> Checkpoint not complete" of any concern? What does it really mean?
>
> Jeff S.
>
> Fri Feb 14 10:16:07 1997
> Thread 1 advanced to log sequence 17976
> Current log# 3 seq# 17976 mem# 0: /usr1/oradata/orbitpro/redo03a.log
> Current log# 3 seq# 17976 mem# 1: /usr2/oradata/orbitpro/redo03b.log
> Fri Feb 14 10:16:21 1997
> Thread 1 advanced to log sequence 17977
> Current log# 4 seq# 17977 mem# 0: /usr1/oradata/orbitpro/redo04a.log
> Current log# 4 seq# 17977 mem# 1: /usr2/oradata/orbitpro/redo04b.log
> Fri Feb 14 10:17:00 1997
> Thread 1 cannot allocate new log, sequence 17978
> Checkpoint not complete
> Current log# 4 seq# 17977 mem# 0: /usr1/oradata/orbitpro/redo04a.log
> Current log# 4 seq# 17977 mem# 1: /usr2/oradata/orbitpro/redo04b.log
> Thread 1 advanced to log sequence 17978
> Current log# 1 seq# 17978 mem# 0: /usr1/oradata/orbitpro/redo01a.log
> Current log# 1 seq# 17978 mem# 1: /usr2/oradata/orbitpro/redo01b.log
> Fri Feb 14 10:19:13 1997
> Thread 1 advanced to log sequence 17979
> Current log# 2 seq# 17979 mem# 0: /usr1/oradata/orbitpro/redo02a.log
> Current log# 2 seq# 17979 mem# 1: /usr2/oradata/orbitpro/redo02b.log
>
> --
> These comments do not necessarily reflect the views of Landis & Staefa, Inc.
With log switches occuring about every minute, you're generating redo
too quickly. I suggest you either increase the size of your redo logs
or add more log groups.
-- Rich Woods Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation.Received on Fri Feb 14 1997 - 00:00:00 CST