| 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 SEGMENT FAILED
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_01C04594.53542970
Content-Type: text/plain;
charset="iso-8859-1"
if you had not any active transaction in RBS tablespace you can drop it:
remark (#) rollback_segments parameter in initsid.ora
SVRMGR>startup mount
SVRMGR>alter database datafile '{full path}\rbs01.dbf' offline;
SVRMGR>alter database open;
SVRMGR>drop tablespace RBS INCLUDING CONTENTS;
and after that you can recreate tablespace RBS with rollback segments in it
andrzej kotlarz
-----Original Message-----
From: Abhijit Saswadkar [mailto:Abhijit.Saswadkar_at_originindia.com]
Sent: Friday, November 03, 2000 10:11 AM
To: Multiple recipients of list ORACLE-L
Subject: ROLLBACK SEGMENT FAILED
HI ALL, We are running oracle 8.1.5 on Win NT 4
We extended the datafile rbs01.dbf to have size 61440, but by mistake clicked on MB instead of KB. Server was applying this size for some time and then stopped .
Now we are unable to open the database. We need to alter the size of the rollback segment to older one and start the instance. But when I say alter database open in SVRMGR, it gives me ORA-01122, -01110, -01251 errors.
Bad thing is there is no coldbackup to restore the file from
what steps should i take to recover ?
Regards,
Abhijit A. Saswadkar.
-----Original Message-----
From: Nguyen, Long [SMTP:Long.Nguyen_at_its.csiro.au]
Sent: Friday, November 03, 2000 11:20 AM
To: Multiple recipients of list ORACLE-L Subject: set oracle-l nomail
-- Please see the official ORACLE-L FAQ: http://www.orafaq.comReceived on Fri Nov 03 2000 - 06:48:12 CST
<http://www.orafaq.com>
-- Author: Nguyen, Long INET: Long.Nguyen_at_its.csiro.au 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). --------------------------------------------------------- This message has been scanned for viruses by MIMESweeper. Wiadomosc zostala sprawdzona pod katem wirusow przez oprogramowanie MIMESweeper. --------------------------------------------------------- This message has been scanned for viruses by MIMESweeper. Wiadomosc zostala sprawdzona pod katem wirusow przez oprogramowanie MIMESweeper. ------_=_NextPart_001_01C04594.53542970 Content-Type: text/html; charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>ROLLBACK SEGMENT FAILED</TITLE>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=073484411-03112000>if you
had not any active transaction in RBS tablespace you can drop it:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=073484411-03112000>remark
(#) rollback_segments parameter in initsid.ora</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000>SVRMGR>startup mount</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000>SVRMGR>alter database datafile '{full path}\rbs01.dbf' offline;</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000>SVRMGR>alter database open;</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000>SVRMGR>drop tablespace RBS INCLUDING CONTENTS;
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=073484411-03112000>and
after that you can recreate tablespace RBS with rollback segments in it</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000>andrzej kotlarz</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=073484411-03112000> </SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Abhijit Saswadkar [mailto:Abhijit.Saswadkar_at_originindia.com]<BR><B>Sent:</B> Friday, November 03, 2000 10:11 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> ROLLBACK SEGMENT FAILED<BR><BR></DIV></FONT> <P><FONT color=#0000ff face=Arial size=2>HI ALL,</FONT> </P> <P><FONT color=#0000ff face=Arial size=2>We are running oracle 8.1.5 on Win NT 4</FONT> </P> <P><FONT color=#0000ff face=Arial size=2>We extended the datafile rbs01.dbf to have size 61440, but by mistake clicked on MB instead of KB. Server was applying this size for some time and then stopped . </FONT></P> <P><FONT color=#0000ff face=Arial size=2>Now we are unable to open the database. We need to alter the size of the rollback segment to older one and start the instance. But when I say alter database open in SVRMGR, it gives me ORA-01122, -01110, -01251 errors.</FONT></P> <P><FONT color=#0000ff face=Arial size=2>Bad thing is there is no coldbackup to restore the file from </FONT></P> <P><FONT color=#0000ff face=Arial size=2>what steps should i take to recover ?</FONT> </P> <P><B><I><FONT face="Times New Roman" size=2>Regards,</FONT></I></B> </P> <P><B><I><FONT face="Times New Roman" size=2>Abhijit A. Saswadkar.</FONT></I></B> </P><BR> <UL> <P><FONT face=Arial size=1>-----Original Message-----</FONT> <BR><B><FONT face=Arial size=1>From: </FONT></B> <FONT face=Arial size=1>Nguyen, Long [SMTP:Long.Nguyen_at_its.csiro.au]</FONT> <BR><B><FONT face=Arial size=1>Sent: </FONT></B> <FONT face=Arial size=1>Friday, November 03, 2000 11:20 AM</FONT> <BR><B><FONT face=Arial size=1>To: </FONT></B> <FONT face=Arial size=1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT face=Arial size=1>Subject: </FONT></B> </P> <P><FONT face=Arial size=2>set oracle-l nomail</FONT> <BR><FONT face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Please see the official ORACLE-L FAQ:<U> </U></FONT><U><FONT color=#0000ff face=Arial size=2><A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com</A></FONT></U> <BR><FONT face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Author: Nguyen, Long</FONT> <BR><FONT face=Arial size=2> INET: Long.Nguyen_at_its.csiro.au</FONT>
</P>
<P><FONT face=Arial size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT face=Arial size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT face=Arial size=2>--------------------------------------------------------------------</FONT> <BR><FONT face=Arial size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT face=Arial size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT face=Arial size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT face=Arial size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT face=Arial size=2>also send the HELP command for other information (like subscribing).</FONT> </P></UL><CODE><FONT size=3><BR><BR>---------------------------------------------------------<BR>This message has been scanned for viruses by MIMESweeper.<BR><BR>Wiadomosc zostala sprawdzona pod katem wirusow przez<BR>oprogramowanie MIMESweeper.<BR></BLOCKQUOTE></FONT></CODE><CODE><FONT SIZE=3><BR>
<BR>
---------------------------------------------------------<BR> This message has been scanned for viruses by MIMESweeper.<BR>
 |
 |