Oracle: Checkpoint SCN

All committed changes before a checkpoint SCN are guaranteed to be written to a data file.

Theferore, the checkpoint SCN locates the starting position in the redo stream that needs to be used for instance recovery.

Checkpoint SCNs are recorded in

• data file headers (see data file checkpoint) and
• the control file