Re: Redo log question

On 1 Jan 1998 21:12:37 GMT, robw95_at_aol.com (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'.

I had the same problem awhile back, and solved it by creating more redo log groups. Oracle support was no help--they couldn't tell me the reason for the message. After doing some reading I came to the conclusion that the redo log writer was not keeping up with the database writer. Received on Sat Jan 03 1998 - 00:00:00 CST