Re: [ROLLBACK SEGMENT FAILED]

From: S Jayakumar <sjayakumar2000_at_usa.net>
Date: 3 Nov 00 20:50:17 MST
Message-Id: <10669.121143@fatcity.com>

Hi ,

try this parameter in the init .ora & start the database.

_corrupted_rollback_segments=3D(rbs1,rbs2...)

where rbs1,rbs2 are the rollbacksegments in rbs1.dbf file .

after starting , drop these segment & create a new rollack segments.

regards,
Jay

Abhijit Saswadkar <Abhijit.Saswadkar_at_originindia.com> wrote:

> --------------------------------------------- =

> Attachment:=A0 =

> MIME Type:=A0multipart/alternative =

> --------------------------------------------- =

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 alte= r
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).

---

Get free email and a permanent address at http://www.netaddress.com/?N=3D= 1

---

 From: S Jayakumar <sjayakumar2000_at_usa.net>  Date: 3 Nov 00 21:35:03 MST
 Subject: Re: [Re: Connection Problem]

hello

the log destination directory where lsnr generates log does not have writ= e
permissions other than oracle user it seems. please give write permission=  to
the user you are logging in for running lsnr & try.

hope this solves the problem

Jay

"Giri Gajjela" <yadagiri.gajjela_at_wipro.com> wrote: Hi,

    I copied the .profile of Oracle user. But still its giving the same problem.

Giri
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 31, 2000 10:30 PM

Hi

U need to set path for /usr/ccb/bin. check metalink for an article on thi= s.
it has a checklist on what u are supposed to check and do.

in this case u can check the path variables (including ld_library_path) f= or
the oracle user and use the same in the other user.

hth

babu

Giri Gajjela <yadagiri.gajjela_at_wipro.com>@fatcity.com on 10/31/2000 Received on Fri Nov 03 2000 - 21:50:17 CST