ora-00600江湖救急

baisionlyz 2009-12-19 10:30:12

前提是数据坏了只剩下了数据文件，重新创建的控制文件，日志文件等等。最后的错误就是这样的。

Dump file D:\oracle\admin\DH\bdump\dhALRT.LOG
Sat Dec 19 10:20:12 2009
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\oracle\oradata\DH\control01.ctl, D:\oracle\oradata\DH\control02.ctl, D:\oracle\oradata\DH\control03.ctl
db_block_buffers = 19200
db_block_size = 8192
_db_handles_cached = 0
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
_allow_resetlogs_corruption= TRUE
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = DH
service_names = DH
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = DH
open_cursors = 500
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\DH\bdump
user_dump_dest = D:\oracle\admin\DH\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Sat Dec 19 10:20:16 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Dec 19 10:20:17 2009
ALTER DATABASE MOUNT
Sat Dec 19 10:20:23 2009
Successful mount of redo thread 1, with mount id 971697383.
Sat Dec 19 10:20:23 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Dec 19 10:20:23 2009
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Sat Dec 19 10:20:24 2009
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 12 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\DH\REDO02.LOG
Sat Dec 19 10:20:24 2009
Thread recovery: finish rolling forward thread 1
Thread recovery: 4 data blocks read, 4 data blocks written, 83 redo blocks read
Crash recovery completed successfully
Sat Dec 19 10:20:25 2009
Thread 1 advanced to log sequence 13
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORACLE\ORADATA\DH\REDO03.LOG
Successful open of redo thread 1.
Sat Dec 19 10:20:25 2009
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Dec 19 10:20:29 2009
Errors in file D:\oracle\admin\DH\bdump\dhSMON.TRC:
ORA-00600: internal error code, arguments: [ktfdfinsert1], [36], [1750], [], [], [], [], []

Sat Dec 19 10:20:54 2009
Completed: ALTER DATABASE OPEN
Sat Dec 19 10:20:54 2009
SMON: terminating instance due to error 600
Instance terminated by SMON, pid = 3732

...全文