Re: Rollback datafile size

Mike,

When an RBS is taken offline, the undo information is not transfered to another segment, hence the need to perform these actions at a quiet time. When an rbs is taken offline, all transactions currently using the rbs are allowed to complete (either commit or rollback). As these transactions are processing, the status of the segment is 'Pending Offline'. Once the tx is complete, the status will change to 'Offline'. If a query is running and needs undo entries from an offline (including pending) rbs, it will fail with a 1555.

Daniel

Michael Milligan wrote:

> Daniel,
>
> Thank-you very much for your clear answer. Very helpful. When a RBS is taken
> off-line, does it transfer the rollback information to another segment?
>
> Thanks,
>
> Mike

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).