What are the steps involved in Instance Recovery in Oracle?
Submitted by: AdministratorRolling 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Oracle DBA Job Interview Questions And Answers
Top Oracle DBA Questions
☺ | What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other? |
☺ | When using Oracle export/import what character set concerns might come up? How do you handle them? |
☺ | Explain FORCE LOGGING feature in 9i. |
☺ | Name three SQL operations that perform a SORT. |
☺ | What is the difference between RAID 5 and RAID 10? Which is better for Oracle? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |