Re: HELP - Rollback segment NEEDS RECOVERY

Dave Opdycke <pme_at_crash.cts.com> writes:
|> Don't know much about your situation, but depending on the data that you
|> may lose, another option is:
|>
|> Set the init.ora parameter
|> _corrupted_rollback_segments=rollback_segment_that_is_bad
|>
|> Start the instance, then export, re-create and re-import. The reason
|> that you need to do this is that the rollback segments may contain info
|> from the system tables that can bite you in the (*) later (or sooner) on.
|> ORACLE will also not help you through other problems unless you rebuild
|> the database, if you have used this init.ora parameter...
|>
|> Then again, depending on the amount of data...recovery may be better!
|>
|> DPO
|>

In general, that should only be done as a last resort where no other backups are available (mainly for the reason Dave stated - it leads to potentially hazy user and data dictionary information - leading to a full rebuild and integrity checking of data).

Support may have some better "tricks" to try first depending on the full situation.

Roderick Manalac
Oracle Corporation
DISCLAIMER: Insert standard disclaimer here. Received on Sat May 27 1995 - 00:00:00 CEST