Re: Rollback segment datafile is corrupted

Peter,

     Using the undocumented init.ora parameters   _corrupted_rollback_segments
and
_offline_rollback_segments

(both followed by a list of roillback segments, like rollback_segments) should help you to get rid of unwanted rollback segments. IMHO specifying the first parameter should be enough to allow you to drop the rollback segments (and then the tablespace). If I am wrong, specify the second one as well.

Regards,

Stephane Faroult
Oriole Corporation

Peter Lee wrote:

> All:
>
> I have a database (Oracle 7.3.4) on NT. My datafile on the Rollback
> segment tablespace is corrupted. The database is running on archive log
> mode. Unfortunately, the backup on the database is bad.
>
> I went into svrmgr23. I did the following:
>
> svrmgr23>shutdown abort;
>
> svrmgr23>startup mount;
> svrmgr23>select * from v$datafile;
>
> I notice that the datafile is in recovery mode.
>
> svrmgr23>alter database datafile 'xxxx' offline;
> statement processed.
>
> svrmgr23>alter database open;
>
> It complained about my rollback datafile and the database won't open.
>
> I repeat the above steps but this time I commented out the
> rollback_segments= in the init<sid>.ora
>
> I was able to open the database. I did an alter database datafile 'xxxxx'
> offline drop; The system won't let me drop the datafile; All my rollback
> segments are in the recovery state. I cannot alter rollback segments xxxx
> offline or can I drop the rollback segments.
>
> I can create a new tablespace and created new rollback segments against the
> this new tablespace. I modify the rollback_segments parameter to point to
> the new rollback segments. I was able to shutdown and restart the Oracle
> database running on the new rollback segs and the new rollback tablespace
> and datafiles.
>
> How do I get rid of the old rollback segments, old rollback segments
> tablespace and old rollback segment datafile? Is there a way to recover if
> your rollback segment datafile becomes corrupted?
>
> Thank you in advance for your help.
>
> Pete
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
Received on Sat Jan 06 2001 - 13:25:08 CST