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 ownReceived on Wed Jun 21 1995 - 00:00:00 CEST