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
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.
                               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
