Can't read RBS datafile

From: B C Zygmunt <bzy_at_ornl.gov>
Date: 1996/08/18
Message-ID: <4v7uum$pm1_at_stc06.ctd.ornl.gov>#1/1


I took the RBS tablespace offline in order to move the datafile. (I first took all of the rollback segments offline.) Now, I can't get the database to start. I have tried bringing the database up in "mount" mode and using the "alter database drop datafile" command, but I still get the following errors:

ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/oracle/or2/datafiles/rbs_1.dbf'

I also tried "alter database create datafile" but had to better luck. I've removed the references to the RBS from the init.ora file. Do I have any other recourse than to restore everything from my Saturday backup?

Thanks for any help.

Beverly

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 

_/_/ + _/_/
_/_/ Beverly Cather Zygmunt + Phone: (615) 574-1007 _/_/
_/_/ Oak Ridge National Laboratory + email: zygmuntbc_at_ornl.gov _/_/
_/_/ Building 4500N, MS 6274 + bzy_at_ornl.gov _/_/
_/_/ Oak Ridge, TN 37831-6274 + _/_/
_/_/ + _/_/
_/_/ + _/_/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/_/ _/_/
_/_/ "If you torture your data long enough, they will tell you what _/_/
_/_/ you want to hear." -- James L. Mills _/_/
_/_/ _/_/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Received on Sun Aug 18 1996 - 00:00:00 CEST

Original text of this message