Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alert_sid.log file message...

Re: alert_sid.log file message...

From: Rich Woods <rawoods_at_concentric.net>
Date: 1997/02/14
Message-ID: <330528C0.4D53@concentric.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US