11.1.0.6 -> Thread 1 cannot allocate new log, sequence #
I am running database in version 11.1.0.6. I am facing "Thread 1 cannot allocate new log, sequence #" in the alert log frequently.
We have 10 redo log groups sized 500 MB each.
We have set log_archive_max_processes = 4, log_checkpoint_interval = 0, db_writer_processes = 2.
In addition, status is active for 3 redo log groups.
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -----------------
1 1 6961 524288000 1 YES INACTIVE 1720123233 22_10_10 02:41:06
2 1 6962 524288000 1 YES INACTIVE 1720243531 22_10_10 03:04:31
3 1 6963 524288000 1 YES INACTIVE 1720682323 22_10_10 03:22:27
4 1 6964 524288000 1 YES INACTIVE 1720975732 22_10_10 03:24:49
5 1 6965 524288000 1 YES INACTIVE 1721187992 22_10_10 03:25:31
6 1 6966 524288000 1 YES ACTIVE 1721270111 22_10_10 04:34:41
7 1 6967 524288000 1 YES ACTIVE 1721292676 22_10_10 06:31:45
8 1 6968 524288000 1 YES ACTIVE 1721302983 22_10_10 07:53:22
9 1 6969 524288000 1 NO CURRENT 1721302999 22_10_10 07:53:32
10 1 6960 524288000 1 YES INACTIVE 1719868380 22_10_10 02:39:42
Would appreciate your comments.