Can Not Allocate Log (Doc ID 1265962.1)

Last updated on JULY 31, 2017

Applies to:

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

Goal

PROBLEM DESCRIPTION

Error messages in alert log:

Thread <number> cannot allocate new log, sequence <number>
Checkpoint not complete

OR / AND

ORACLE Instance <name> - Can not allocate log, archival required
Thread <number> cannot allocate new log, sequence <number>

From the AWR we can see what issue is more frequent:

a) DBWR has not finished checkpointing (log file switch (checkpoint incomplete) )
b) ARCH has not finished copying the redo log file to the archive destination (Archival required)

These error messages are addressed in a similar way.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms