Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Thread 1 cannot allocate new log, sequence 36286 Checkpoint not complete while doing import

Posted by Hendry chinnapparaj on June 14, 2012

Problem:- Oracle10g Import is slow and see the warnings in the Oracle Alert Log

Thread 1 advanced to log sequence 36285 (LGWR switch)
Current log# 2 seq# 36285 mem# 0: F:\ORACLE\ORADATA\MZSTWCD1\MZSTWCD1_REDO02A.LOG
Current log# 2 seq# 36285 mem# 1: G:\ORACLE\ORADATA\MZSTWCD1\MZSTWCD1_REDO02B.LOG
Thread 1 cannot allocate new log, sequence 36286
Checkpoint not complete

Cause:- 

The “checkpoint not complete” messages are generated because the logs are switching so fast that the checkpoint associated with the log switch isn’t complete.

During that time, Oracle’s LGWR process has filled up the other redo log groups and is now waiting for the first checkpoint to successfully execute.

Remember, Oracle will stop processing until the checkpoint completes successfully!

Solution:- It’ll take a while to complete. Examine your redologs size, increase the Size so that it can keep up with completing the checkpoint without waiting. Increase the redolog size so that you can have like 4 switches in an hour and add additional one /more redo logs if required.

Shalom

Hendry

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: