Re: Force drop of UNDO tablespace (with online segment) in 9.2.0.8?
Date: Wed, 23 Sep 2009 16:14:00 -0700 (PDT)
Message-ID: <7b815f40-0cf3-49df-a9b9-8c556aa19fd5_at_r24g2000prf.googlegroups.com>
I've been trying to post this all day (Google Groups) without success. Thanks Joel if this posts upon your advice.
> Here is the solution:
>
> startup mount;
>
> alter system set undo_management = 'MANUAL' scope=spfile;
>
> alter system set "_corrupted_rollback_segments"="_SYSSMU11$" scope=spfile;
>
> startup;
>
> drop rollback segment "_SYSSMU11$";
>
> shutdown;
>
> startup nomount
> alter database open
>
> That was extracted from the ML note 28814.1. Of course, you should return
> to the automatic undo afterwards.
>
> --http://mgogala.free hostia.com
Thanks Mladen! That worked perfectly, very much appreciated.
Congratulations on finding that in Metalink as I spent a couple of hours looking at how to do it and still couldn't solve it (maybe I'm getting too old :). I then went and looked at the note you reference and still couldn't find anything to do with "_corrupted_rollback_segments".
I then did a ML knowledge base search (using the flash version, grumble grumble) on "_corrupted_rollback_segments" and it only returned six hits. Only two of those six hits contained the string "_corrupted_rollback_segments"!
I then did an advanced search (unquoted) The Exact Phrase: _corrupted_rollback_segments
And got six hits again with only two hits containing the search string!
Has anyone else noticed this? Received on Wed Sep 23 2009 - 18:14:00 CDT