The checkpoint identifies the first redo log entry that Oracle will need to process in a recovery situation. All changes related to previous redo log entries have been written to the disk. Checkpoint Process (CKPT): When a checkpoint occurs, Oracle must update the headers of all datafiles to...
Log-based recovery works as follows −The log file is kept on a stable storage media. When a transaction enters the system and starts execution, it writes a log about it.<Tn, Start> When the transaction modifies an item X, it write logs as follows −...