HOT Back up

From: Nirmal Kumar M <gm_nirmal_at_yahoo.com>
Date: Thu, 30 Sep 2004 01:31:55 -0700 (PDT)
Message-ID: <20040930083155.85498.qmail@web41722.mail.yahoo.com>

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.

What will happen.
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

Received on Thu Sep 30 2004 - 03:27:26 CDT