What are the steps involved in Instance Recovery ?

Question Posted / guest

1 Answers
7296 Views
ibcs primax, I also Faced
E-Mail Answers

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
failure.

Is This Answer Correct ?

4 Yes

4 No

Post New Answer

More Database Management Interview Questions

What are the advantages of database software?

0 Answers

What is the difference between primary key and secondary key?

0 Answers Axtria, ITC Indian Tobacco Company,

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

2 Answers 3i Infotech,

What are codd rules?

0 Answers

what is s/w lifecycle?

1 Answers IBM,

How to pump the data from one database to another?

0 Answers

What is join? Mention its types.

0 Answers

How do I keep my database up to date?

0 Answers

How can you perform pattern matching in sql?