Multiple choice

While checking the alert log for the database many lines are discovered that say "Checkpoint Not Complete". How can the problem be solved?

  1. Delete archived log files

  2. Add more online redo log groups

  3. Increase the size of archived log files

  4. increase the size of online redo log files
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

The 'Checkpoint Not Complete' message occurs when LGWR cannot write to redo log files because a checkpoint hasn't completed. This happens when redo logs are too small or too few. Solutions include: adding more redo log groups (B) so LGWR has more available logs, and increasing size of online redo log files (D) to provide more space between checkpoints. Deleting archived logs (A) doesn't help and increasing archived log size (C) is irrelevant.

Keep practicing — related questions