Re: Cannot allocate new log - checkpoint not complete

Hello

I read all the posts so far and would like to add 2 points:

1. When you increase the size of the redo logs you increase the peak load on the I/O subsystem when a redo log is filled. So you got less switches but the peak I/O is greater. If you use more logs with smaller size you decrease the peak load on the I/O subsystem.
2. You said that the problem is during import. I think (correct me someone if I am wrong) that the redo data is caused mainly by adding rows to the tables in the data files and much less by commands such as create index. So in your case I think that moving the redo log to the disk that contain your indexes will be a great help.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, April 03, 2003 10:03 AM

>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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).