I've had a couple rollback segments lately that are showing up as corrupt (they are marked "needs recovery") that I wasn't able to fix also. The only thing that you can do is drop the rollback segment and recreate it.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.