On 21 sep, 14:02, Michael <mbulch... (AT) gmail (DOT) com> wrote:
Quote:
We have 10 redo logs each of 150M in size and 2 members in each group.
We have been constanly getting a message of CHECKPOINT NOT
COMPLETE.
What can we do to get rid of this checkpoint error? *Should we
increase the size of our redo logs?
Thanks in advance for your help.
Michael |
150MB is pretty small... ROT is 1GB, three groups minimum for me
(but... beware of ROTs).
Mark has given pretty solid advise, that is a lot more precise.