Wednesday, September 17, 2014

Databases are suffering from "Checkpoint not complete" in alertlog


V$log listing all the groups are in  ACTIVE and CURRENT status and alert log listing checkpoint not complete

Setting the parameter archive_lag_target   from 180sec to 900 sec resolved the issue, 

Check the impact of setting archive_lag_target in your environment

No comments: