Re: why does oracle recovery redo before undo?
- From: Mladen Gogala <mgogala@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 Apr 2004 18:09:54 -0400
On 04/19/2004 05:28:27 PM, Ryan wrote:
> Now my book says the optimal way to do this is to check for all open
> transactions at the time of the last checkpoint that have committed after
> that checkpoint.
>
> Anyone know more? In particularly know 'why'?
It's elementary, my dear Ryan. Oracle has first to recover transactions
to roll them back. If the changes recorded in the undo blocks are not
applied to the database, how do you propose to roll them back?
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
