I am seeing very slow import utility because of redo.log file errors
"Checkpoint cannot complete". I'm assuming that I need to add
redo.log files to accommodate the checkpoint not complete message?
What else can I do to reduce the checkpoint not complete messages in
my alert log?
Answer: 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
Remember, Oracle will stop processing until the checkpoint completes
Usually you see this "checkpoint not complete" error in your alert
Thu Jan 14 22:12:55 2011
Thread 1 cannot allocate new log, sequence 46352
MOSC note 435780.1 has tips
on avoiding the checkpoint not complete error: