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
[EMAIL PROTECTED]
-----Original Message-----
From: Joe Testa [mailto:[EMAIL PROTECTED]]
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: [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: MacGregor, Ian A.
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).
