Lost datafile - help!!

From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Thu, 21 Jun 2001 15:05:08 +0100
Message-ID: <tj3vmbmt9dqc4e@xo.supernews.co.uk>

Guys, any help appreciated. This is a development box (solaris 2.7) running 8.0.6

Cut a long story short, disk got corrupted had to be replaced. Corruption was in a datablock used by the datafile for rollback segments.

All other files successully restored for the database except for this one.

Can start the database as usual, however many operations give message:

ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: '/u02/oradata/db1/rbs01.dbf'

Have tried all sorts of things to offline/remove etc the tablespace and datafile, all to no avail.

Anyone come across this before and able to identify a path to recover from this or do I really have to recreate the database?

Thanks......

--

Jeremy

Received on Thu Jun 21 2001 - 09:05:08 CDT