goelumesh

 Profile Answers by goelumesh 

• Jul 1st, 2008

 

Roll forward refers to the process Oracle goes through to apply changes contained in the redo log files (both online and archive). The database clock (as measured by the system change number) is moved forward within the blocks of the datafile that are changed within the redo log vectors. Roll forward occurs during database, tablespace or datafile recovery and during crash recovery. Rollback is the process of undoing uncommitted database transactions. The blocks copied to the rollback segments during transactions as a copy of the block for other transaction to read. When the instance aborts, the undo information in the redo log files must be applied to the database during the roll forward process of recovery. Therefore, during recovery, the database must roll forward and roll back. Umesh Goel

Madhu_Das

 Profile Answers by Madhu_Das 

• May 21st, 2009

 

Rollforward is to Redo, as Rollback is to undo.