Series: Subject: Topic:
Question: 123 of 492


What is the rollforward in pl/sql
Asked by: kondla | Member Since Jun-2008 | Asked on: Jun 30th, 2008

View all questions by kondla

Showing Answers 1 - 2 of 2 Answers

Answered On : Jul 1st, 2008

View all answers by goelumesh

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

Yes  1 User has rated as useful.
Login to rate this answer.

Answered On : May 21st, 2009

View all answers by Madhu_Das

Rollforward is to Redo, as Rollback is to undo.

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.