Re: transaction recovery error

Not good news from my source:

POSSIBLE CORRUPTION Versions: 7.3.x, 8.0.x, 8.1.x

Attempting to back out an undo record and cannot find a corresponding sys.ts$ entry generating this exception.

Suggestion:

Attempt to rebuild the database, or restore from a valid backup and rollforward to a point in time prior to receiving the error. For repeatable occurences, please submit the trace files and alert.log to Oracle Support.

>>> PaulB_at_instipro.com 04/30/01 02:05PM >>>
My 8.1.7 DB on Solaris 2.7 is throwing trace files about every five minutes. The alert log entries say:

SMON: Parallel transaction recovery slave got internal error Mon Apr 30 12:17:32 2001
Errors in file /oracle/admin/ipdevla/bdump/ipdevla_smon_8665.trc: ORA-00600: internal error code, arguments: [4142], [46137989], [], [], [], [], [], []

And the trace file starts with:

KTUNDO: cannot find ts$ entry

The database is running fine, but I'd like to clear this. Calling Oracle Support is not an option at the moment (we're "between" support contracts). I'd appreciate any ideas or suggestions.

Thanks!

Paul Baumgartel
InstiPro Group, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Paul Baumgartel
  INET: PaulB_at_instipro.com 

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: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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