| 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
Increase the size of your redologs and your problem will be resolved. You
may increase size to 200Mb each and reduce number of files to 5/6 if space
problem.
Regards
Rafiq
From: Lyall Barbour <lbarbour_at_stanford.edu>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: Re: checkpoint error
Date: Thu, 24 Aug 2000 07:39:09 -0800
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.
 |
 |