checkpoint

[d.goddess]

wats the difference between an incremental and a normal checkpoint?

[pando]

http://www.jlcomp.demon.co.uk/faq/log_checkpoint.html

http://metalink.oracle.com/metalink/...&p_id=270571.1

[dhar_kiran]

wats the difference between an incremental and a normal checkpoint?

By Normal checkpoint if you mean Full checkpoint, then it occurs at shutdown, this checkpoint writes all the dirty buffers from database buffer cache to datafiles and instruct log writter (logwr) to write checkpoint information to all the datafiles and controlfiles.
Incremental checkpoint occurs if fast_start_mttr_target is set. it writes dirty buffers from the last incremental checkpoint or full checkpoint to the time specified specified by fast_start_mttr_target. this parameter minimizes the time taken for instance recovery.

[wole]

I think by normal checkpiont which is full checkpoint anyway, its the checkpoint that notify the log writer (logwr) to write dirty buffers to datafile while the checkpoint update the controfile and the header of datafile with the information and not the other way round as dhar_kiran had said.

[dhar_kiran]

I think by normal checkpiont which is full checkpoint anyway, its the checkpoint that notify the log writer (logwr) to write dirty buffers to datafile while the checkpoint write the information to the controfile and the header of datafile. not the other way round as dhar_kiran had said.

the function of logwr is not to write dirty buffers as it is the job of dbwr, logwr writes from redo log buffer to redolog files and when checkpoint happens it writes checkpoint information to controlfile.