RE: Rollback segments in "RECOVER" status

Kevin,

Thanks for the reply, Lisa response fixed me.

Wayne

> -----Original Message-----
> From: Kevin Kostyszyn [SMTP:kevin_at_dulcian.com]
> Sent: Monday, January 08, 2001 2:17 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback segments in "RECOVER" status
>
> Couldn't you just perform media recovery on that datafile?
>
> -----Original Message-----
> Wayne A
> Sent: Monday, January 08, 2001 2:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
> INET: kevin_at_dulcian.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 Mon Jan 08 2001 - 14:37:48 CST