header datafile and SCN
Hi every body,
The controlfile contains the current SCN and the checkpoint SCN. that is right ?
In my search, I found that every datafile online and in read write mode, contain in his header the scn checkpoint.
But, I think that it contains only the last scn applied to this datafile. that is right?
Without this last scn in the datafile, how oracle know when he is stopped writing to the datafile in case of failure, to recover it ?
Thank in advance for your answers.