RE: Rollback Segment needs recovery

Hello Kevin,

yes, if The Rollback Segment itself was corrupted, it's the bad of bad. If it's not rbs, dropping object is more simple than other methods.

But, If rbs header is not corrupted, there is still a chance. It's possible to identify uncomitted transactions and/or which corrupted blocks belong to which tx. Once you identify corrupted tx, you can recover until this SCN of corrupted tx.

It's possible to re-apply tx after corrupted SCN. by extracting data from current redo-log dump, data after corrupted scn can be applied to db. This is the method of jumping from an SCN to other non-consecutive SCN.

these are time consuming process. But other method requires rebuilding db. this is time consuming, too. and this method doesn't guarantee consistency even if you rebuild db. rebuilding db just makes dictionary consistent, not your own data.

I think, the best solution is a good back-up.

danisment...

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

>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).