Re: Futher questions on Rolback Segments

The status is showing up as FULL for many days long. If RBS is taken to offline the status is changed to PENDING OFFLINE. If status is brought back to online, the status is getting changed to FULL. This simply toggles like this for ever.

Could someone explain how to manually clear the rollback segment. There are no pending distributed transactions and shutdown is not possible. No transaction is holding the rollback segment. Also "xacts" column is 0.

Any help is appreciated.

• Janardhana Babu

At 02:07 AM 6/12/00 -0800, A. Bardeen wrote:
>Bill,
>
>A FULL status indicates the RBS has encountered an
>ORA-1562 "failed to extend rollback segment" error.
>It's set to full so that new tx's will not attempt to
>use that rbs. The status of full is cleared when ALL
>active tx's in that rbs have committed or rolled back.
>
>You can also try taking the rbs offline and back
>online to clear the full status, provided sufficient
>tx's have committed or rolled back.
>
>HTH,
>
>-- Anita
>
>--- Bill Wagman <wjwagman_at_ucdavis.edu> wrote:
> > Hello,
> >
> > Thanks to all who responded to my previous request
> > for help with rollback
> > segment difficulties. I have some additional
> > questions.
> >
> > Where can I find information on what it means when a
> > rollback segment has a
> > status FULL and how to empty a FULL rollback
> > segment? If anyone can answer
> > the question I would be most appreciative.
> >
> > Thanks.
> >
> > Bill Wagman
> > Univ. of California at Davis
> > Information Resources
> > wjwagman_at_ucdavis.edu
> > (530) 754-6208
> >
> >
>-----------------------------------------------------------------------------
> > Why is it that when you're driving and looking for
> > an address, you turn
> > down the volume on the radio?
> >
> > --
> > Author: Bill Wagman
> > INET: wjwagman_at_ucdavis.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>--------------------------------------------------------------------
> > 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).
>
>
>__________________________________________________
>Do You Yahoo!?
>Send online invitations with Yahoo! Invites.
>http://invites.yahoo.com
>--
>Author: A. Bardeen
> INET: abardeen1_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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
Received on Tue Jun 13 2000 - 16:00:16 CDT