Re: Can't read RBS datafile

bzy_at_ornl.gov ( B C Zygmunt) wrote:
>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 _/_/
>_/_/ _/_/
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>
>
>
Bev...First of all your lucky the file is associated with the Rollback segments. However I'm not sure where you are as far as RECOVERABILITY goes. I see you've tryed some other options. I'm sure(HOPE) you made a backup prior so you'll be able to do this:

From the begining:

SQLDBA/SVRMGR/OEM> STARTUP NOMOUNT

                   ALTER DATABASE RBS OFFLINE DROP;
                   ALTER DATABASE OPEN;

Now.. Your ready
What do you want to do? Renaming a datafile is a 2 step process. 1) You have to copy the name at the O/S level. 2) RENAME within the database. RENAME only does one thing...change the name in the control file.

Hope this Helps
R2
rmramos.gbs_at_worldnet.att.net
Independent Oracle Consultant Received on Mon Aug 19 1996 - 00:00:00 CEST