What are the steps involved in Instance Recovery

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

139. What are the steps involved in Instance Recovery?

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.

(Continued on next question...)

Other Job Interview Questions

• What are the various methods of performing a calculation in a report?
• What is a deadlock?
• Explain the difference between a hot backup and a cold backup and the benefits associated with each.
• Explain the read, write, and execute permissions on a UNIX directory.
• You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
• What is the maximum no of chars the parameter can store?
• You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
• What is the use of break group?
• What are the trigger associated with image items?
• What are the default extensions of the files created by library module?
• More...