Re: checkpoint error

From: Lyall Barbour <lbarbour_at_stanford.edu>
Date: Thu, 24 Aug 2000 07:26:30 -0700
Message-Id: <10599.115472@fatcity.com>

--=====================_148974093==_.ALT

Content-Type: text/plain; charset="us-ascii"; format=flowed

There's an init.ora parameter, DB_WRITERS (??) that you can change. For 7.2, huummm, I not sure you can add more dbwr's in 7.2. But with the error you're getting, I'd also add more redo log groups. Sure you've got eight! But you can always use more redo log groups, it never hurts. Lyall Barbour

At 04:34 AM 8/24/00 -0800, you wrote:
>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
>
>
> 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,
>
>zeliha.

--=====================_148974093==_.ALT

Content-Type: text/html; charset="us-ascii"

<html>
<x-tab>        </x-tab>There's an init.ora parameter, DB_WRITERS (??) that you can change.  For 7.2, huummm, I not sure you can add more dbwr's in 7.2.  But with the error you're getting, I'd also add more redo log groups.  Sure you've got eight!  But you can always use more redo log groups, it never hurts. 
Lyall Barbour 
 
At 04:34 AM 8/24/00 -0800, you wrote: <blockquote type=cite cite>Hi all,

&nbsp; Our system<br>
&nbsp; DUNIX 4.0D<br>
&nbsp; Alpha 4100 with 2 GB RAM, 2 x 467 MHZ CPU<br>
&nbsp; Oracle 7.2.3<br>
&nbsp; I have a problem.<br>
&nbsp; I have 8 RedoLog files each 83 MB(Total 650 MB). In my<br>
&nbsp; system, sometimes Oracle hangs, at that time I got the following

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

&nbsp;&nbsp;&nbsp;&nbsp; GROUP# STATUS<br>
&nbsp;---------- ----------------<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11 ACTIVE<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12 ACTIVE<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13 ACTIVE<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14 ACTIVE<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15 ACTIVE<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16 CURRENT<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17 ACTIVE<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18 ACTIVE<br>

.. and in the alert log file I had the following... 
 contents of alert.log:

&nbsp; Thread 1 cannot allocate new log, sequence 8230<br>
&nbsp; Checkpoint not complete<br>
&nbsp;&nbsp;&nbsp; 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? 
  Received on Thu Aug 24 2000 - 09:26:30 CDT