The most common way that I know of to get a corrupted rollback segment
is to kill oracle processes or to shutdown abort. If you do a time based
reconery to just befor this event you can recover the database. Any
further forward will reintroduce the corruption.
If you analyse the trace files you can find out where the corruption
occurred. If it is a table or pref index you may be able to drop these
and then recover fully.
andres wrote:
>
> Hello all,
>
> Could I recover a database that had a block corruption in the file that
> serves as the tablespace for rollback segments
> I am trying to create a new segment for rollbacks but the server hangs
> for minutes apparently without doing anything at all.
> Thanks and regards,
> andres
Received on Tue Oct 19 1999 - 00:20:42 CDT
