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
How do I check my drivers?
Why do we use databases?
Explain what are called fat clients and fat servers?
Does netlib support windows 95?
Explain the term entity set in dbms?
How to handle data if f table are more than one and each table contain thousands of entries?
Which database server is best?
Define database lock?
What is 1nf 2nf 3nf in dbms?
What is the best database to use?
Tell me about view, sequence and index in DBMS.
Mention the differences between trigger and stored procedures
Define database lock and its types.
What is normalization in database with example?
What are queries in dbms?