Re: HOT Back up

Nirmal,

This has been debated to Death in the dba_gurus Yahoo Group.

But it is anyways time that you went and read the Concepts Guide .and the backup and Recovery Guide.

Cheers
Ganesh R

On Thu, 30 Sep 2004 01:31:55 -0700 (PDT), Nirmal Kumar M <gm_nirmal_at_yahoo.com> wrote:
> HI,
>
> Suppose u have 300 GB database with 3 Redo log groups
> having each 100 MB of redo log files.
>
> Now u have started taking HOTBACKUP, by putting a
> tablespace in backup mode.
>
> When backup is going on , same time big transactions
> are also going on and suppose a transaction fills 300
> MB of redolog buffers.
>
> as per Oracle conecpts, LGWR will write to redo log
> files. Suppose it has written 100MB of Redo buffer to
> 1st log file and on LOG Switch it starts writing to
> 2nd LOG file and archive the 1st LOG file and on
> another log switch it starts writing on 3rd log file
> and archive the 2nd log file.
>
> Kindly note, the same transaction(which fills 300MB of
> redo buffers) is still running(means not completed).
>
> and now, I rollback the transaction.
>
> 1. What will happen.
>
> 2. What will happen to that data which has been
> archived.
>
> One DBA said the whole transaction will be
> rollbacked, when
> we issue ROLLBACK command.
>
> 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.??
>
> =====
> Best Regards,
> Nirmalkumar Muthukumaran.
>
>
> _______________________________
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l