Re: Alert log message question

From: Joel Garry <joelga_at_pebble.org>
Date: Thu, 23 Jul 1998 22:54:04 GMT
Message-Id: <slrn6rffri.a1i.joelga@pebble.org>

On Thu, 23 Jul 1998 14:26:45 GMT, shermanej_at_eccic.com <shermanej_at_eccic.com> wrote:
>I sometimes see the following in my alert log after batch jobs have been
>run:
>
>
>Sun Jul 19 15:07:14 1998
>Thread 1 cannot allocate new log, sequence 19514
>Checkpoint not complete
> Current log# 1 seq# 19513 mem# 0: /oracle4/dbs73/PROD/redoPROD07a.log
> Current log# 1 seq# 19513 mem# 1: /oracle1/dbs73/PROD/redoPROD07b.log
> .
> .
> .
>Wed Jul 22 01:06:29 1998
>Thread 1 cannot allocate new log, sequence 19590
>Checkpoint not complete
> Current log# 9 seq# 19589 mem# 0: /oracle4/dbs73/PROD/redoPROD12a.log
> Current log# 9 seq# 19589 mem# 1: /oracle1/dbs73/PROD/redoPROD12b.log
> .
> .
> .
>Thu Jul 23 05:38:55 1998
>Thread 1 cannot allocate new log, sequence 19621
>Checkpoint not complete
> Current log# 4 seq# 19620 mem# 0: /oracle2/dbs73/PROD/redoPROD1a.log
> Current log# 4 seq# 19620 mem# 1: /oracle1/dbs73/PROD/redoPROD1b.log
>
>
>
>
>Log switches occur about 1 minute apart during these batch jobs and 20-30
>minutes apart during normal database activity.
>
>We tried creating another pair of redo log files and I'm not sure that it
>really helped. I'm wondering if creating more redo log files is really the
>way to go.
>
>Any ideas on how to solve the "Checkpoint not complete" problem?
>

Make your log files larger.
Read about LOG_CHECKPOINT_INTERVAL, LOG_CHECKPOINT_TIMEOUT, CHECKPOINT_PROCESS. Think about your recovery procedures and what real granularity you need to recover to. You can force log switches to occur periodically with ALTER SYSTEM. So use much larger log files to handle the batch jobs, and cron to keep the granularity constant.

>Thanks in advance
>Ed Sherman
>
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Jul 23 1998 - 17:54:04 CDT