Re: Can't read RBS datafile

In article <4v7uum$pm1_at_stc06.ctd.ornl.gov>, bzy_at_ornl.gov says...
>
>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 _/_/
>_/_/ _/_/
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>
>
>

Is '/oracle/or2/datafiles/rbs_1.dbf' the new location or the old location? If it's the old location, then move the file back and try to re-start. If it's the new location, then i would check the file protections.

-- 
Tony Noble
tnoble_at_mt.gov
Opinions expressed do not necessarily reflect those of my employer.