What Is Instance Recovery?


3 Answers

Anonymous Profile
Anonymous answered
When an Oracle instance fails,Oracle performs an instance recovery when the associated database is re-started.
Instance recovery occurs in two steps:

Cache recovery: Changes being made to a database are recorded in
the database buffer cache. These changes are also recorded in online redo log
files simultaneously. When there are enough data in the database buffer cache,
they are written to data files. If an Oracle instance fails before the data in
the database buffer cache are written to data files, Oracle uses the data
recorded in the online redo log files to recover the lost data when the
associated database is re-started. This process is called cache recovery.

Transaction recovery: When a transaction modifies data in a
database, the before image of the modified data is stored in an undo segment.
The data stored in the undo segment is used to restore the original values in
case a transaction is rolled back. At the time of an instance failure, the
database may have uncommitted transactions. It is possible that changes made by
these uncommitted transactions have gotten saved in data files. To maintain
read consistency, Oracle rolls back all uncommitted transactions when the
associated database is re-started. Oracle uses the undo data stored in undo
segments to accomplish this. This process is called transaction recovery.

thanked the writer.
Anonymous commented
Cache Recovery (Rolling Forward)During the cache recovery step,
Oracle applies all committed and uncommitted changes in the redo log files to
the affected data blocks. The work required for cache recovery processing is
proportional to the rate of change to the database (update transactions each
second) and the time between checkpoints.
Anonymous commented
Transaction Recovery (Rolling Back)To make the database consistent,
the changes that were not committed at the time of the crash must be undone (in
other words, rolled back). During the transaction recovery step, Oracle applies
the rollback segments to undo the uncommitted changes.
William Enders Profile
William Enders answered
There are a lot of things covered in data recovery and many are offering data recovery services. However, one among the many is the Instance Recovery.

It is a process of applying records in the online redo log to data files which reconstruct changes made after the most recent checkpoint. It is automatically restarted when in cases of instance failure or shutdown of the database (Abort option or Shutdown about).
Anonymous Profile
Anonymous answered
When the  Instance  recovery we get only the committed data. We are not able to get the upcommitting data at the time of instance recovery.

Answer Question