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)" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
