how checkpoint works?
453048Jun 30 2010 — edited Jun 30 2010Hi ,
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