Re: Recovery scenario

From: Pedro Espinoza <>
Date: Sun, 3 Feb 2008 12:25:47 -0500
Message-ID: <>

On Feb 1, 2008 1:28 PM, Jeremiah Wilton <> 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.

Received on Sun Feb 03 2008 - 11:25:47 CST

Original text of this message