Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
Doing block recovery for fno: 2 blk: 61
Wed Sep 26 18:00:01 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0

Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
Wed Sep 26 18:00:01 2007
Errors in file /u01/product/admin/wind/bdump/wind_smon_1722.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], [14], [2], [], [], [], [], []
Wed Sep 26 18:00:02 2007
ORA-607 signalled during: ALTER DATABASE OPEN...

Doing block recovery for fno: 46 blk: 824
Wed Sep 26 18:00:02 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log

Mem# 1 errs 0: /data3/wind/redo01b.log
Doing block recovery for fno: 2 blk: 45
Wed Sep 26 18:00:02 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log

SMON: enabling cache recovery
Wed Sep 26 18:09:34 2007
Successfully onlined Undo Tablespace 1.
Wed Sep 26 18:09:34 2007
SMON: enabling tx recovery
Wed Sep 26 18:09:34 2007
Database Characterset is UTF8
replication_dependency_tracking turned off (no async multimaster replication fou
nd)
Wed Sep 26 18:09:35 2007
Errors in file /u01/product/admin/wind/udump/wind_ora_1782.trc:
ORA-00600: internal error code, arguments: [4194], [51], [39], [], [], [], [], [
]
ORA-607 signalled during: alter database open ...
Doing block recovery for fno: 37 blk: 40
Wed Sep 26 18:09:36 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
Doing block recovery for fno: 2 blk: 21
Wed Sep 26 18:09:36 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log

SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [51], [39], [], [], [], [],
[]

Oracle 9.2.0.7
Linux AS3.0

测试用数据库，正在数据写入的时候RAID发生问题，系统重新开机后，UNDO的一个数据文件file#=37 的第40个数据块发生问题，由于测试库没有备份，晕，似乎没有其他方式恢复了 ?

Metalink :

=============================

Subject: ORA-600 [4194] "Undo Record Number Mismatch While Adding Undo Record"
Doc ID: Note:39283.1 Type: REFERENCE
Last Revision Date: 14-AUG-2007 Status: PUBLISHED

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

PURPOSE:
This article discusses the internal error "ORA-600 [4194]", 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 [4194] [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 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 [b] 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

=======================================

加入隐含参数._corrupted_rollback_segments=

ITPub博客

ORA-00607: Internal error occurred while making a change to a data block

最新文章