Re: corrupt rollback segment

The big problem with the _corrupted_rollback_segments parameter is that any partial transactions that used the rollback segment will be commited to the database as complete (rollbacks are NOT done for the affected rollback segment). This can cause data integrity problems depending on how the database was designed. This is why oracle recommends rebuilding the database after using the parameter.

If you know whick tables had active transactions in the rollback segment then you can examine the data to make sure that you find and remove "incomplete" transactions.

Chris Sutter
BJC Health System

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 Mon Oct 12 1998 - 17:34:24 CDT