We have an Oracle Instance in which all the rollback segments are part of a tablespace that has one datafile.
Unfortunately, the datafile is corrupted. we dropped the datafile using 'alter database datafile 'sdsd' offline drop; ' which got corrupted. deleted the datafile restarted the database. when we try create the new tablespace, it gives an error ora-376 cannot read at this time.
when we try to drop the rollback segment tablespace using the command drop tablespace rollback_data including contents. it gives an error message. it contains active rollback segments. the status of the rollback segments are needs recovery.
we want to drop the tablespace recreate the tablespace and rollbacksegments. how do we go about doing this ?