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
Is driver a software?
Write about Transaction Management in Oracle 9i?
Operators used in select statements are?
Explain primary key and composite key.
when All datafiles related to a Tablespace are removed ?
How to start and stop database control?
What are vdl and sdl?
What is package in dbms?
What is the importance of query in database?
What are the features of rdbms?
What is the best way to determine whether firebird server is running?
Why c++ used in clipper?
How to extract metadata for the entire database?
Which is best database?
What is the concept of sub-query in terms of sql?