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
What do you mean by buffer manager?
What is drivermanager getconnection?
what is scan listener.
What are the components of a database management system?
Is there a database program for mac?
Explain the different types of database keys?
Define checkpoint.
What is tuple in rdbms?
Is declare cursor executable?
describe middleware applications that ease the connection of databases to web?
Define cursor.
What is a distributed database system?
Enlist the types of cursor?
explain about the critical recovery scenario you had experienced
Should database table names be capitalized?