Thread 1 cannot allocate new log, sequence

I got ” Thread 1 cannot allocate new log, sequence ”  error in Oracle database.

Thread 1 cannot allocate new log, sequence

Details of error are as follows.

Thread 1 cannot allocate new log, sequence 204

Checkpoint not complete

Thread 1 cannot allocate new log, sequence

To solve this error, increase the archive_lag_target as follows.

SQL> show parameter archive_lag_target;
SQL> alter system set archive_lag_target=0 scope=both sid=’*’;
or
SQL> alter system set archive_lag_target=1800 scope=both sid=’*’;

Or you should add new logfiles as follows.

ALTER DATABASE ADD LOGFILE GROUP 6 (‘+DATA/TESTDB/ONLINELOG/redotest06.log’) SIZE 1024M;

ALTER DATABASE ADD LOGFILE GROUP 7 (‘+DATA/TESTDB/ONLINELOG/redotest07.log’) SIZE 1024M;

ALTER DATABASE ADD LOGFILE GROUP 8 (‘+DATA/TESTDB/ONLINELOG/redotest08.log’) SIZE 1024M;

ALTER DATABASE ADD LOGFILE GROUP 7 (‘+DATA/TESTDB/ONLINELOG/redotest09.log’) SIZE 1024M;

Or You may Drop and recreate redolog files with size greater than earlier.

ALTER DATABASE DROP LOGFILE GROUP 3;
ALTER DATABASE ADD LOGFILE GROUP 3 (‘+DATA/TESTDB/ONLINELOG/redotest.log’) SIZE 16384M;

You should perform this action for all existing logfiles.

You should read the following post to learn more details about Redolog files and how to manage them.

Do you want to learn Oracle Database for Beginners, then read the following articles.