Re: checkpoint error

From: Danut Bancea <danut_at_telepages.ca>
Date: Thu, 24 Aug 2000 13:44:29 -0400
Message-Id: <10599.115493@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0148_01C00DD1.6D0628A0 Content-Type: text/plain;

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

OEMHi,

I met with this problem before, and I found that the problem exits only = when the database is not in archive logs, or the archive process can not = copy fast enough the redo logs.

Do you have the archive redo logs on separate hard drive ?

How often do you commit during the mass insert/update ?

Danut,

Danut Bancea
Oracle DBA

Tele-Pages Inc.=20
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca

Original Message -----=20 From: Zeliha Y.D.=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, August 24, 2000 8:34 AM Subject: checkpoint error

Hi 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

  =20
   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_0148_01C00DD1.6D0628A0 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.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I met with this problem before, and I found that the =
problem=20
exits only when the database is not in archive logs, or the archive = process can=20
not copy fast enough the redo logs.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Do you have the archive redo logs on separate hard =
drive=20
?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>How often do you commit during the mass =
insert/update=20
?</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Danut,</FONT></DIV>
<DIV> </DIV>
<DIV>-------------------------------------------------------------<BR>Dan=
ut=20
Bancea<BR>Oracle DBA</DIV>
<DIV> </DIV>
<DIV>Tele-Pages Inc. <BR>Phone : (416) 296-9011 Ext. 2271<BR>Fax : (905) =

477-7062<BR>E-mail : <A=20
href=3D"mailto:danut_at_telepages.ca">danut_at_telepages.ca</A></DIV>
<DIV> </DIV>
<DIV>-------------------------------------------------------------</DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:zeliha.yilmaz_at_aski.gov.tr"=20   title=3Dzeliha.yilmaz_at_aski.gov.tr>Zeliha Y.D.</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, August 24, 2000 = 8:34=20
  AM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> checkpoint error</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>
  <DIV style=3D"FONT: 10pt arial">Hi all,</DIV>
  <DIV style=3D"FONT: 10pt arial"><BR>&nbsp;&nbsp;Our system<BR>&nbsp; =

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=20
  Oracle 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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15=20
  ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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">&nbsp;</DIV>
  <DIV style=3D"FONT: 10pt arial">how to do it?</DIV>
  <DIV style=3D"FONT: 10pt arial">&nbsp;</DIV>
  <DIV style=3D"FONT: 10pt arial">thanks, </DIV>
  <DIV style=3D"FONT: 10pt arial">&nbsp;</DIV>

Received on Thu Aug 24 2000 - 12:44:29 CDT