RE: Undo x Rollback Segments in 9i

I would not use automatic undo management with 9i until they debug it. We had a posting a few weeks ago on bug 1904199 or a variant thereof. Here are the last few lines from the mail detailing the problem

Then one day on trying to reopen the database following
>
>Errors in file /opt/db/oracle/admin/report/udump/report_ora_14226.trc:
>ORA-00600: internal error code, arguments: [kteoprpect-1], [2], [1], [],
>[], [], [], []
>Sun Aug 12 21:38:45 2001
>Errors in file /opt/db/oracle/admin/report/udump/report_ora_14226.trc:
>ORA-00600: internal error code, arguments: [kteoprpect-1], [2], [1], [],
>[], [], [], []
>Sun Aug 12 21:38:45 2001
>Error 600 happened during db open, shutting down database
>USER: terminating instance due to error 600
>Instance terminated by USER, pid = 14226
>ORA-1092 signalled during: alter database open...
>
>Our support analysts saud that a fix was in progress and that there was no
>known way to recover, even an ALTER DATABASE OPEN RESETLOGS. A choice
>tidbit from the bug report:
>
>"This could be quite serious for customers as there is no simple way out of
>this scenario."
>
>Buyer beware.
>

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
From: Joe Testa [mailto:teci_at_the-testas.net] Sent: Thursday, September 20, 2001 7:50 PM To: Multiple recipients of list ORACLE-L

have u read the docs on the differences yet?

there is a bit to read about(as i'm going thru it all for a potential presentation on automatic undo management).

i think the verdict has not been decided yet as to whether its good or not as its too new for alot of people.

joe
Eca Eca wrote:
>
> Friends :
>
> I tried to create a rollback segment in 9i and its said to me :
>
> CREATE PUBLIC ROLLBACK SEGMENT "RBS01" TABLESPACE "RBS"
> *
> ERROR at line 1:
> ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
>
> Well, i realized that Oracle created for me some resource like rollback
> segment automaticaly.
>
> My doubt :
>
> If i will put the instance in Manual Undo I can to create the rollback
> segment, but i will lost the resource automatic.
>
> does anyone use it or know how to use Automatic Undo ?
>
> What is the best option :
>
> Rollback or Undo Automatic.
> I know rollback but i don't know Undo Automatic
>
> Regards
>
> Eriovaldo
>
> _________________________________________________________________
> Chegou o novo MSN Explorer. Instale já. É gratuito!
> http://explorer.msn.com.br
>

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

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: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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