Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

CHAPTER 13: Database Recovery System > 13.5 RECOVERY TECHNIQUES

13.5 RECOVERY TECHNIQUES

Database recovery techniques used by DBMS depend on the type and extent of damage that has occurred to the database. These techniques are based on the atomic transaction property. All portions of transactions must be treated as a single logical unit of work, in which all operations must be applied and completed to produce a consistent database. The following two types of damages can take place to the database:

  1. Physical damage: If the database has been physically damaged, for example disk crash has occurred, then the last backup copy of the database is restored and update operations of committed transactions are reapplied using the transaction log file. It is to be noted that the restoration in this case is possible only if the transaction log has not been damaged.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint