Chapter 8 · Watch, then practise
Crash Recovery
Explain why the recovery log must reach durable storage before the changed data pages and how replay restores missing updates.
3 questions · 3 with related videos. Matches are based on playlist titles; broader background matches are labeled.
What to study
- Write-ahead logging
- Durable commit records
- REDO recovery
- Backup and log replay
Chapter playlists
Choose a playlist
Notes
Redo, Undo and WAL logs | The Backend Engineering Show
Hussein Nasser · 40:41
Choose a video · 2 lectures
The supplementary WAL lecture and chapter log-recovery lesson cover the logging mechanism behind the write-ahead rule.
1. Write-ahead rule
What must happen before a modified data page is written?
The log records describing its changes must already be on durable storage. If the machine then crashes, recovery has the information needed to reconstruct changes. Writing the page first could leave an on-disk change without the corresponding recovery record.
Redo, Undo and WAL logs | The Backend Engineering Show
Hussein Nasser · 40:41
Redo and WAL are the relevant mechanisms for recovering durable changes before every modified data page is flushed.
2. Commit without flushing every page
How can a transaction be durable while some updated pages remain in memory?
The required WAL records can be flushed at commit while data pages are written later. After a crash, REDO reapplies logged changes missing from the files. Sequential log writes also allow multiple transactions to share a flush, reducing scattered writes.
Log Based Database Recovery in Hindi | DBMS lectures for Beginners in Hindi
Last moment tuitions · 8:37 · Background lecture
Choose a video · 2 lectures
Log-based recovery and WAL provide the recovery background; these titles do not verify a physical-backup restoration walkthrough.
3. Recovery is more than a backup
Why retain WAL after taking a physical backup?
A backup records an earlier database state. Replaying a continuous sequence of subsequent WAL records advances it toward a chosen recovery point. A missing required segment breaks that recovery chain, so a backup alone cannot recover every transaction committed afterward.