Re: Recovery scenario
- From: "Pedro Espinoza" <raindoctor@xxxxxxxxx>
- To: jeremiah@xxxxxxxxxxx
- Date: Sun, 3 Feb 2008 12:25:47 -0500
On Feb 1, 2008 1:28 PM, Jeremiah Wilton <jeremiah@xxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
