Database recovery techniques from "summary" of Introduction to Database Management Systems: by Kahate, Atul

Database recovery techniques refer to the process of restoring databases to their original state after a system failure or corruption has occurred. It is an important factor for most organizations as data loss can lead to huge losses in terms of both revenue and customer goodwill.

Point-in-Time Recovery is done through restorations from the backups with the help of restore points. Data Verification and Recovery Software works on recovering corrupted data and also on verifying the consistency and accuracy of current records.

Backups ensure that all data stored in the database could be recovered in case something unexpected happened. They come in two forms – full backup and incremental backup. Full back up copies the entire database while incremental only captures changes made since the last backup.

Replication techniques create a copy of the database regularly. This helps recover up to date information in case of any system failures or impairments. Log shipping involves making a complete backup at regular intervals on a separate server and setting up transaction logs replicating the updates between primary and secondary servers.

It is essential to set up automated systems for executing the various stages of the Nominal Database Recovery Protocol (NDRP). These follow a certain sequence including task identification, planning, testing, implementation and evaluation.

Life cycles of backup policy depend on the importance assigned to every database component. Standard policies involve daily backups, weekly archiving and monthly purging of redundant data.