Re: cannot allocate log seq,

It's possible that you cannot allocate a new log because the one it wants is being archived and hasn't finished yet. You can try adding a new group  not a new member ). If that doesn't work, you may need to create new redo logs that are larger than the ones you have so it takes longer to fill one up - perhaps giving the archiver more time to write the archive log out before a log switch needs to occur.

You might also want to try and tune this through the log_checkpoint_timeout and log_checkpoint_interval parameters and/or log_archive_buffers and log_buffer parameters.

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
<ilamaran_at_my-deja.com> wrote in message 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.