Power Failure

What is the effect on database at the time of total power failure when an UPDATE query is under execution in Oracle 9i?

Questions by prasads_delight1   answers by prasads_delight1

Showing Answers 1 - 6 of 6 Answers

Ram Sangwan

  • Jun 24th, 2009
 

When the power failure occurs while an update statement is running. When the database is restarted it does an automatic recovery, when it finds the update statements pending, it performs a rollback of the update statement.

Regards
-Ram

  Was this answer useful?  Yes

ianilreddy

  • Aug 7th, 2010
 

When database is restarted, SMON will perform instance reecovery
Roll forward commited transactions
Roll back uncommited transactions using undo information.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions