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 you mean by cardinality and its types?

0 Answers  


What are different types of data models?

0 Answers  


Is the internet a database?

0 Answers  


What are the three main types of models?

0 Answers  


What is management system in dbms?

0 Answers  






Does google have a database program?

0 Answers  


What are the features of a database management system?

0 Answers  


What are the limitations of database?

0 Answers  


What are the types of database management system?

0 Answers  


What is primary key in database?

0 Answers  


What is database in simple language?

0 Answers  


dear sir please provide what question will be asked in CWE in bank it officer

0 Answers  


Categories