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).
Received on Thu Apr 03 2003 - 05:03:43 CST