ROLLBACK SEGMENT FAILED

From: Abhijit Saswadkar <Abhijit.Saswadkar_at_originindia.com>
Date: Fri, 3 Nov 2000 14:37:04 +0530
Message-Id: <10669.121033@fatcity.com>

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_01C04575.6F2B06B0
Content-Type: text/plain

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.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_01C04575.6F2B06B0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>ROLLBACK SEGMENT FAILED</TITLE>
</HEAD>
<BODY>

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 .

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">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.

</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">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:       = =20

<P><FONT SIZE=3D2 FACE=3D"Arial">set oracle-l nomail</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =

FAQ: <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Nguyen, Long</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; 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
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 = Received on Fri Nov 03 2000 - 03:07:04 CST