Re: Can't read RBS datafile

Did you check that the system rollback segment is Online? Did you rename the datafile throught OS?

What OS are you using?

Mario Alvarado
malvarad_at_t-net.net.ve

      B C Zygmunt <bzy_at_ornl.gov> wrote in article <4v7uum$pm1_at_stc06.ctd.ornl.gov>...
> 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.
>
Received on Mon Aug 19 1996 - 00:00:00 CEST