IT Questions and Answers :)

Thursday, August 8, 2019

If you experience a system failure, what’s the best way to recover your database?

If you experience a system failure, what’s the best way to recover your database?

  • Rollback
  • Switch to duplicate database
  • Rollforward
  • Reprocess transactions 
If you experience a system failure, what’s the best way to recover your database?

EXPLANATION



 1.
Recovery is needed when a database instance that has failed is restarted or a surviving database instance takes over a failed one. In roll-backward recovery, the active transactions at the time of failure are aborted and the resourced allocated for those transactions are released. In roll-forward recovery, the updates recorded in the redo log are transferred to the database so that they are not lost.


2.
Recovery is needed when a database instance that has failed is restarted or a surviving database instance takes over a failed one. In roll-backward recovery, the active transactions at the time of failure are aborted and the resourced allocated for those transactions are released. In roll-forward recovery, the updates recorded in the redo log are transferred to the database so that they are not lost.
3.
Recovery is needed when a database instance that has failed is restarted or a surviving database instance takes over a failed one. In roll-backward recovery, the active transactions at the time of failure are aborted and the resourced allocated for those transactions are released. In roll-forward recovery, the updates recorded in the redo log are transferred to the database so that they are not lost. 
Share:

0 comments:

Post a Comment

Popular Posts