Re: Recovery scenario
From: Pedro Espinoza <raindoctor_at_gmail.com>
Date: Sun, 3 Feb 2008 12:25:47 -0500
Message-ID: <b86c876f0802030925x4a4205fesf2313b11588524f6@mail.gmail.com>
> The presence of a long-running transaction before, during and after the
> period of a backup would have no bearing on the archivelog requirements for
> the recovery of that backup. Backups consist of data blocks, and capture
> the physical state of the database, without regard to the state of
> transactions. The inclusion of the UNDO_TABLESPACE or rollback segments in
> the backup allows transactions that are incomplete at the time the recovered
> database is opened to be rolled back.
Date: Sun, 3 Feb 2008 12:25:47 -0500
Message-ID: <b86c876f0802030925x4a4205fesf2313b11588524f6@mail.gmail.com>
On Feb 1, 2008 1:28 PM, Jeremiah Wilton <jeremiah_at_ora-600.net> wrote:
>
> The presence of a long-running transaction before, during and after the
> period of a backup would have no bearing on the archivelog requirements for
> the recovery of that backup. Backups consist of data blocks, and capture
> the physical state of the database, without regard to the state of
> transactions. The inclusion of the UNDO_TABLESPACE or rollback segments in
> the backup allows transactions that are incomplete at the time the recovered
> database is opened to be rolled back.
Thanks for this clarification. And yes, my response was incorrect.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 03 2008 - 11:25:47 CST