Oracle-L: RE: ORA-600

From: Michael P Sale <Michael.Sale_at_oracle.com>
Date: Fri, 31 May 2002 06:03:22 -0800
Message-ID: <F001.00470B7C.20020531060322@fatcity.com>

This is an error that occurred while recovering from a rolled back transaction. Not a "database" recovery.

This could be caused by doing a control-c while trying to truncate a large table (Bug 1400739 fixed in 8.1.7.1). Could also be from an undo operation on a leaf key of a bitmap index. You should be able to tell this from the trace file. Either way I would open a TAR with Oracle Support to get a proper diagnosis from the trace files.

Ultimately, it looks like you have some form of rollback segment corruption, likely block corruption in your rollback tablespace. I would strongly suggest that you open a tar with Oracle Support. Check your alert log for related trace files, in particular SMON trace files. In the mean time check out Metalink note 28814.1 regarding dealing with block corruptions just to get an idea of the possible implications (e.g. logical data corruption).

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626

-----Original Message-----
Sent: Friday, May 31, 2002 6:18 AM
To: Multiple recipients of list ORACLE-L

Dear All,

I am gettying the follwoing error on our alert_log file,though no porblem in the activity of database. Has any one faced this problem, It is AIX, Oracle 8.1.7 Database and non archived mode. We never gave like recover any thing, why it is trying to recover from error message as follows?

ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []
Mon May 13 16:10:59 2002
ORACLE Instance PAR_D1 (pid = 6) - Error 600 encountered while recovering transaction (7, 43) on object 1.
Mon May 13 16:10:59 2002

Thanks for your help.
Ravi

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?q?Nalla=20Ravi?=
INET: vvnrk2001_at_yahoo.co.uk

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: Michael P Sale
INET: Michael.Sale_at_oracle.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------