| 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_01C04583.0E622910
Content-Type: text/plain;
charset="iso-8859-1"
have you tried a point in time recover??
use your archived logs and try it...
good luck! ;-)
-----Mensaje original-----
De: Abhijit Saswadkar [mailto:Abhijit.Saswadkar_at_originindia.com]
Enviado el: viernes 3 de noviembre de 2000 10:11
Para: Multiple recipients of list ORACLE-L
Asunto: 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 - 04:38:10 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). ------_=_NextPart_001_01C04583.0E622910 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=Verdana size=2><SPAN class=424244110-03112000>have
you tried a point in time recover??</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=424244110-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=424244110-03112000>use
your archived logs and try it...</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=424244110-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=424244110-03112000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=424244110-03112000>good
luck! ;-)</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Mensaje original-----<BR><B>De:</B> Abhijit Saswadkar [mailto:Abhijit.Saswadkar_at_originindia.com]<BR><B>Enviado el:</B> viernes 3 de noviembre de 2000 10:11<BR><B>Para:</B> Multiple recipients of list ORACLE-L<BR><B>Asunto:</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
 |
 |