Re: switch logfile, checkpoint, active and inactive logfile
Date: 24 Apr 2003 12:31:04 -0700
Message-ID: <55dd405a.0304241131.7832ca24_at_posting.google.com>
>
> returns control to you after the logfile is switched, which does not
> necessarily mean that it will complete the checkpoint by then. It is quite
> possible that the checkpoint completes some time after the switch or perhaps
> does not complete at all.
According to Oracle8i Concepts:
may not be finished. So now when the headers of control files and datafiles
are updated? after DBWn have done job or checkpoint is initiated?
2) If LGWR jumps to the next logfile (now becomes current) without waiting for
Checkpoint to be done, the checkpoint for instance recovery is in the
current logfile, or previous, but still active logfile?
3) Instance recovery roll forward to the latest checkpoint, so when this point
of check point is marked? in the begining of checkpoint or the end?
Thanks for the reply. Until this point (not checkpoint) I feel the
difficulty
of Oracle.
Received on Thu Apr 24 2003 - 21:31:04 CEST