Skip to Content
0
Former Member
Jun 23, 2008 at 01:07 AM

Checkpoint not complete after Oracle10g upgrade

96 Views

OS: AIX 5.3

SAP: R/3 46C, 46D_EXT kernel

DB: 10.2.0.2

After upgrading Oracle from 9.2.0.8 to 10.2.0.2 in four SAP systems, Checkpoint not complete warning messages are detected when running CheckDB in DB13.

"BR0976W Database message alert - level: WARNING, line: 4577, time: 2008-06-23 00.25.21, message: Checkpoint not complete"

What I have done after reading OSS 1068186 & 79341 is - Set "_DISABLE_SELFTUNE_CHECKPOINTING" = TRUE ---> This seems to reduce the number of message but doesn't eliminate the issue.

The next step is probably to increase the size of the redo log files. Just wonder if anyone has any clue on this warning and how to resolve it?

Points will be given for helpful tips and information.

Thanks,

Annie