IN ORACLE MILIEU …

Recovery Fundamentals: This post is to give you information about various recovery fundamental details and how recovery works. We will start by looking at various SCNs and where they are stored. There are 3 SCNs basically in control file Checkpoint SCN Stop SCN Thread checkpoint SCN Checkpoint SCN is the datafile checkpoint SCN when checkpoint [...]