Diffecnr in rollfoewards and rollback?

Difference in rollfoewards and rollback?

..

. Where exactly DML commands will fall into ?? Buffer Cache or to Redo Log Buffer ? ...

both of course, you make changes to blocks (that is in the buffer cache) and those changes are protected by redo which is generated into the redo log buffer and then flushed to disk...

we use undo to rollback uncommitted transactions. During a recovery - you roll forward with the redo (archive+online for media recovery, online only for instance recovery following a 'crash') and then we roll back any outstanding, uncommitted transactions using UNDO.