delete rollback segment

[Hisao]

Hi!

I use oracle8i for linux

I delete rollback segment's file by mistake.
(with rm command)

and I couldn't open DB.

That's DB message.

ORACLE instance started.
Total System Global Area 4754704 bytes
Fixed Size 48400 bytes
Variable Size 4222976 bytes
Database Buffers 409600 bytes
Redo Buffers 73728 bytes
Database mounted.
ORA-01545: rollback segment 'R01' specified not available
ORA-01109: database not open

And I edited init.ora

# rollback_segments = (r01,r02,r03,r04)

and tried to startup DB.
but error was occured.

ORACLE instance started.
Total System Global Area 4754704 bytes
Fixed Size 48400 bytes
Variable Size 4222976 bytes
Database Buffers 409600 bytes
Redo Buffers 73728 bytes
Database mounted.
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/u02/oradata/COMMONDB/rbs01.dbf'

How can I open DB?

[pando]

Backup your database first before do this, since it´s RBS that is missing this can be tricky if you dont have a backup


startup mount

alter database datafile '/u02/oradata/COMMONDB/rbs01.dbf' offline drop

alter database open

drop tablespace rbs

then rcreate your rbs tablespace

IF, when you deleted the rbs tablespace datafile there were active transactions going then this process would be different and it´s tricky

[SANJAY_G]

Nothing to worry since it is RB segment datafile only.
Do the following..

1. Shutdown the database.
2. edit the init.ora file and comment the parameter rollbak_segments.
3. go to server manager.
4. connect internal
5. startup mount
6. alter database datafile '/u02/oradata/COMMONDB/rbs01.dbf' offline drop;
7. alter database open;
8. create the rollback tablespace with new datafile.
9. bring back the rollback segmetns online or drop and create the rollback segments.
10. put back the entries for the created rollback segments in init.ora.

Good luck...
Sanjay

[Hisao]

Thanks Pando and SANJAY_G for replying.

I did following your comment.
But I couldn't open database.

So I try to write init.ora following statement,

_corrupted_rollback_segments=(r01,r02,r03,r04)

and I can open database.

I recreate RBS, and I can recover database.

Thanks.