Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are stored procedures in a database?

954


What is the purpose of database management system?

1047


How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?

994


Define checkpoint.

1019


What are the different type of relationships in the dbms?

873


What does clipper stand for?

1011


Can you explain insert, update and delete query?

1066


Mention the differences between trigger and stored procedures

1162


Can videos be stored in a database?

952


How to recreate the index on a firebird table?

910


Define object-oriented model.

1038


Can we store images in database?

870


What's the difference between 'union' and 'union all' ?

1003


Have you heard about sixth normal form?

1001


What do you mean by transparent dbms?

1422