Re: Lost datafile - help!!

From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Fri, 22 Jun 2001 07:37:59 +0100
Message-ID: <tj5pt3kns3m590@xo.supernews.co.uk>

"R. s" <infooo_at_bibi.com> wrote in message news:1GsY6.1$764.824_at_24hoursnet-reader-1...
> 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.
>

Thanks for your suggestion Roelof, I think I still have a problem: I have paste dthe svrmgr session below if you or anyone else can help further.... (p.s. it is the file '/u02/oradata/db1/rbs01.dbf' that is no longer on the disk):

SVRMGR> startup mount;
ORACLE instance started.

Total System Global Area                         10291632 bytes
Fixed Size                                          51632 bytes
Variable Size                                     9740288 bytes
Database Buffers                                   409600 bytes
Redo Buffers                                        90112 bytes

Database mounted.
SVRMGR> alter database datafile '/u02/oradata/db1/rbs01.dbf' offline drop; Statement processed.
SVRMGR> alter database open;
Statement processed.
SVRMGR> alter tablespace rbs offline;
alter tablespace rbs offline
*
ORA-01191: file 2 is already offline - cannot do a normal offline ORA-01110: data file 2: '/u02/oradata/db1/rbs01.dbf' SVRMGR> drop tablespace rbs;
drop tablespace rbs
*
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option SVRMGR> drop tablespace rbs including contents; drop tablespace rbs including contents
*
ORA-01548: active rollback segment 'R01' found, terminate dropping tablespace
SVRMGR> Received on Fri Jun 22 2001 - 01:37:59 CDT