| Thread 1 cannot allocate new log [message #378153] |
Mon, 29 December 2008 03:05  |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
