Re: Lost rollback segment datafile, database will not start

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 15 Sep 2000 21:25:04 +1000
Message-ID: <39c1f8a4$1@news.iprimus.com.au>

Alter database datafile 19 offline drop

Then alter database open

Time to recreate an RBS tablespace.

Oh -incidentally, make sure the init.ora for this Instance isn't attempting to online rollback segments housed in the tablespace which has gone dodgy. Comment out the offending line, or edit appropriately.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Chuck Carson" <ccarson_at_usbx.com> wrote in message
news: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 Fri Sep 15 2000 - 06:25:04 CDT