Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are the steps involved in Instance Recovery ?



What are the steps involved in Instance Recovery ?..

Answer / guest

Rolling forward to recover data that has not been recorded
in data files, yet has been recorded in the on-line redo
log, including the contents of rollback segments.

Rolling back transactions that have been explicitly rolled
back or have not been committed as indicated by the rollback
segments regenerated in step a.
Releasing any resources (locks) held by transactions in
process at the time of the failure.

Resolving any pending distributed transactions
undergoing a two-phase commit at the time of the instance
failure.

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Database Management Interview Questions

What do databases contain?

0 Answers  


what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

0 Answers   Indian Web Technology,


How to monitor firebird server activity?

0 Answers  


What is database bloat?

0 Answers  


For each user who needs access, the DBA creates an account in which database?

0 Answers  






How many types of users in dbms?

0 Answers  


How rdbms is different from dbms?

0 Answers  


Describe the types of keys?

0 Answers  


Which free database is best?

0 Answers  


What is the use of INDEXES option in IMP command ?

2 Answers  


What is a database in computer?

0 Answers  


What is hot backup and how it can be taken ?

1 Answers  






Categories