ora-00600错误

日志文件中错误信息：

Mon Apr 16 14:37:52 2007

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

Using log_archive_dest parameter default value

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.1.0.

System parameters with non-default values:

  processes                = 150

  timed_statistics         = TRUE

  shared_pool_size         = 50331648

  large_pool_size          = 8388608

  java_pool_size           = 33554432

  control_files            = f:\ora\oradata\gzsb\control01.ctl, f:\ora\oradata\gzsb\control02.ctl, f:\ora\oradata\gzsb\control03.ctl

  db_block_size            = 8192

  db_cache_size            = 25165824

  compatible               = 9.2.0.0.0

  db_file_multiblock_read_count= 16

  fast_start_mttr_target   = 300

  undo_management          = AUTO

  undo_tablespace          = UNDOTBS1

  undo_retention           = 10800

  remote_login_passwordfile= EXCLUSIVE

  db_domain                =

  instance_name            = xxxxxx

  dispatchers              = (PROTOCOL=TCP) (SERVICE=gzsbXDB)

  job_queue_processes      = 10

  hash_join_enabled        = TRUE

  background_dump_dest     = c:\oracle\admin\gzsb\bdump

  user_dump_dest           = c:\oracle\admin\gzsb\udump

  core_dump_dest           = c:\oracle\admin\gzsb\cdump

  sort_area_size           = 524288

  db_name                  = xxxxx

  open_cursors             = 300

  star_transformation_enabled= FALSE

  query_rewrite_enabled    = FALSE

  pga_aggregate_target     = 25165824

  aq_tm_processes          = 1

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

CJQ0 started with pid=8

QMN0 started with pid=9

Mon Apr 16 14:37:54 2007

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Mon Apr 16 14:37:55 2007

ALTER DATABASE   MOUNT

Mon Apr 16 14:38:00 2007

Successful mount of redo thread 1, with mount id 1403199684.

Mon Apr 16 14:38:00 2007

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE   MOUNT

Mon Apr 16 14:38:00 2007

ALTER DATABASE OPEN

Mon Apr 16 14:38:00 2007

Beginning crash recovery of 1 threads

Mon Apr 16 14:38:00 2007

Started first pass scan

Mon Apr 16 14:38:00 2007

Completed first pass scan

 62 redo blocks read, 4 data blocks need recovery

Mon Apr 16 14:38:00 2007

Started recovery at

 Thread 1: logseq 43, block 3, scn 0.0

Recovery of Online Redo Log: Thread 1 Group 1 Seq 43 Reading mem 0

  Mem# 0 errs 0: F:\ORA\ORADATA\GZSB\REDO01.LOG

Mon Apr 16 14:38:00 2007

Ended recovery at

 Thread 1: logseq 43, block 65, scn 0.2970218

 4 data blocks read, 4 data blocks written, 62 redo blocks read

Crash recovery completed successfully

Mon Apr 16 14:38:00 2007

Thread 1 advanced to log sequence 44

Thread 1 opened at log sequence 44

  Current log# 2 seq# 44 mem# 0: F:\ORA\ORADATA\GZSB\REDO02.LOG

Successful open of redo thread 1.

Mon Apr 16 14:38:00 2007

SMON: enabling cache recovery

Mon Apr 16 14:38:00 2007

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Mon Apr 16 14:38:00 2007

SMON: enabling tx recovery

Mon Apr 16 14:38:00 2007

Database Characterset is ZHS16GBK

Mon Apr 16 14:38:00 2007

Errors in file c:\oracle\admin\gzsb\bdump\gzsb_smon_5196.trc:

ORA-00600: internal error code, arguments: [4194], [98], [75], [], [], [], [], []

 

Mon Apr 16 14:38:01 2007

Errors in file c:\oracle\admin\gzsb\udump\gzsb_ora_3648.trc:

ORA-00600: 内部错误代码，参数: [4194], [92], [84], [], [], [], [], []

 

Mon Apr 16 14:39:02 2007

Recovery of Online Redo Log: Thread 1 Group 2 Seq 44 Reading mem 0

  Mem# 0 errs 0: F:\ORA\ORADATA\GZSB\REDO02.LOG

Recovery of Online Redo Log: Thread 1 Group 2 Seq 44 Reading mem 0

  Mem# 0 errs 0: F:\ORA\ORADATA\GZSB\REDO02.LOG

Mon Apr 16 14:39:02 2007

Errors in file c:\oracle\admin\gzsb\udump\gzsb_ora_3648.trc:

ORA-00607: 当更改数据块时出现内部错误

ORA-00600: 内部错误代码，参数: [4194], [92], [84], [], [], [], [], []

 

Error 607 happened during db open, shutting down database

USER: terminating instance due to error 607

Instance terminated by USER, pid = 3648

ORA-1092 signalled during: ALTER DATABASE OPEN...

 

查看资料得到：

Would seem that the error is:

ORA-600 [4194] "Undo Record Number Mismatch While Adding Undo Record".

 

Refer to Metalink note 39283.1.

 

In future use Metalink note 153788.1 (Subject: Troubleshoot an ORA-600

Error Using the ORA-600 Argument Lookup Tool).

 

参考：http://www.eygle.com/blog

 

由于数据库只能在MOUNT状态所以

select * from v$rollname;

select * from undo$;

select * from v$tablespace;都不能使用

 

1、通过错误信息可以确定当前回滚段是1-10，所以修改PFILE文件将下面这个隐含参数加到文件中去：

._corrupted_rollback_segments='_SYSSMU1$','_SYSSMU2$','_SYSSMU3$','_SYSSMU4$','_SYSSMU5$','_SYSSMU6$','_SYSSMU7$','_SYSSMU8$','_SYSSMU9$','_SYSSMU10$'

STARTUP PFILE=’XXXX’

可以看到数据库已经正常启动

2、create undo tablespace undotbs2  datafile 'F:\ORA\ORADATA\GZSB\undotbs2.dbf';

   alter system set undo_tablespace=undotbs2;

   drop tablespace undotbs2;

3、修改参数文件，变更undo表空间，并取消_corrupted_rollback_segments设置: 

*.undo_tablespace='UNDOTBS2' 

4、startup pfile=’xxxxx’

   create spfile from pfile;

   shutdown immediate

   statup

 

故障解决，进行全库备份