My Oracle Support Banner

Manual Log Switching Causing "Thread 1 Cannot Allocate New Log" Message in the Alert Log (Doc ID 435887.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3



Symptoms

When you manually switch the online redo logs with an alter system command as below.

SQL> alter system switch logfile;
System altered.

The Alert log will display the following messages.

Thread 1 cannot allocate new log, sequence 207
Checkpoint not complete

- or -

Thread 1 cannot allocate new log, sequence 746
Private strand flush not complete

Changes

Implemented a scheduler job to manually switch the online redo logs every 15 minutes.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.