Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.

2. Searching for something specific? See our text overview of all tests. Scroll right for levels, and lists.

3. Student and Teacher User Guides |  Schemes of Work |   Real Teacher use Videos |


Join 30000+ teachers and students using TTIO.

Database Recovery Methods

Database recovery is the process of restoring the database to a correct (consistent) state in the event of a failure. In other words, it is the process of restoring the database to the most recent consistent state that existed shortly before the time of system failure.

Suggested Video

Additional Information

There are two major techniques for recovery from non-catastrophic transaction failures: deferred updates and immediate updates. Immediate update – In the immediate update, the database may be updated by some operations of a transaction before the transaction reaches its commit point.

A major responsibility of the database administrator is to prepare for the possibility of hardware, software, network, process, or system failure. If such a failure affects the operation of a database system, you must usually recover the database and return to normal operation as quickly as possible.

Additional Reading

https://docs.oracle.com/cd/A87860_01/doc/server.817/a76965/c28recov.htm

www.teachyourselfpython.com