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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
