You may have undo/rollback segment corruption, Oracle bug: 2431450. My take
is that you should recover the database from backup to a point in time just
before the original crash, or contact Oracle support for assistance in
resolving the undo problem and (hopefully) saving the data. Oracle support
have tools to help with this issue.

Make sure you do another database backup before trying anything!!

From Oracle:

Fixed:
This issue is fixed in 9.0.1.5 iAS Patch Set
9.2.0.4 (Server Patch Set)
10g Production Base Release


Symptoms:
Corruption (Physical)
Internal Error may occur (ORA-600)
ORA-600 [kteuPropTime-2] / ORA-600 [4191]
Related To:
System Managed Undo
Description


SMU (System Managed Undo) Undo corruption possible on instance crash.

This can result in subsequent ORA-600 errors due to the undo
corruption.


-----Original Message-----
From: Ross Hansford
[mailto:oracledba-ezmlmshield-x66019712.[Email address protected]
Sent: 01 December 2005 04:03
To: LazyDBA Discussion
Subject: ORA-600 error

The database crashed last night with this error

ORA-00600: internal error code, arguments: [kteuPropTime-2], [], [], [], [],
[], [], []

Now the database cannot be opened, only mounted.

When I try to open the database this is the output recorded in the alert
log.
Errors in file
DSA100:[ORACLE9.V901.DB_PROD9.TRACE]NEWTON_PROD9_FG_ORACLE_008.TRC;:
ORA-00600: internal error code, arguments: [kteuPropTime-2], [], [], [], [],
[], [], []
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 2031cd57
ORA-1092 signalled during: ALTER DATABASE OPEN...
Starting up ORACLE RDBMS Version: 9.0.1.4.0.

The database is running on openvms 7.2 Oracle9i version 9.0.1.4.0

Does any one have any ideas?



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

-----------------------------------------
Information in this email may be privileged, confidential and is intended
exclusively for the addressee. The views expressed may not be official
policy, but the personal views of the originator. If you have received it
in error, please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit, use or
disclose its contents to anyone. Please note we reserve the right to
monitor all e-mail communication through our internal and external
networks.


Oracle LazyDBA home page