alert log showing cannot allocate a new log
Posted on 2011-09-26
Users are having problem running an application...too slow...In the alert.log file, it is showing Thread 1 cannot allocate a new log. Initially, there are 5 redo logs group with 3 members each log with 100MB. Then I increase the log size to 200MB; but did not help. It is still showing cannot allocate a new log file.
I tried to add another new group but cannot create saying cannot allocate new group. If I add another member it says, it has reached max.
We are on Oracle 18.104.22.168.
Any help is greatly appreciated.