Wonderful Tarry. Amazing explaination. Thanks for the same.

However, this leaves another Question for me: If redo log contained committed and uncommitted data -- Why did they design such that Oracle Rolls-back after Roll Forward? Why not retain even the uncommitted?? Wouldn't this have been a big advantage during catastrophic instances? Tarry, I would really appreciate if you could shed some light over this.