Re: Please suggest me about rollback segment corrupted

Hi Saroj;

  Rolback segment can be corrupted due to following reasons:

1. unstable power
2. Bad sectors of disk
3. Any other intermittent hardware problems

Acharya

• Original Message ----- From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 21, 2000 11:15 PM Subject: Please suggest me about rollback segment corrupted

>
> Once I had a problem like rollback segment corrupted ,so i use hidden
> parameter _corrupted_rollback_segment=(r1r,2,r3)
> drop the rollback segment
> recreate the rollback segment.
> databse recovered.
> It was OK.No data loss.
>
> But the my question is why this problem come.what should be the actual
cause
> of rollback segment crroupted .
>
> Now i want to prepare report what is the cause of this problem.Database
was
> in noarchieve log mode.
>
> Please give the suggestion.
>
> Regards,
> Saroj.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.com
>
> 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).
Received on Thu Nov 23 2000 - 14:56:29 CST