RE: Rollback segments in "RECOVER" status

First of all, you must never put a datafile of rollback tablespace offline when the database is up and running. You should put the rollback segment offline:

alter rollback segment <rbs01> offline; ( try not to use STORAGE MANAGER or Enterprise Manager products )

Now for your problem issue from svrmgr23 a recover datafile 'E:\ORANT\DATABASE\RBS2ORCL.ORA' ( CROSS YOUR FINGERS(*) ) and then alter database datafile 'E:\ORANT\DATABASE\RBS2ORCL.ORA' online;. Probably after this the rollbacks should be online because it isn't an usually case of NEEDS RECOVERY. However take a look of the state of those issuing a select segment_name,status from sys.dba_rollback_segs where segment_name in ('RB3','RB4','RB5','RB6','RB7','RB8','RB9','RB10','RB11','RB12','RB13','RB14 ','RB15','RB16');

(*) Because of the archive mode of your database. If you have it in archivelog with archives, NO PROBLEM. However if it an NOARCHIVELOG database, you should pray just to expect that the information is in the redo logs.

Regards and good luck.

> -----Mensaje original-----
> De: Andersen, Wayne A [SMTP:WayneAAndersen_at_Eaton.com]
> Enviado el: lunes 8 de enero de 2001 20:46
> Para: Multiple recipients of list ORACLE-L
> Asunto: Rollback segments in "RECOVER" status
>
> Hi all,
>
> I'm running Oracle 7.3 on a Windows NT platform.
>
> Recently I was trying to increase the size of the roll back segments to
> make
> room for a large transaction. Using Oracle Storage Manager, I set a
> datafile offline thinking it would go offline when any transactions that
> might be using it finished. Instead it went in to "RECOVER" mode.
>
> My users are now getting "ORA-00376 file 15 cannot be read at this time."
> and "ORA-01110 data file 15: E:\ORANT\DATABASE\RBS2ORCL.ORA."
>
> Rollback segments RB3 through RB16 show a status of "NEEDS RECOVERY".
>
> I was even going to drop the database, re-create it, and re-import the
> data,
> but it won't even let me do that!
>
> Anyone have an idea of how I can get out of this problem?
>
> Thanks,
>
> Wayne Andersen
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andersen, Wayne A
> INET: WayneAAndersen_at_Eaton.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jan 09 2001 - 03:14:21 CST