Home » RDBMS Server » Server Administration » cannot allocate new log sequence (10G/Solaris 10)
cannot allocate new log sequence [message #322476] Fri, 23 May 2008 12:40 Go to next message
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 #322483 is a reply to message #322476] Fri, 23 May 2008 13:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=oracle+%22cannot+allocate+new+log%22&btnG=Recherche+Google&meta=

Regards
Michel
Re: cannot allocate new log sequence [message #322486 is a reply to message #322476] Fri, 23 May 2008 13:17 Go to previous messageGo to next message
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 #322487 is a reply to message #322476] Fri, 23 May 2008 13:21 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Any ideas will be highly appreciated.
I strongly suspect that if you bounce the database, things will be OK for a while.
Re: cannot allocate new log sequence [message #322493 is a reply to message #322486] Fri, 23 May 2008 13:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You went through the threads, so you know the reasons for this, don't you?
If so, list them and we will see where to start.

Regards
Michel
Re: cannot allocate new log sequence [message #322528 is a reply to message #322476] Sat, 24 May 2008 02:36 Go to previous message
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.
Previous Topic: which character set is suitable for Euro
Next Topic: Delete bdump cdump udump
Goto Forum:
  


Current Time: Sat Dec 03 09:38:48 CST 2016

Total time taken to generate the page: 0.12757 seconds