ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00607: Internal error occurred while making a change to a data block

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

原创 Linux操作系统 作者:tolywang 时间:2007-09-27 00:00:00 0 删除 编辑

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

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

http://www.eygle.com/archives/2006/...a_600_4194.html

加入隐含参数._corrupted_rollback_segments=

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-84917/,如需转载,请注明出处,否则将追究法律责任。

下一篇: exp compress=n
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13102006