Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback segments in "RECOVER" status

RE: Rollback segments in "RECOVER" status

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Mon, 8 Jan 2001 15:47:20 -0500
Message-Id: <10735.126057@fatcity.com>


Sweet, this list rocks
kevin

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Andersen, Wayne A
Sent: Monday, January 08, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L Subject: 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).

-- 
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
Received on Mon Jan 08 2001 - 14:47:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US