Rollback segment file corrupted

From: Jean-Pierre Lamarche <lamarcjp_at_mtl.dmr.ca>
Date: 1995/06/21
Message-ID: <3s9d70$7td_at_guillotine.mtl.dmr.ca>#1/1


I am running 7.0.13.
We rebooted UNIX (NCR SVR 4.0) after a crash. All my rollback segments are located into the same datafile (rbs.dbf) Oracle didn't reboot correctly; I got the messages:  ORA-01113 file needs media recovery
 ORA-01110 file rbs.dbf needs recovery.

For me there is an oracle bug, the system should recover. The RDBMS refuses to open the database
 (alter database open)

Anyway, I dont mind loosing the rollback segment file (and the related transactions).

Does anybody know how to open the database ?

Oracle support does not seems to know how to do it.

By the way, Oracle has an amout of undocumented features (that can be placed into the init.ora file). Does anybody have a list of it ?

                               Thanks,

Posted for Miss. Dominique Cloutier
by

-- 
  
Jean-Pierre Lamarche                |___|      
DMR Quebec inc.	               __(X)_(_)_(X)__   
  		                    O ' O          
lamarcjp_at_dmr.ca                             \_/ 
(514-877-3301                               \#/  
                                             o     
Toutes ces opinions sont les miennes  All opinions are my own
Received on Wed Jun 21 1995 - 00:00:00 CEST

Original text of this message