Re: Instance Recovery
Originally posted by ramuganapathi
2. user is modifiying the data and issues commit.
3. changes gets logged into redo log file.
4. after some interval, chkpt occurs - the LGWR pushes the data from the redo buffer to redo data file.
A commit will not return control (e.g. to the next instruction) until all the redo data for the transaction has been physically written to the redo log file(s) - the check point does NOT do that.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman