Home » RDBMS Server » Performance Tuning » Thread 1 cannot allocate new log
Thread 1 cannot allocate new log [message #378153] Mon, 29 December 2008 03:05 Go to next message
suspect
Messages: 2
Registered: December 2008
Junior Member
Dear Guru,

Please help. Does "Thread 1 cannot allocate new log" relate to hang situation?
In the log shown.
Mon xx 15:14:07 xx
ARC0: Completed archiving log 1 thread 1 sequence 75563
ARC0: Evaluating archive log 4 thread 1 sequence 75564
ARC0: Unable to archive log 4 thread 1 sequence 75564
Log actively being archived by another process
ARC0: Evaluating archive log 3 thread 1 sequence 75565
ARC0: Beginning to archive log 3 thread 1 sequence 75565
Creating archive destination LOG_ARCHIVE_DEST_2: 'xxx'
Mon xx 15:14:07 xx
Beginning log switch checkpoint up to RBA [xx], SCN: xx
Thread 1 advanced to log sequence 75567
Current log# 1 seq# 75567 mem# 0: /oracle/xx.dbf
Current log# 1 seq# 75567 mem# 1: /oracle/xx.dbf
Mon xx 15:14:07 xx
Creating archive destination LOG_ARCHIVE_DEST_1: 'xxx'
Mon xx 15:17:45 xx
Completed checkpoint up to RBA [xx], SCN: xx
Mon xx 15 15:18:17 xx
ORACLE Instance R3P - Can not allocate log, archival required
Mon xx 15:18:17 xx
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 75568
All online logs needed archiving
Current log# 1 seq# 75567 mem# 0: /oraclexx.dbf
Current log# 1 seq# 75567 mem# 1: /oracle/xx.dbf
Mon xx 15:24:56 xx
ARC1: Completed archiving log 4 thread 1 sequence 75564
Mon xx 15:24:56 xx
Beginning log switch checkpoint up to RBA [xx], SCN: xx
Thread 1 advanced to log sequence 75568
Current log# 4 seq# 75568 mem# 0: /oracle/xx.dbf
Current log# 4 seq# 75568 mem# 1: /oracle/xx.dbf
Mon xx15:24:56 xx
ARC1: Evaluating archive log 3 thread 1 sequence 75565
ARC1: Unable to archive log 3 thread 1 sequence 75565
Log actively being archived by another process
ARC1: Evaluating archive log 2 thread 1 sequence 75566
ARC1: Beginning to archive log 2 thread 1 sequence 75566
Creating archive destination LOG_ARCHIVE_DEST_2: 'xxx'
Creating archive destination LOG_ARCHIVE_DEST_1: 'xxx'
Mon xx 15:30:18 xx
Completed checkpoint up to RBA [xx], SCN: xx
Mon xx 15:31:15 xx
ORACLE Instance R3P - Can not allocate log, archival required
Mon xx 15:31:15 xx8
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 75569
All online logs needed archiving
Current log# 4 seq# 75568 mem# 0: /oracle/xx.dbf
Current log# 4 seq# 75568 mem# 1: /oracle/xx.dbf
Mon xx 15:31:20 xx
ARC0: Completed archiving log 3 thread 1 sequence 75565
ARC0: Evaluating archive log 2 thread 1 sequence 75566
ARC0: Unable to archive log 2 thread 1 sequence 75566
Log actively being archived by another process
ARC0: Evaluating archive log 1 thread 1 sequence 75567
ARC0: Beginning to archive log 1 thread 1 sequence 75567
Creating archive destination LOG_ARCHIVE_DEST_2: 'xxx'
Creating archive destination LOG_ARCHIVE_DEST_1: 'xxx'

please enlighten me.
Thank you in advance.
Re: Thread 1 cannot allocate new log [message #378163 is a reply to message #378153] Mon, 29 December 2008 03:32 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Try to add another redo log group or extend the size of the existing redo logs.
Re: Thread 1 cannot allocate new log [message #378168 is a reply to message #378163] Mon, 29 December 2008 03:42 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes, that is good advice. You need to add more redo log files or make them bigger.

For more info, see http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:69012348056
Re: Thread 1 cannot allocate new log [message #378174 is a reply to message #378168] Mon, 29 December 2008 03:59 Go to previous message
suspect
Messages: 2
Registered: December 2008
Junior Member
tahpush, Frank Naude! Thanks a lot. I will try.
Previous Topic: One query with two where Conditions on same column
Next Topic: Fetch is taking too long
Goto Forum:
  


Current Time: Sun Dec 11 04:18:13 CST 2016

Total time taken to generate the page: 0.23604 seconds