The content is just an excerpt from the complete note for SS3 First Term Data Processing Lesson Note – Crash Recovery. Check below to download the complete DOCUMENT
WEEK FOUR
TOPIC: CRASH RECOVERY
CONTENT:
Sub-topic 1
Crash Recovery: Is the process by which the database is moved back to a consistent and usable state. This is done by rolling back incomplete transactions and completing committed transactions that were still in memory when the crash occurred.
To be able to do this, the DBMS maintains a record, called the Log, of all write to the database.
What is Log?
This is the history of actions executed by the DBMS. Physically, Log is a file of records stored in stable storage, which is assumed to survive crashes.
For recovery purposes, every page in the database contains the LSN of the most recent log record that describe a change to this page. This LSN is called the pageLSN. Every log record is given a unique ID called the Log Sequence Number (LSN).
Introduction to Aries (analysis, redo and undo)
ARIES (Algorithm for Recovery and Isolation Exploiting Semantics) is a recovery algorithm that is designed to work with a steal, no-force approach.
When the recovery manager is invoked after a crash, restart proceeds in three phases:
There three main principles behind the ARIES recovery algorithm:
To gain full access to the note: DOWNLOAD FILE
Do you want to study Agricultural Extension in OOU? Before you apply for the OOU…
Do you want to study Agricultural Economics in OOU? Before you apply for the OOU…
Do you want to study Cooperative and Business Management in OOU? Before you apply for…
Do you want to study Home and Hotel Management in OOU? Before you apply for…
Do you want to study Animal Production in OOU? Before you apply for the OOU…
Do you want to study Crop Production in OOU? Before you apply for the OOU…