Database Administration (MOSC)

MOSC Banner

Error : Thread 1 cannot allocate new log

How to this message in the alert.log file "Thread 1 cannot allocate new log,
Private strand flush not complete".

Oracle database is 11.2.0.4 .

I add 2 groups of redologs ( 1Go)
I modify the parameter archive_lag_target initially at 900 , i put 1800 and 0
I modify also the parameter db_writer_processus (From 1 to 2)

==⇒ despite of my modifications, I have always the same error.

I noticed that the gap between Thread 1 cannot allocate new log and Thread 1 advanced to log sequence is 3 seconds
Best regards

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center