03 December 2010

Incremental checkpoint up to RBA [0xd9.fa764.0], current log tail at RBA [0xd9.fdd11.0]

Incremental Checkpoint Up To RBA ,Current Log Tail at RBA [ID 568049.1]


In this Document
  Symptoms
  Changes
  Cause
  Solution
  References




Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 30-Sep-2010***

Symptoms

The following message appears several times in the alert.log file:
Incremental checkpoint up to RBA [0x5.f5b51.0], current log tail at RBA [0x5.f6127.0]

Changes

Upgraded to a 10g Database Version.

Cause

Those messages in the alert.log are all fine, and are expected behavior if the parameter LOG_CHECKPOINTS_TO_ALERT is set to TRUE. This logs all the incremental checkpoints to the alert log. So, the above informative messages indicate that incremental checkpoints have occurred.

Solution

To disable these messages,
set log_checkpoints_to_alert=FALSE
in the parameter file and restart the Database.
Also, it's worth checking the FAST_START_MTTR_TARGET parameter. Fast-start checkpointing can be explicitly disabled by setting FAST_START_MTTR_TARGET=0. Disabling fast-start checkpointing leads to the fewest average number of writes per transaction for DBWn for a specific workload and configuration, but also results in the highest MTTR.

No comments: