I have an old 8.1.7 Oracle database that had disk corruption on a rollback segment datafile due to a bad block on the HP-UX disk. I have replaced the disk and all the datafiles (except the corrupt rbs datafile - only had part of the file). I was unable to take the RBS segments offline and drop them before the disk replacement due them being set at "NEEDS RECOVERY" . I have tried everything and am open to starting over with RBS segments if needed. I don't care about the small data loss in them.
I had to comment out the rollback_segment init parameter to get the database to open.
SEGMENT_NAME OWNER TABLESPACE_NAME STATUS
------------------------------ ------ ------------------------------ -----------
-----
RBS01 SYS RBS NEEDS RECOVERY
RBS02 SYS RBS NEEDS RECOVERY
RBS03 SYS RBS NEEDS RECOVERY
RBS04 SYS RBS NEEDS RECOVERY
RBS05 SYS RBS NEEDS RECOVERY
RBS06 SYS RBS NEEDS RECOVERY
RBS07 SYS RBS NEEDS RECOVERY
RBS08 SYS RBS NEEDS RECOVERY
RBS09 SYS RBS NEEDS RECOVERY
RBSBIG SYS RBS NEEDS RECOVERY
SYSTEM SYS SYSTEM ONLINE
SYSTEM_RBS SYS SYSTEM OFFLINE
****
A few of the things I have tried are:
SVRMGR> alter database datafile '/db01/HMM/rbs_01.dbf' offline drop;
Statement processed.
SVRMGR> alter database open;
Statement processed.
SVRMGR> alter rollback segment rbs01 offline;
ORA-01598: rollback segment 'RBS01' is not online;
SVRMGR> drop rollback segment rbs01;
ORA-01545: rollback segment 'RBS01' specified not available
*****
SVRMGR> alter database create datafile '/db01/HMM/rbs_01.dbf' as '/db01/HMM/rbs_
01.dbf' size 300M reuse;
alter database create datafile '/db01/HMM/rbs_01.dbf' as '/db01/HMM/rbs_01.dbf'
size 300M reuse
*
ORA-01181: file 5 created before last RESETLOGS, cannot recreate
ORA-01110: data file 5: '/db01/HMM/rbs_01.dbf'
SVRMGR>
****
EVEN IF I TRY TO CREATE A NEW TS, I GET THE FOLLOWING:
SVRMGR> CREATE TABLESPACE RBS1
2> DATAFILE '/db01/HMM/rbs_backup_01.dbf' SIZE 100M
3> DEFAULT STORAGE (INITIAL 50K NEXT 50K PCTINCREASE 1)
4> ONLINE;
CREATE TABLESPACE RBS1
*
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '/db01/HMM/rbs_01.dbf'
***
Any thoughts would be much appreciated!!!