ORA-00600: 内部错误代码, 参数: […

Thu May 27 13:45:15 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
  processes                = 150
  sga_max_size             = 536870912
  __shared_pool_size       = 83886080
  shared_pool_size         = 83886080
  large_pool_size          = 8388608
  java_pool_size           = 50331648
  control_files            = D:\DISK3\CONTROL01.CTL, D:\DISK6\CONTROL02.CTL, D:\DISK9\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  db_cache_advice          = ON
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = d:\oracle\product\10.1.0\flash_recovery_area
  db_recovery_file_dest_size= 10737418240
  undo_management          = AUTO
  undo_tablespace          = JERRY_UNDO
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
  shared_servers           = 3
  job_queue_processes      = 10
  background_dump_dest     = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MYORACLE\CDUMP
  sort_area_size           = 65536
  db_name                  = myoracle
  open_cursors             = 300
  pga_aggregate_target     = 25165824
PMON started with pid=2, OS id=21628
MMAN started with pid=3, OS id=21776
DBW0 started with pid=4, OS id=1068
LGWR started with pid=5, OS id=20540
CKPT started with pid=6, OS id=17812
SMON started with pid=7, OS id=19680
RECO started with pid=8, OS id=20792
CJQ0 started with pid=9, OS id=20616
Thu May 27 13:45:15 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 3 shared server(s) ...
Thu May 27 13:45:15 2010
ALTER DATABASE   MOUNT
Thu May 27 13:45:15 2010
Controlfile identified with block size 16384
Thu May 27 13:45:20 2010
Setting recovery target incarnation to 6
Thu May 27 13:45:20 2010
Successful mount of redo thread 1, with mount id 1818734891
Thu May 27 13:45:20 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Thu May 27 13:45:20 2010
ALTER DATABASE OPEN
Thu May 27 13:45:20 2010
Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 2 processes
parallel recovery started with 2 processes
Thu May 27 13:45:21 2010
Started first pass scan
Thu May 27 13:45:21 2010
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Thu May 27 13:45:21 2010
Started redo application at
Thread 1: logseq 16, block 844, scn 0.53332424
Recovery of Online Redo Log: Thread 1 Group 5 Seq 16 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO05A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO05B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO05C.LOG
Thu May 27 13:45:22 2010
Completed redo application
Thu May 27 13:45:22 2010
Completed crash recovery at
Thread 1: logseq 16, block 844, scn 0.53352425
0 data blocks read, 0 data blocks written, 0 redo blocks read
Thu May 27 13:45:22 2010
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=22184
ARC0: Archival started
ARC1 started with pid=18, OS id=21336
Thu May 27 13:45:22 2010
ARC1: Archival started
Thu May 27 13:45:22 2010
LGWR: STARTING ARCH PROCESSES COMPLETE
Thu May 27 13:45:22 2010
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu May 27 13:45:22 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Thu May 27 13:45:22 2010
ARC1: Becoming the heartbeat ARCH
Thu May 27 13:45:24 2010
Thread 1 advanced to log sequence 17
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 17
  Current log# 2 seq# 17 mem# 0: D:\DISK3\REDO02A.LOG
  Current log# 2 seq# 17 mem# 1: D:\DISK6\REDO02B.LOG
Thu May 27 13:45:24 2010
  Current log# 2 seq# 17 mem# 2: D:\DISK9\REDO02C.LOG
Successful open of redo thread 1
Thu May 27 13:45:24 2010
ARC0: Evaluating archive   log 5 thread 1 sequence 16
Thu May 27 13:45:24 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu May 27 13:45:24 2010
ARC1: Evaluating archive   log 5 thread 1 sequence 16
Thu May 27 13:45:24 2010
SMON: enabling cache recovery
Thu May 27 13:45:24 2010
ARC1: Unable to archive log 5 thread 1 sequence 16
      Log actively being archived by another process
Thu May 27 13:45:24 2010
db_recovery_file_dest_size of 10240 MB is 69.39% used. This is a
user-specified limit on the amount of space that will be used by this
Thu May 27 13:45:24 2010
ARC1: Evaluating archive   log 5 thread 1 sequence 16
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu May 27 13:45:25 2010
Committing creation of archivelog 'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2010_05_27\O1_MF_1_16_5ZW1QNYH_.ARC'
Thu May 27 13:45:25 2010
ARC1: Unable to archive log 5 thread 1 sequence 16
      Log actively being archived by another process
Thu May 27 13:45:25 2010
Created Oracle managed file D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2010_05_27\O1_MF_1_16_5ZW1QNYH_.ARC
Thu May 27 13:45:26 2010
Successfully onlined Undo Tablespace 8.
Thu May 27 13:45:26 2010
SMON: enabling tx recovery
Thu May 27 13:45:26 2010
Database Characterset is ZHS16GBK
Thu May 27 13:45:26 2010
Published database character set on system events channel
Thu May 27 13:45:26 2010
All processes have switched to database character set
Thu May 27 13:45:28 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00600: 内部错误代码, 参数: [4193], [28532], [28536], [], [], [], [], []

Doing block recovery for file 7 block 1214
Block recovery range from rba 17.61.0 to scn 0.53352489
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery stopped at EOT rba 17.63.16
Block recovery completed at rba 17.63.16, scn 0.53352489
Doing block recovery for file 7 block 41
Block recovery range from rba 17.61.0 to scn 0.53352488
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.63.16, scn 0.53352489
Thu May 27 13:45:32 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00600: 内部错误代码, 参数: [4193], [28532], [28536], [], [], [], [], []

Doing block recovery for file 7 block 1214
Block recovery range from rba 17.61.0 to scn 0.53352489
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.63.16, scn 0.53352491
Doing block recovery for file 7 block 41
Block recovery range from rba 17.61.0 to scn 0.53352491
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.65.16, scn 0.53352492
Thu May 27 13:45:37 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00600: 内部错误代码, 参数: [4193], [27095], [27099], [], [], [], [], []

Doing block recovery for file 7 block 658
Block recovery range from rba 17.65.0 to scn 0.53352495
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery stopped at EOT rba 17.67.16
Block recovery completed at rba 17.67.16, scn 0.53352495
Doing block recovery for file 7 block 25
Block recovery range from rba 17.65.0 to scn 0.53352494
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
  Mem# 0 errs 0: D:\DISK3\REDO02A.LOG
  Mem# 1 errs 0: D:\DISK6\REDO02B.LOG
  Mem# 2 errs 0: D:\DISK9\REDO02C.LOG
Block recovery completed at rba 17.67.16, scn 0.53352495
Thu May 27 13:45:40 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_18472.trc:
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码, 参数: [4193], [27095], [27099], [], [], [], [], []

 

解释：Note: For additional ORA-600 related information please read Note:146580.1

PURPOSE:           
  This article discusses the internal error "ORA-600 [4193]", what
  it means and possible actions. The information here is only applicable
  to the versions listed and is provided only for guidance.

ERROR:             
  ORA-600 [4193] [a] [b]

VERSIONS:          
  versions 6.0 to 10.1

DESCRIPTION:       

  A mismatch has been detected between Redo records and Rollback (Undo)
  records.

  We are validating the Undo block sequence number in the undo block against
  the Redo block sequence number relating to the change being applied.

  This error is reported when this validation fails.

ARGUMENTS:
  Arg [a] Undo record seq number
  Arg [b] Redo record seq number

FUNCTIONALITY:
  KERNEL TRANSACTION UNDO

IMPACT:
  PROCESS FAILURE
  POSSIBLE ROLLBACK SEGMENT CORRUPTION

SUGGESTIONS:       

  This error may indicate a rollback segment corruption.

  This may require a recovery from a database backup depending on
  the situation.

  For further analysis, please submit the trace files and alert.log to
  Oracle Support Services.

  Known Issues:

  Bug# 8240762   See Note:8240762.8
      Undo corruptions with ORA-600 [4193]/ORA-600 [4194] or ORA-600 [4137] after SHRINK
      Fixed: 11.2

由于是UNDO存在不一致，可以通过重建UNDO表空间来解决:

 

SQL> create undo tablespace undotbs2    2 datafile '/opt/oracle/oradata/conner/undotbs2.dbf' size 10m; Tablespace created. SQL> alter system set undo_tablespace=undotbs2 scope=both; System altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area  114365800 bytes Fixed Size                   451944 bytes Variable Size              50331648 bytes Database Buffers           62914560 bytes Redo Buffers                 667648 bytes Database mounted. Database opened. SQL> show parameter undo NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ undo_management                      string      AUTO undo_retention                       integer     10800 undo_suppress_errors                 boolean     FALSE undo_tablespace                      string      UNDOTBS2 SQL> drop tablespace undotbs1 including contents and datafiles; Tablespace dropped.

 

至此，Ora-600 4193错误不再出现。

从alert文件中，可以看到自动控制文件备份生效：

 

Sun Dec 18 22:37:59 2005 drop tablespace undotbs1 including contents and datafiles Sun Dec 18 22:37:59 2005 Deleted file /opt/oracle/oradata/conner/undotbs01.dbf Starting control autobackup Control autobackup written to DISK device         handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20051218-01' Completed: drop tablespace undotbs1 including contents and da