Re: Lost datafile - help!!

Hello Jeremy,

Corrupt Rollback tablespace removal.

1.remove all Rollback segs from the INIT.ORA

          SQLDBA> startup

2.drop the RBS tablespace:

          SQLDBA> startup mount
          SQLDBA> Alter database datafile  '/xxx/rbs.dbs' offline [drop] ;
          SQLDBA> Alter database open ;
          SQLDBA> Alter tablespace 'xxx...' offline ;
          SQLDBA> Drop tablespace  'xxx...' ;

3.If the database wants the Rollback segments, put the following line in the INIT.ORA               _offline_rollback_segments = (rs_1,...)

4.If your Rollback segs are still corrupt, put the following line in the INIT.ORA              _corrupted_rollback_segments = (rs_1,...)

5.Create a new Rollback tablespace and segments. Any old data in the rollback segs is now lost.

Cheers, Roelof

R. Schierbeek, DBA

email : info_at_bytelife.com
www   : www.bytelife.com
SQL   : www.bytelife.com/sql4dba.htm

Jeremy Ovenden <jovenden_at_hazelweb.co.uk> schreef in
> 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 - 15:16:19 CDT