Rollback segment datafile is corrupted

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. Received on Sat Jan 06 2001 - 08:13:04 CST