Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What are the steps involved in Instance Recovery ?

What are the steps involved in Instance Recovery ?..

Answer / 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

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Database Management Interview Questions

What do databases contain?

0 Answers  

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

0 Answers   Indian Web Technology,

How to monitor firebird server activity?

0 Answers  

What is database bloat?

0 Answers  

For each user who needs access, the DBA creates an account in which database?

0 Answers  

How many types of users in dbms?

0 Answers  

How rdbms is different from dbms?

0 Answers  

Describe the types of keys?

0 Answers  

Which free database is best?

0 Answers  

What is the use of INDEXES option in IMP command ?

2 Answers  

What is a database in computer?

0 Answers  

What is hot backup and how it can be taken ?

1 Answers