| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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_028D_01C00EA7.C0742BA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
OEMHi,
In this case you have two way:
Or a combination of both.
3) You have also a third option to change all indexes for the tables = which are updated/inserted to nologging..
If you need to restore the database you need just to rebuild the = indexes.=20
Danut,
Tele-Pages Inc.=20
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca
Hi 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_028D_01C00EA7.C0742BA0
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>In this case you have two way:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>1) increase the size of redo logs file</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>2) add more redo logs files</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>Or a combination of both.</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>3) You have also a third option to change all =indexes for the=20
<DIV> </DIV> <DIV> </DIV> <DIV><FONT size=3D2>Danut,</FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV>-------------------------------------------------------------<BR>Dan=ut=20
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
<DIV><BR></DIV> <DIV><FONT face=3DArial size=3D2>Hi Danut,</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>the database is running in =archive=20
<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 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:danut_at_telepages.ca" = title=3Ddanut_at_telepages.ca>Danut=20
Bancea</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 9:49=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: checkpoint =
error</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=20
problem exits only when the database is not in archive logs, or the = archive=20
process can 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)=20
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=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
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=20
have 8 RedoLog files each 83 MB(Total 650 MB). In my<BR> =
system,=20
sometimes Oracle hangs, at that time I got the following=20
;<BR><BR> SQL> select group#,status from=20
v$log;<BR><BR> GROUP# =
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=20
CURRENT<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>
Received on Fri Aug 25 2000 - 14:18:41 CDT
 |
 |