cannot allocate new log sequence [message #322476] |
Fri, 23 May 2008 12:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
liamadherne
Messages: 40 Registered: March 2008 Location: Philadelphia
|
Member |
|
|
One of my production DB alert log shows cannot allocate new log, sequence 5331
Earlier my redo log file size was 150M, and now i added 4 new redo log groups with 500M log member each onto a diffrent mount points and dropped the older ones.
while doing alter system switch logfile; i still get the same message in the alert.
select group#,status,sum(bytes)/1024/1024 from v$log group by group#,status;
GROUP# STATUS SUM(BYTES)/1024/1024
---------- ---------------- --------------------
1 ACTIVE 500
3 INACTIVE 500
2 CURRENT 500
4 INACTIVE 500
piece of alert log is herewith.
Quote: | Thread 1 cannot allocate new log, sequence 5327
Checkpoint not complete
Current log# 3 seq# 5326 mem# 0: /intora5/oradata/nasoldb/redo004.log
Thread 1 advanced to log sequence 5327
Current log# 4 seq# 5327 mem# 0: /intora2/oradata/nasoldb/redo01.log
Fri May 23 22:33:10 2008
Thread 1 cannot allocate new log, sequence 5328
Checkpoint not complete
Current log# 4 seq# 5327 mem# 0: /intora2/oradata/nasoldb/redo01.log
Thread 1 cannot allocate new log, sequence 5328
Private strand flush not complete
Current log# 4 seq# 5327 mem# 0: /intora2/oradata/nasoldb/redo01.log
Thread 1 advanced to log sequence 5328
Current log# 6 seq# 5328 mem# 0: /intora4/oradata/nasoldb/redo03.log
Thread 1 cannot allocate new log, sequence 5329
Checkpoint not complete
|
Any suggestion will be highly appreciated.
Thanks
Regards
Liam.
|
|
|
|
Re: cannot allocate new log sequence [message #322486 is a reply to message #322476] |
Fri, 23 May 2008 13:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
liamadherne
Messages: 40 Registered: March 2008 Location: Philadelphia
|
Member |
|
|
Hi Michel,
I have already gone through the google search, all i got is to add more redo groups or increase the redo log file size.
I did that already, i have 4 log groups with 500 MB each.
Any ideas will be highly appreciated.
|
|
|
|
|
Re: cannot allocate new log sequence [message #322528 is a reply to message #322476] |
Sat, 24 May 2008 02:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
You said,
Quote: | Earlier my redo log file size was 150M, and now i added 4 new redo log groups with 500M log member each onto a diffrent mount points and dropped the older ones
|
But where did you add log groups? You just created new ones and drop old ones.
|
|
|