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.
Received on Mon Jun 12 2000 - 03:54:42 CDT
