Re: corrupt rollback segment

This happened to me once too. That hidden param is a life saver. I found that I could not remove the _corrupted_rollback_segments entry from the init file though, and therefore could not reuse the corrupted rollback segments name again.

Maybe there is something left in the data dictionary that just never allows you to actually remove the init parameter or reuse the name. Try it.
Good luck
- sooz

jimde_at_my-dejanews.com wrote:
>
> A week ago we suffered a corrupted rollback segment and after much
> deliberation brought the database back online using the hidden parameter
> _corrupted_rollback_segments The affected rollback segment was dropped and
> rebuilt, the hidden paremeter removed. The database then had a cold backup and
> restarted. Every evening since a hot backup has been taken. Oracle however say
> the that database is 'corrupted' and should be rebuilt. Can anyone explain if
> this is true and why?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Oct 07 1998 - 23:40:21 CDT