Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Redo log question

Re: Redo log question

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1998/01/01
Message-ID: <34AC13B6.32A3@deere.com>#1/1

Been there, seen that!

Your batch load is inserting data so fast that a checkpoint cannot complete before another log is full.

Do ue the checkpoint process.

If this is not enough, increase the size of the log files. (I recently increased from 20 MB to 200MB).

RobW95 wrote:
>
> I recently created a new instance with three groups of redo logs, two members
> each. Each of the redo logs are 20mb each. The log_buffer parameter is set at
> 160k. Checkpoint is not turned on. This instance is basically a repository for
> inquiry so the logs will mostly be used for the weekly batch loads. We have
> been loading data into the instance successfully but I have noticed some
> messages in the alert log that concern me. The logs seem to be switching
> successfully most of the time but occasionally I see the message 'Can't
> allocate new sequence, checkpoint not complete'. The log doesn't seem to switch
> but instead seems to fill itself up again and then next time switches to the
> next log. This message is not an ORA message and I've looked in the reference
> manuals and I can't find anything related to it. There does not seem to be any
> pattern to it. Has anyone seen this before?
>
> Thanks in advance. Rob
Received on Thu Jan 01 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US