Using Figure 8-18 as a reference, suppose the log writer (LGWR) background process just finished writing to redo log group RLOG 100, and is ready switch to redo log group RLOG 200 and begin writing. However, the database writer background process (not shown) is still finishing the checkpoint related to the redo entries in redo log group RLOG 200. If the log writer background process were to switch and begin writing into redo log group RLOG 200, it would overwrite committed transaction details that at that time may only reside in the buffer cache. If the instance crashed, the committed transactions, which reside only in the buffer cache, would be lost forever! To prevent this, in this example, the log writer background process will wait to switch and wait to begin writing into redo log group RLOG 200 until the database writer background process has finished writing all the dirty buffers related to the checkpoint. While the log writer background process is waiting (effectively stopped writing) it will post a log file switch (checkpoint incomplete) wait event.

The solution is very simple. Add more redo log groups to give the database writer background process more time to complete the checkpoint. If the log switch rate is uncomfortably fast,8 then create new, larger redo log group members, and drop the old redo log groups. No downtime is involved when adding or dropping the online redo logs.

Similar to the checkpoint incomplete wait event, if an online redo log is being archived, the log writer background process will not switch to it and begin writing until it has been archived. Doing so would destroy redo that has not yet been archived. If the log writer encounters a nonarchived redo log, it will stop writing and post the wait event log file switch (archive incomplete).