Incremental checkpoint up to RBA

Incremental checkpoint up to RBA [0x5.f5b51.0], current log tail at RBA [0x5.f6127.0]

有这样的信息出现在 alert 中。  说明有增量检查点发生。

当LOG_CHECKPOINTS_TO_ALERT 设置为true时，alert中会记录 检查点的信息。 

Incremental Checkpoint Up To RBA ,Current Log Tail at RBA (Doc ID 568049.1)

APPLIES TO:

Oracle Server - Enterprise Edition - Version 10.1.0.2 and later

Information in this document applies to any platform.

***Checked for relevance on 19-Jun-2012***

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 is 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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-772869/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-772869/