RE: Cannot allocate new log - checkpoint not complete

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 03 Apr 2003 07:04:03 -0800
Message-ID: <F001.0057959D.20030403070403@fatcity.com>

Fermin - Connor's reply sparked an idea. By any chance do you have your redo logs on the same device as your data files?

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, April 03, 2003 5:04 AM
To: Multiple recipients of list ORACLE-L

Basically as the message suggests the redo cannot be recycled until the checkpoint has completed flushing out the cache.

A *workaround* is to add redo log (size or number) but its really a heads-up about your I/O subsystem not being up to keep up under stress.

hth
connor

• Fermin Bernaus Berraondo <fbernaus_at_sammic.com> wrote: >
  > I think I am having problems with my redologs.
  > Under normal circumstances no errors arise, but if I
  > do a massive import of data as I was doing last
  > night, this is what alertSID.log shows from time to
  > time:
  >
  > Wed Apr 2 23:29:52 2003
  > Thread 1 advanced to log sequence 557295
  > Current log# 3 seq# 557295 mem# 0:
  > /baandata/oradata/baan/redobaan03.log
  > Wed Apr 2 23:31:11 2003
  > Thread 1 cannot allocate new log, sequence 557296
  > Checkpoint not complete
  > Current log# 3 seq# 557295 mem# 0:
  > /baandata/oradata/baan/redobaan03.log
  > Wed Apr 2 23:31:50 2003
  >
  > In that exact time, everything freezes and the
  > database is dead until a new redolog can be used.
  >
  > I have 3 redologs 50 Mb each. I've read that the
  > error is because too much data is trying to get into
  > the redologs and all of them are full, Oracle does
  > not have the time to reuse a redolog and has to wait
  > until the redolog is ready to be reused.
  >
  > So the solution seems to make these redolog files
  > bigger or to create new ones. What are the side
  > effects of one or the other? will performance under
  > normal work be penalised?
  >
  > ..............................................
  > Fermín Bernaus Berraondo
  > Dpto. de Informática
  > SAMMIC, S.A.
  > fbernaus_at_sammic.com
  > http://www.sammic.com
  > Telf. +34 - 943 157 331
  > Fax +34 - 943 151 276
  > ..............................................
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Fermin Bernaus Berraondo
  > INET: fbernaus_at_sammic.com
  >
  > Fat City Network Services -- 858-538-5051
  > http://www.fatcity.com
  > San Diego, California -- Mailing list and web
  > hosting services
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  >
  

  ---

Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

---

Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Apr 03 2003 - 09:04:03 CST