Re: Thread 1 cannot access new log, sequence NNNNN

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 09 Jun 1999 11:43:25 GMT
Message-ID: <37615245.85291302@newshost.us.oracle.com>

A copy of this was sent to Erwin Fritz <efritz_at_GLJA.com> (if that email address didn't require changing) On Tue, 08 Jun 1999 21:32:21 GMT, you wrote:

>I occasionally get messages like the above in my alert log. However, I can't
>find a problem, and there's no explanation about just why the server couldn't
>allocate the log. How do I find this information?
>
>My server platform is a Sun E3000, Solaris 2.5.1, with Oracle 8.0.3.

That message is always followed by a "checkpoint not complete" or "needs archiving" message.

If you have a checkpoint not complete message, that means we are trying to reuse a log file but the data protected by that logfile has not yet been flushed from the SGA to disk so we must finish checkpointing it before we can reuse it. Some ways to fix:

• add more log files so we have more time to checkpoint. have enough log files to get you through your busy period. this varies by system and usage, there is no magic number.
• increase the frequency of your checkpoints using log_checkpoint_interval/log_checkpoint_timeout
• increase the size of your existing logs

If its the archiving thats taking too long some ways to fix:

• add more log files so we have more time to archive. have enough log files to get you through your busy period. this varies by system and usage, there is no magic number.
• speed up your archive by archiving to 'fast' media (eg: don't archive to NFS or tape).
• manually archive using SQL commands.
• decrease the size of your log files (so we archive smaller files more frequently) but don't decrease the total amount of your log.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jun 09 1999 - 06:43:25 CDT