Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Recovering rollback tablespace

Recovering rollback tablespace

From: Sam Jordan <sjo_at_spin.ch>
Date: Wed, 05 May 1999 14:18:25 +0000
Message-ID: <37305331.D0299B52@spin.ch>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US