Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Recovering rollback tablespace
Hi
I am right now playing with a lot of disaster scenarios (backup/ recovery) to be prepared for a real-world disaster...
I stumbled over problems after I deleted the datafile associated to the rollback segment tablespace (while Oracle was running). First I wanted to do some stuff in sqlplus to make an error message appear, and this worked. Afterwards I tried to fix this error and to make the database working again.
The first problem was, that I was unable to put the rollback tablespace offline (I typed the appropriate command into svrmgrl, but it only hanged). Is this normal? Actually for a lot of recovery operations the tablespace should be put into offline state, at least I have read that.
Second problem: I couldn't shutdown Oracle with immediate parameter, it simply refused to shut down due to missing datafiles. I did a shutdown abort next time, restored the missing datafile and restarted Oracle, followed by a recovery operation on the rollback datafile. Actually it worked, but I am not happy at all about the fact that I had to 'shutdown abort' the database, which would also mean, that I should better do a full database recovery instead of restoring only the rollback tablespace/datafile. Again, is this normal?
Has anyone had a similar case (missing rollback tablespace/datafile) and can report of its own experiences?
bye
--
Sam Jordan
Received on Wed May 05 1999 - 09:18:25 CDT