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
How to reorder the table columns (fields)?
Which dbms is best?
How can I join two tables in database?
What do you understand by intension and extension?
What do you understand by functional dependency?
What are stored procedures in a database?
How many columns are in a database table?
what are the advantages of using them.
What is the maximum size of an access database?
How do you open .db files?
How to use events with zebedee, ssh or stunnel?
How do you set a primary key?
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
What is distributed queries?
What is the use case where we can use stretch database?