Database recovery can be a very complex task that is prone t

Database recovery can be a very complex task that is prone to errors and difficult to manage. What are some steps to consider before initiating the recovery after a failure?

Solution

Database recovery can be a very complex task that is prone to errors and difficult to manage.
What are some steps to consider before initiating the recovery after a failure?

After a crash happens for the database, to initiate a recovery,
the database should check the state of transactions being processed during i.e., at the time
of crash.
The DBMS must ensure atomicity, i.e., the transactions that are committed, which don\'t need
to be handled by any means, and the transactions which are not committed, i.e., which need
a rollback i.e., the transactions which may lead the database to inconsistent state.
The recovery system, reads the log files from the most recent transactions back to a checkpoint
so that, it identifies the transactions that are inconsistent.