Oracle Database Discussions

Hello,

I've read many entries on the web that this message does not cause any freezes, and I should not worry about it if the gap of log sequence numbers between the message and the completed log switch is not large. If anyone can help me learn, my question is this:

When this message comes up, does that mean at that moment the entire DB is frozen until the following successful log switch is ? I was getting the checkpoint not complete error too, but by adding log files I managed to avoid them. I know getting that error will mean the DB is frozen for sure. I counted the number of times this error showed up 30 hours or so, and I got 78 of them. If I were getting one or two a day, I would not worry about it.

Here is a sample from my alert.log:

Tue Apr 26 11:41:31 2011
Beginning log switch checkpoint up to RBA [0x44fd.2.10], SCN: 5971408682051
Thread 1 advanced to log sequence 17661 (LGWR switch)
Current log# 10 seq# 17661 mem# 0: /redo/oracle/PROD/db/apps_st/data/log10a.dbf
Tue Apr 26 11:41:50 2011
Incremental checkpoint up to RBA [0x44fa.2e911.0], current log tail at RBA [0x44fd.352d2.0]
Tue Apr 26 11:46:58 2011
Thread 1 cannot allocate new log, sequence 17662
Private strand flush not complete <-----------------------------------------------
Current log# 10 seq# 17661 mem# 0: /redo/oracle/PROD/db/apps_st/data/log10a.dbf
Tue Apr 26 11:47:04 2011
Completed checkpoint up to RBA [0x44fb.2.10], SCN: 5971408027486
Beginning log switch checkpoint up to RBA [0x44fe.2.10], SCN: 5971409066839
Thread 1 advanced to log sequence 17662 (LGWR switch)
Current log# 4 seq# 17662 mem# 0: /redo/oracle/PROD/db/apps_st/data/log04a.dbf
Tue Apr 26 11:49:57 2011
Completed checkpoint up to RBA [0x44fc.2.10], SCN: 5971408413358
Tue Apr 26 11:50:52 2011
Completed checkpoint up to RBA [0x44fd.2.10], SCN: 5971408682051
Tue Apr 26 11:51:12 2011
Completed checkpoint up to RBA [0x44fe.2.10], SCN: 5971409066839
Tue Apr 26 11:51:26 2011

Thanks,
Vicken