Re: Thread 1 cannot allocate new log, sequence
Date: Thu, 2 Oct 2008 08:29:29 -0700 (PDT)
On Oct 2, 8:52 am, "odbio..._at_spamu.pl" <odbio..._at_spamu.pl> wrote:
> I have 2 "Thread 1 cannot allocate new log, sequence" messages in my oracle's alert log. This messeges were few days ago and didn't come back. Is it
> problem. Should I do something with it?
> Thanks in advance
It might be, it might NOT be.
Check your redo log size
SELECT group# "GROUP", bytes "SIZE", status "STATUS" FROM v$log;
and your redo log switch time
SELECT ROUND(AVG(1440 * (b.first_time - a.first_time)), 0) "Log switch
time - minutes"
FROM v$loghist a, v$log b
WHERE b.sequence# = a.sequence# + 1
AND a.sequence# = (SELECT MAX(sequence#) FROM v$loghist) ORDER BY a.sequence#;
You're probably running that database in archivelog mode and the error was generated because of an archiving issue. It could also be generated by a 'checkpoint not complete' problem. Transactional activity in your database may have hit a new 'high' at the point those error messages appeared, causing Oracle to fall behind on it's archiving of the older redo logs prior to re-use because the log switch time decreased dramatically.
Of course without actually seeing your system and its activity level all of this is simply guesswork.
David Fitzjarrell Received on Thu Oct 02 2008 - 10:29:29 CDT