RE: Rollback Segment needs recovery

Hello Kevin,

I missed second part of your message:

>case, dropping the objects will not do the trick because it will happen
>again when the Rollback Segment is accessed for another activity.

coruupted rbs immediately should be dropped after fixing errors.

regards...

28/7/01 12:00:58, Kevin Lange <kgel_at_ppoone.com> wrote:

>Danisment;
> When we had a problem that we needed the _corrupted_rollback_segments
>option added to the init.ora file. The Rollback Segment itself was
>corrupted. Not the objects using the Rollback Segment. If this is the
>case, dropping the objects will not do the trick because it will happen
>again when the Rollback Segment is accessed for another activity.
>
>-----Original Message-----
>Sent: Friday, July 27, 2001 2:17 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hello,
>
>It's bad problem. I think _offline_rollback_segments or
>_corrupted_rollback_segments should be last method.
>
>I'll recommend a tip for this error: If you can identify which objects need
>recovery and then drop them, Oracle doesn't try to recover them, so "needs
>recovery" goes away.
>
>Let's identify which object need recovery in corrupted rbs:
>
>- add following parameters to init.ora:
>
>event="10013 trace name context forever, level 10"
>event="10015 trace name context forever, level 10"
>
>Note that if there are more than 1 event in init.ora, they have to be
>consecutive. otherwise just last one will be active.
>
>Now, re-start db abd try to get same error. Oracle will dump recovery
>operation
>in alert.log. And you will be able to see object id. drop this object.
>That's
>all.
>
>You can paste recovery dumps in alert.log to identify your object, as well.
>
>regards...
>
>
>
>
>27/7/01 08:37:06, "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com> wrote:
>
>>Hi DBAs,
>>
>>Oracle 8.0.5/Windows NT4
>>
>>I shutdown database normal and restarted ok.
>>I tried to drop a rollback segment and getora-1545 rollback segment not
>>available.
>>When I select from dba_rollback_segs I get "needs recovery".
>>
>>I want to drop rollback tablespace and all rollback segment then rebuild
>>because I got datafile corruption error.
>>I am in noarchive mode.
>>
>>Any ideas how to proceed?
>>
>>Thanks
>>Rick
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Cale, Rick T (Richard)
>> INET: RICHARD.T.CALE_at_saic.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).
>>
>>
>>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Danisment Gazi Unal (Unal Bilisim)
> INET: danisment.unal_at_unal-bilisim.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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kevin Lange
> INET: kgel_at_ppoone.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).
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.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).