This answer is restricted. Please login to view the answer of this question.Login Now
The checkpoint in Database Recovery is used to declare a point before which the DBMS was in a consistent state, and all transactions were committed. During transaction execution, such checkpoints are traced. After execution, transaction log files will be created.
Upon reaching the savepoint/checkpoint, the log file is destroyed by saving its update to the database. Then a new log is created with upcoming execution operations of the transaction and it will be updated until the next checkpoint and the process continues.
Database Recovery using Checkpoint:
In the following manner, a recovery system recovers the database from this failure:
All the transactions in the redo-list are deleted with their previous logs and then redone before saving their logs. All the transactions in the undo list are undone and their logs are deleted.
Click here to submit your answer.