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 |
What is dbms with example?
What do you mean by transparent dbms?
What is a sequence in a database?
Mention a query to calculate the even and odd records from a table
Define primary and unique key?
Explain dml (data manipulation language)?
What is the difference between a database and a spreadsheet?
Which database is used by google?
What is a database in healthcare?
Mention the different types of cursor?
What is foreign key in dbms?
What are the advantages and disadvantages of views in the database?