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
What are stored procedures in a database?
What is the purpose of database management system?
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
Define checkpoint.
What are the different type of relationships in the dbms?
What does clipper stand for?
Can you explain insert, update and delete query?
Mention the differences between trigger and stored procedures
Can videos be stored in a database?
How to recreate the index on a firebird table?
Define object-oriented model.
Can we store images in database?
What's the difference between 'union' and 'union all' ?
Have you heard about sixth normal form?
What do you mean by transparent dbms?