Re: HOT Back up

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 30 Sep 2004 10:40:28 -0700
Message-ID: <bf4638040930104050564b7b@mail.gmail.com>

On Thu, 30 Sep 2004 01:31:55 -0700 (PDT), Nirmal Kumar M <gm_nirmal_at_yahoo.com> wrote:
>
> 3. But here the question is how the data which has
> been archived, how that can be rollbacked and how that
> can be removed from Archived files.??
>
> =====

Please read the concepts manual section on both Rollback Segments/UNDO, and on REDO and Archive logs.

I suspect you have a backgound in Sybase or SQL server, both of which use the redo data for both redo and undo.

Oracle has no such limitation. :)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 30 2004 - 12:36:05 CDT