| cannot allocate new log sequence [message #322476] |
Fri, 23 May 2008 12:40  |
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;
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
