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 -> Lost rollback segment datafile, database will not start

Lost rollback segment datafile, database will not start

From: Chuck Carson <ccarson_at_usbx.com>
Date: Thu, 14 Sep 2000 14:03:07 GMT
Message-ID: <39c0da72.677733148@news.earthlink.net>

I created a rollback segment and then later deleted the datafile by accident. Here is what I get when trying to Start the DB:

ORA-01157: cannot identify/lock data file 19 - see DBWR trace file ORA-01110: data file 19: '/u08/oradata/OPS/bigrbs201.dbf'

This is a development DB and there was no activity during this time
(probably 12 hours idle)

How can I fix this?

(This is Oracle 8.1.6R2 on Solaris 2.7)

Thanks greatly,
Chuck Received on Thu Sep 14 2000 - 09:03:07 CDT

Original text of this message

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