Rollback datafile RBSORCL.ORA corrupt and not archived. Is it possible to bring db up?

Home -> Community -> Usenet -> c.d.o.server -> Rollback datafile RBSORCL.ORA corrupt and not archived. Is it possible to bring db up?

From: <sbarakam_at_ingr.com>
Date: Fri, 04 Feb 2000 20:26:24 GMT
Message-ID: <87fcl9$nh8$1@nnrp1.deja.com>

On a Oracle 7.3 server, the rollback datafile "RBSORCL.ORA" is corrupt. startup from svrmgr says "needs recovery. datafile '...\rbsorcl.ora' file 3 block .. segment... corrupt.

There is no backup, since it is a test db. Is there a way to bring the database up? I tried to take the rollback segment offline, but since the database can not be opened without this rbsorcl.ora file, it is not possible. The initorcl.ora file does not list this rollback file; I tried _offline_rollback_segment = (rbs) in the init file, along with (rb01), (rb02) etc., but the same error message.

thanks
Sreedhar

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 04 2000 - 14:26:24 CST