Re: cannot allocate log seq,

Start DEcreasing log_buffer; it will hold a lot of data, taking extra time to flush during checkpointing. Increase log_checkpoint_interval to e.g. 100000 or 1 million, to prevent log checkpoint happining other than at log switches. You can chek that by setting log_checkpoints_to_alert to TRUE for a while, and see if any checkpointing occurs other than during log swithing.
Remove log_checkpoint_timeout alltogether. BTW, is the an extra line, like

cannot allocate log sequence
checkpoint incomplete
???
What version are you on? pre-8 would require manual creation of a seperate checkpointing process (checkpoint_process=TRUE). 8 and up will do automatically.

Yong wrote:
>
> why don't you add log group not log members....
>
> <ilamaran_at_my-deja.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
> news:8nhifp$ngb$1_at_nnrp1.deja.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> > Every night at a particular time, in my production i got a message
> >
> >
> > cannot allocate log sequence,
> > Thread 1 advanced log sequence
> >
> > I already added log members also and increaseing the log
> > buffer in the init file,after shutdown and restart. I have
> > increase the checkpoint time intervel to 11000 but i got the same
> > message in the alert file. Any one suggest me maran
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Thu Aug 24 2000 - 05:37:12 CDT