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@xxxxxxxxx> 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

Other related posts: