最近我的系统总是出现这样的问题，大侠们帮我看看，是怎么回事？

dlplayers · 发表于 2005-4-29 09:02

Fri Apr 29 09:11:14 2005
Errors in file /home/oracle/OraHome9i/admin/hd/bdump/hd_smon_30422.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [60], [57], [], [], [], [], []
Fri Apr 29 09:11:18 2005
Errors in file /home/oracle/OraHome9i/admin/hd/udump/hd_ora_30513.trc:
ORA-00600: internal error code, arguments: [4194], [60], [57], [], [], [], [], []
Fri Apr 29 09:11:20 2005
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1095 Reading mem 0
  Mem# 0 errs 0: /oradata/hd/log1/redo021.log
  Mem# 1 errs 0: /oradata/hd/log2/redo022.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1095 Reading mem 0
  Mem# 0 errs 0: /oradata/hd/log1/redo021.log
  Mem# 1 errs 0: /oradata/hd/log2/redo022.log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1096 Reading mem 0
  Mem# 0 errs 0: /oradata/hd/log1/redo011.log
  Mem# 1 errs 0: /oradata/hd/log2/redo012.log

rollingpig · 发表于 2005-4-29 09:08

贴出版本（小版本），OS

dlplayers · 发表于 2005-4-29 09:11

redflag linux(Kernel 2.4.21),oracle92040

dlplayers · 发表于 2005-4-29 10:45

谁能支个招啊？

husthxd · 发表于 2005-4-29 11:34

ERROR:
  ORA-600 [4194] [a]

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 record number relating to the change being
  applied against the maximum undo record number recorded in the undo block.

  This error is reported when the validation fails.

ARGUMENTS:
  Arg [a] Maximum Undo record number in Undo block
  Arg Undo record number from Redo block

FUNCTIONALITY:
  Kernel Transaction Undo called from Cache layer

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.

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

  Known Issues:

  Bug# 3210520 See [NOTE:3210520.8]
   OERI[kjccqmg:esm] / OERI[4194] / corruption possible in RAC
   Fixed: 9.2.0.5, 10.1.0.2

  Bug# 792610 +  See [NOTE:792610.8]
   Rollback segment corruption OERI:4194 can occur if block checking detects a corrupt block
   Fixed: 8.0.6.0, 8.1.6.0