Re: Lost rollback segment datafile, database will not start

From: nomenclature <nom_at_tonal.net>
Date: Fri, 22 Sep 2000 14:45:15 +0100
Message-ID: <39CB626B.F315ACF4@tonal.net>

Chuck Carson wrote:
>
> 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)

Try to startup nomount and drop the rollback tablespace, create a new one and off you go.

If you've deleted the datafile you are screwed and have to drop the tablespace.

If I'm wrong - please correct me!
Happened to me before but never again. Received on Fri Sep 22 2000 - 08:45:15 CDT