that is what i thought. I have a generic database book that is used at most
universities that says its optimal to apply undo before redo. trying to
figure out where it is coming from.
----- Original Message -----
From: "Mladen Gogala" <mgogala_at_adelphia.net>
To: <oracle-l_at_freelists.org>
Sent: Monday, April 19, 2004 6:09 PM
Subject: Re: why does oracle recovery redo before undo?
>
> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Apr 19 2004 - 17:37:06 CDT
