Re: Lost rollback segment datafile, database will not start

From: Frank <frankbo_at_interaccess.nl>
Date: Thu, 14 Sep 2000 16:18:32 +0200
Message-ID: <8pqmo4$4ht$1@porthos.nl.uu.net>

Yup,

startup mount
drop the rollback segments in this datafile drop the datafile
alter database open

--
Frank
Chuck Carson <ccarson_at_usbx.com> schreef in berichtnieuws
39c0da72.677733148_at_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:18:32 CDT