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 is the purpose of database?

0 Answers  


Define union all operator and union.

0 Answers  


hello to all i want code for like this site "Submit Question" page.please give answers thanks.

0 Answers  


What is a RADIO GROUP ?

1 Answers  


What is database connection pool size?

0 Answers  






What is the full meaning of dbms?

0 Answers  


Is this statement true or false? All databases must be in third normal form?

0 Answers  


What is Log Switch ?

2 Answers  


What are procedures in dbms?

0 Answers  


How does a database partition work?

0 Answers  


What is Full Backup ?

3 Answers  


If I use netlib, will I find many other users to network with?

0 Answers  


Categories