Re: Lost rollback segment datafile, database will not start

On Thu, 14 Sep 2000 16:18:32 +0200, "Frank" <frankbo_at_interaccess.nl> wrote:

>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
>>
>
>

I get 'database not opened' when I try this. I have also tried _CORRUPTED_ROLLBACK_SEGMENTS and _OFFLINE_ROLLBACK_SEGMENTS parameters and still no luck.

Any ideas?

Thanks grreatly,
Chuck Received on Thu Sep 14 2000 - 12:36:46 CDT