Message-Id: <10669.121037@fatcity.com> From: Javier Morales Date: Fri, 3 Nov 2000 11:38:10 +0100 Subject: 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@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@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@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@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" ROLLBACK SEGMENT FAILED
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@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@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@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@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