Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how checkpoint works?

453048Jun 30 2010 — edited Jun 30 2010
Hi ,

Following description in Concepts.pdf:

When a checkpoint occurs, Oracle must update the headers of all datafiles to record the details of the checkpoint. This is done by the CKPT process. The CKPT process does not write blocks to disk; DBWn always performs that work.

my questions is :

is there a order when update datafile and controlfile ? some records must be write to files on disk must be before write to other files on disk ?

for example, when a chechpoint starts, oracle will first update datafile on disk to record the details of the checkpoint , and only when datafile update finished, controlfile will be updated. it never happened in reverse order, that is first controlfile then datafile.

Regards & Thanks.

-Hua
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2010
Added on Jun 30 2010
12 comments
2,354 views