Re: rollback segment "NEEDS RECOVERY"

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 17 Sep 1999 13:21:47 GMT
Message-ID: <19990917092147.03935.00000007@ngol08.aol.com>

/*
Dropping Rollback Segments with "needs recovery" Status */

If you have rollback segments with 'needs recovery' status you can not easily drop them
without doing some additional work.
For example: suppose you have two rollback segments rb01 and rb02, and rb02's status is 'needs recovery.'
First, add the following lines to your init.ora: Now shut down the database and restart it with the modified init.ora. You will be able now to drop the rb02 rollback segment (the status still shows as 'needs recovery').
Once you've done this, you can then re-create the rb02 rollback segment.

rollback segments = (rb01)
_offline_rollback_segments = (rb02)

Paul in VT Received on Fri Sep 17 1999 - 08:21:47 CDT