Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ORA-00607和ORA-00600: internal error code, arguments ...
发新帖
henry726

0

积分

1

好友

1

主题

[Exadata硬件] ORA-00607和ORA-00600: internal error code, arguments: [kddummy_blkchk]

1#
发表于 2013-8-26 13:55:59 | 查看: 4386| 回复: 2
Trace下载地址：http://pan.baidu.com/share/link?shareid=1417877644&uk=2820576599
系统环境：
OS: Redhat linux 6.2
DB：oracle 10.2.0.4
问题说明：
      由于出现坏块，启动了trace 10231事件，在删除mv时，DB自动关闭，重启DB时出现下面的错误信息。
错误信息如下：
Mon Aug 26 13:21:24 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 12
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=28, OS id=9818
Mon Aug 26 13:21:24 2013
Hex dump of (file 1, block 63916) in trace file /oracle/admin/fin/udump/fin_ora_9792.trc
Corrupt block relative dba: 0x0040f9ac (file 1, block 63916)
Bad check value found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x0040f9ac
last change scn: 0x0015.9f99441a seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x441a0601
check value in block header: 0x3480
computed block checksum: 0x80
Reread of rdba: 0x0040f9ac (file 1, block 63916) found same corrupted data
Mon Aug 26 13:21:24 2013
Errors in file /oracle/admin/fin/udump/fin_ora_9792.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-01578: ORACLE data block corrupted (file # 1, block # 63916)
ORA-01110: data file 1: '/oracle/oradata/fin/system01.dbf'
Mon Aug 26 13:21:24 2013
Errors in file /oracle/admin/fin/udump/fin_ora_9792.trc:
ORA-07445: exception encountered: core dump [kkttrex()+1365] [SIGSEGV] [Address not mapped to object] [0x000000074] [] []
Mon Aug 26 13:21:24 2013
db_recovery_file_dest_size of 20480 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
ORA-0 encountered when generating server alert SMG-3600
Mon Aug 26 13:21:25 2013
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 87 to scn 92920775437
Mon Aug 26 13:21:25 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.96.16
Block recovery completed at rba 17776.96.16, scn 21.2726462219
Mon Aug 26 13:21:25 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:25 2013
Errors in file /oracle/admin/fin/bdump/fin_mmon_9780.trc:
ORA-00604: error occurred at recursive SQL level 3
ORA-01578: ORACLE data block corrupted (file # 1, block # 63916)
ORA-01110: data file 1: '/oracle/oradata/fin/system01.dbf'
Mon Aug 26 13:21:25 2013
Errors in file /oracle/admin/fin/bdump/fin_mmon_9780.trc:
ORA-00604: error occurred at recursive SQL level 3
ORA-01578: ORACLE data block corrupted (file # 1, block # 63916)
ORA-01110: data file 1: '/oracle/oradata/fin/system01.dbf'
Mon Aug 26 13:21:26 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 96 to scn 92920775439
Mon Aug 26 13:21:27 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.97.16
Block recovery completed at rba 17776.97.16, scn 21.2726462223
Mon Aug 26 13:21:27 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:28 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 97 to scn 92920775441
Mon Aug 26 13:21:29 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.98.16
Block recovery completed at rba 17776.98.16, scn 21.2726462225
Mon Aug 26 13:21:29 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:30 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 98 to scn 92920775443
Mon Aug 26 13:21:31 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.99.16
Block recovery completed at rba 17776.99.16, scn 21.2726462227
Mon Aug 26 13:21:31 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:32 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 99 to scn 92920775445
Mon Aug 26 13:21:32 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.100.16
Block recovery completed at rba 17776.100.16, scn 21.2726462229
Mon Aug 26 13:21:32 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:43 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:44 2013
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 101 to scn 92920775451
Mon Aug 26 13:21:44 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.102.16
Block recovery completed at rba 17776.102.16, scn 21.2726462235
Mon Aug 26 13:21:44 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:54 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:21:55 2013
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 102 to scn 92920775455
Mon Aug 26 13:21:55 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.103.16
Block recovery completed at rba 17776.103.16, scn 21.2726462239
Mon Aug 26 13:21:55 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:22:05 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:22:05 2013
Doing block recovery for file 11 block 75
Block recovery from logseq 17776, block 103 to scn 92920775459
Mon Aug 26 13:22:05 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17776 Reading mem 0
  Mem# 0: /oracle/oradata/fin/redo01.log
Block recovery stopped at EOT rba 17776.104.16
Block recovery completed at rba 17776.104.16, scn 21.2726462243
Mon Aug 26 13:22:05 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:22:16 2013
Errors in file /oracle/admin/fin/bdump/fin_smon_9774.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [11], [75], [18038], [], [], [], []
Mon Aug 26 13:22:19 2013
Errors in file /oracle/admin/fin/bdump/fin_pmon_9756.trc:
ORA-00474: SMON process terminated with error
Mon Aug 26 13:22:19 2013
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 9756
2#
发表于 2013-8-26 16:06:02
新建一个undo 表空间 切换到新的表空间

回复 只看该作者 道具 举报

3#
发表于 2013-8-26 19:46:44
与其用 网盘 还不如压缩一下这个文件， 压缩后应当在 几百k

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-15 04:10 , Processed in 0.046776 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569