Re: Does an ALTER SYSTEM CHKPOINT write all dirty buffers to datafiles ?

From: Bruno Jargot <see_at_reply.to.invalid>
Date: Tue, 15 Jul 2003 10:05:53 +0200
Message-ID: <75d7hv4hrn85d2gen79nfou8rmhve2i2qp@4ax.com>

On 14 Jul 2003 15:42:31 -0700, Joel Garry wrote:
> While nothing besides
>performance is likely to be affected if you are getting "Checkpoint
>not complete" errors, if your system goes down without finishing the
>checkpoint, you've quite possibly set up to lose stuff when instance
>recovery takes place on the next startup.

Do you mean that Oracle will erase contents in redolog even if the checkpoint was not completed ?

I'm convinced that Oracle will wait that the checkpoint is completed (and in the interval, no update will be allowed).

am I wrong ? Received on Tue Jul 15 2003 - 03:05:53 CDT