checkpoint error

From: Zeliha Y.D. <zeliha.yilmaz_at_aski.gov.tr>
Date: Thu, 24 Aug 2000 14:34:04 +0300
Message-Id: <10599.115452@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0225_01C00DD8.5A8D7190 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

OEMHi all,

  Our system
  DUNIX 4.0D
  Alpha 4100 with 2 GB RAM, 2 x 467 MHZ CPU   Oracle 7.2.3

I have a problem.
I have 8 RedoLog files each 83 MB(Total 650 MB). In my system, sometimes Oracle hangs, at that time I got the following ;

SQL> select group#,status from v$log;

GROUP# STATUS

---------------- 11 ACTIVE 12 ACTIVE 13 ACTIVE 14 ACTIVE 15 ACTIVE 16 CURRENT 17 ACTIVE 18 ACTIVE

.. and in the alert log file I had the following...

contents of alert.log:

Thread 1 cannot allocate new log, sequence 8230 Checkpoint not complete
Current log# 12 seq# 8229 mem# 0: /ctl/redo/log12SEVDE.rdo

The reason for this, there is a very large Update/delete/insert = transactions
from 1 (or more) process.

Someone offered to increase number of DBWR background process.

how to do it?

thanks,=20

zeliha.

------=_NextPart_000_0225_01C00DD8.5A8D7190 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>OEM</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV style=3D"FONT: 10pt arial">Hi all,</DIV>
<DIV style=3D"FONT: 10pt arial"><BR>  Our system<BR>  =
DUNIX=20
4.0D<BR>  Alpha 4100 with 2 GB RAM, 2 x 467 MHZ CPU<BR>  = Oracle=20
7.2.3<BR></DIV>
<DIV style=3D"FONT: 10pt arial">  I have a problem.<BR>  =
I have 8=20
RedoLog files each 83 MB(Total 650 MB). In my<BR>  system, = sometimes Oracle=20
hangs, at that time I got the following ;<BR><BR> SQL> select=20 group#,status from v$log;<BR><BR>     GROUP#=20 STATUS<BR> ----------=20

----------------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11=20
ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12=20
ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13=20
ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14=20

ACTIVE<BR>         15=20 ACTIVE<BR>         16=20 CURRENT<BR>         17=20 ACTIVE<BR>         18 = ACTIVE<BR><BR>..=20
and in the alert log file I had the following...<BR><BR> contents = of=20
alert.log:</DIV>
<DIV style=3D"FONT: 10pt arial"><BR>  Thread 1 cannot allocate new =
log,=20
sequence 8230<BR>  Checkpoint not complete<BR>    = Current=20
log# 12 seq# 8229 mem# 0: /ctl/redo/log12SEVDE.rdo</DIV>
<DIV style=3D"FONT: 10pt arial"><BR> </DIV>
<DIV style=3D"FONT: 10pt arial"> The reason for this, there is a =
very large=20
Update/delete/insert transactions<BR>from 1 (or more) = process.</DIV>
<DIV style=3D"FONT: 10pt arial"> </DIV>
<DIV style=3D"FONT: 10pt arial">Someone offered to increase number =
of DBWR=20
background process.</DIV>
<DIV style=3D"FONT: 10pt arial"> </DIV>
<DIV style=3D"FONT: 10pt arial">how to do it?</DIV>
<DIV style=3D"FONT: 10pt arial"> </DIV>
<DIV style=3D"FONT: 10pt arial">thanks, </DIV>
<DIV style=3D"FONT: 10pt arial"> </DIV>
<DIV style=3D"FONT: 10pt arial">zeliha.</DIV></FONT></DIV></BODY></HTML>
Received on Thu Aug 24 2000 - 06:34:04 CDT