Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: checkpoint error
This is a multi-part message in MIME format.
------=_NextPart_000_007C_01C00E79.DE0B2D40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
OEMHi Danut,
the database is running in archive logs, the archive process can copy =
fastly the redo logs.
when I query v$log, I see ARCHIVED is "YES", but STATUS is "ACTIVE".
sometimes, when running batch processes on database , this problem =
appears.
because of the completeness of the process, commit statement is at the =
end of process.
So that the commit statement is not too often.
Zeliha YILMAZ
DBA (ASKI)
Tel : +903123115361
Fax : +903123241598=20
Hi,
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,
Tele-Pages Inc.=20
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca
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_007C_01C00E79.DE0B2D40
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>Hi Danut,</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>the database is running in archive =
logs, the archive process can copy fastly the redo =
logs.</FONT><FONT=20
face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>when I query v$log, I see ARCHİVED =
is "YES", but=20
STATUS is "ACTIVE".</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>sometimes, when running batch =
processes on=20
database , this problem appears.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>because of the completeness of the =
process, commit=20
statement is at the end of process.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>So that the commit statement =
is not=20
too often.</FONT></DIV>
<DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Zeliha YILMAZ</FONT></DIV> <DIV><FONT face=3DArial size=3D2>DBA (ASKI)</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Tel =: +903123115361</FONT></DIV>
<DIV><BR></DIV> <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
<DIV> </DIV> <DIV> </DIV> <DIV><FONT size=3D2>Danut,</FONT></DIV> <DIV> </DIV>
<DIV>-------------------------------------------------------------<BR>Dan=ut=20
<DIV>-------------------------------------------------------------</DIV><BLOCKQUOTE=20
<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=20 href=3D"mailto:ORACLE-L_at_fatcity.com" = title=3DORACLE-L_at_fatcity.com>Multiple=20
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> Our system<BR> =DUNIX=20
7.2.3<BR></DIV>
<DIV style=3D"FONT: 10pt arial"> I have a =
problem.<BR> I have=20
8 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> =11=20
ACTIVE<BR> 12=20 ACTIVE<BR> 13=20 ACTIVE<BR> 14=20 ACTIVE<BR> 15=20 ACTIVE<BR> 16=20CURRENT<BR> 17=20 ACTIVE<BR> 18=20 ACTIVE<BR><BR>.. and in the alert log file I had the=20 following...<BR><BR> contents of alert.log:</DIV> <DIV style=3D"FONT: 10pt arial"><BR> Thread 1 cannot allocate = new log,=20
sequence 8230<BR> Checkpoint not = complete<BR> =20
Current 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=20
large Update/delete/insert transactions<BR>from 1 (or more)=20
process.</DIV>
<DIV style=3D"FONT: 10pt arial"> </DIV>
<DIV style=3D"FONT: 10pt arial">Someone offered to increase =
number of=20
DBWR 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>Received on Fri Aug 25 2000 - 01:50:14 CDT