What are the steps involved in Instance Recovery ?
Answer Posted / 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 View All Answers
Compare a hierarchical and network database model?
What are stored-procedures? And what are the advantages of using them.
What is string in database?
What is the best free database software?
How rdbms is different from dbms?
What is different keys in dbms?
Explain the necessary techniques to control deadlocks?
What is a degree of relation?
Is google a database?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
What is the best free database?
What is use of dbms?
What are the 4 main objects of a database?
What is the difference between shrink database and shrink file?