| Computers Forum Index » Computer - Databases - Oracle (Misc) » Checkpoint not complete... |
|
Page 1 of 1 |
|
| Author |
Message |
| Michael... |
 Posted: Mon Sep 21, 2009 1:02 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Frank van Bortel... |
| Posted: Thu Oct 29, 2009 1:58 pm |
|
|
|
Guest
|
On 21 sep, 14:02, Michael <mbulch... at (no spam) gmail.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. |
|
|
| Back to top |
|
|
|
|
