| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback segments in "RECOVER" status
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C079B0.15F46B9E
Content-Type: text/plain
Have you tried initiating recovery? Are you in arclog mode? Doesn't this work:
SET AUTORECOVER ON RECOVER DATAFILE 'filenumber';
ALTER DATABASE DATAFILE <filename> ONLINE;
This may be stickier than just these statements because it is a RBS datafile.
HTH
Lisa
-----Original Message-----
From: Andersen, Wayne A [mailto:WayneAAndersen_at_Eaton.com]
Sent: Monday, January 08, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Subject: 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). ------_=_NextPart_001_01C079B0.15F46B9E Content-Type: text/htmlReceived on Mon Jan 08 2001 - 14:17:55 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Rollback segments in "RECOVER" status</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Have you tried initiating recovery? Are you in arclog mode?</FONT>
<BR><FONT SIZE=2>Doesn't this work:</FONT>
</P>
<P><FONT SIZE=2>SET AUTORECOVER ON</FONT>
</P>
<P><FONT SIZE=2>RECOVER DATAFILE 'filenumber';</FONT>
</P>
<P><FONT SIZE=2>ALTER DATABASE DATAFILE <filename> ONLINE; </FONT>
</P>
<P><FONT SIZE=2>This may be stickier than just these statements because it is a RBS datafile.</FONT>
</P>
<P><FONT SIZE=2>HTH</FONT>
<BR><FONT SIZE=2>Lisa</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Andersen, Wayne A [<A HREF="mailto:WayneAAndersen_at_Eaton.com">mailto:WayneAAndersen_at_Eaton.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, January 08, 2001 2:46 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Rollback segments in "RECOVER" status</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi all,</FONT>
</P>
<P><FONT SIZE=2>I'm running Oracle 7.3 on a Windows NT platform.</FONT>
</P>
<P><FONT SIZE=2>Recently I was trying to increase the size of the roll back segments to make</FONT>
<BR><FONT SIZE=2>room for a large transaction. Using Oracle Storage Manager, I set a</FONT>
<BR><FONT SIZE=2>datafile offline thinking it would go offline when any transactions that</FONT>
<BR><FONT SIZE=2>might be using it finished. Instead it went in to "RECOVER" mode.</FONT>
</P>
<P><FONT SIZE=2>My users are now getting "ORA-00376 file 15 cannot be read at this time."</FONT>
<BR><FONT SIZE=2>and "ORA-01110 data file 15: E:\ORANT\DATABASE\RBS2ORCL.ORA."</FONT>
</P>
<P><FONT SIZE=2>Rollback segments RB3 through RB16 show a status of "NEEDS RECOVERY". </FONT>
</P>
<P><FONT SIZE=2>I was even going to drop the database, re-create it, and re-import the data,</FONT>
<BR><FONT SIZE=2>but it won't even let me do that!</FONT>
</P>
<P><FONT SIZE=2>Anyone have an idea of how I can get out of this problem?</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
</P>
<P><FONT SIZE=2>Wayne Andersen </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Andersen, Wayne A</FONT>
<BR><FONT SIZE=2> INET: WayneAAndersen_at_Eaton.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
 |
 |