Cannot recover drop/re-initilialise undo tablespace: cannot open database
407013Aug 25 2004 — edited Jan 11 2010Hi
I have an Oracle test database which I found unable to open, because my undo log somehow got corrupted.
In my alert file I get the following error when I try to open the database:
Errors in file C:\oracle\admin\TESTGEA\udump\ORA29760.TRC:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'C:\ORACLE\ORADATA\TESTGEA\UNDOTBS01.DBF'
...
Error 376 happened during db open, shutting down database
The log file ORA29760.TRC has very little information, it simply says:
KCRA: buffers claimed = 6/6, eliminated = 0
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'C:\ORACLE\ORADATA\TESTGEA\UNDOTBS01.DBF'
This is a bit of a catch 22 as I need to open the database (startup mount won't do) in order to do anything with the corrupted tablespace and it is the corrupted undo tablespace which keeps the database from opening.
I don't care so much about lost transactions but this test database is useful and I would like to get it started if I can.
I am afraid that for this database I have no backups from RMAN or a system backup to fall back upon (I know that's bad but it is not often used.)
Anyone knows how to recover from this? Any help will be greatly appreciated.
Thanks
Hugo