Purpose of roll forward and roll backward

What are rolling forward and rolling backward in backup and recovery?

What is roll forward and backward in backup and recovery?

Databases handle transactions. That is their primary purpose in life. In some situations, it may be necessary to undo, or reverse the effects of a transaction. This is called "rolling back." When recovering a database, it may be necessary to redo, or replay the effects of a transaction. This is called "rolling forward."

Let's say that you took a backup of your database at noon on Monday. At noon on Wednesday, the disk device holding your database completely dies. Once you have a new disk unit, you can restore the contents of your database to that disk device. But when you restore, the database only holds those transactions that were completed since that Monday at noon (when you took the backup). If you have archived your online redo logs, then you can use these archived redo logs to roll forward all transactions completed in the 48 hours between your backup and your database crash. This is the recovery process, or the process of rolling forward.

Unfortunately, when the disk device died, there were active transactions that did not complete. In order to complete the recovery process after rolling forward, the database needs to rollback those transactions that did not commit.

Dig Deeper on Oracle database administration

Data Management
Business Analytics
  • Why WebAssembly? Top 11 Wasm benefits

    Latency and lag time plague web applications that run JavaScript in the browser. Here are 11 reasons why WebAssembly has the ...

  • Why Java in 2023?

    Has there ever been a better time to be a Java programmer? From new Spring releases to active JUGs, the Java platform is ...

  • How developers can avoid remote work scams

    Software developers can find good remote programming jobs, but some job offers are too good to be true. Follow these tips to spot...

Data Center
Content Management