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


Please Help Members By Posting Answers For Below Questions

What do you mean by buffer manager?

513


What is drivermanager getconnection?

598


what is scan listener.

1796


What are the components of a database management system?

446


Is there a database program for mac?

450






Explain the different types of database keys?

526


Define checkpoint.

513


What is tuple in rdbms?

568


Is declare cursor executable?

521


describe middleware applications that ease the connection of databases to web?

491


Define cursor.

559


What is a distributed database system?

509


Enlist the types of cursor?

552


explain about the critical recovery scenario you had experienced

1639


Should database table names be capitalized?

537