HOT Back up

  • From: Nirmal Kumar M <gm_nirmal@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 30 Sep 2004 01:31:55 -0700 (PDT)


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

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!

Other related posts: