What are the steps involved in Instance Recovery ?
- 1 Answers
- 6273 Views
- ibcs primax, I also Faced
- E-Mail Answers
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
What is meant by system analysis?
What are the key constraints in dbms?
How to select the first record in a given set of rows?
How do I create a database in open office?
In which format image is stored in database?
What is a key in dbms?
What's the best database software for mac?
Why is rdbms important?
What's the difference between delete and truncate ?
What is the purpose of using a model?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What are the drawback of rdbms?
What is cold backup (in case of oracle)?
What is normalization and what are the different types of normalization?
What is the best free database software?
