数据库启动报错ora-3113

显示全部楼层 · 2007-9-26 18:42:10

今天一台数据库启动时
报错
ORA-3113 "end of file on communication channel"
大侠门怎么回事啊?
alter log里的内容
alter database open
Fri Apr 27 10:57:59 2007
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Apr 27 10:57:59 2007
Started redo scan
Fri Apr 27 10:57:59 2007
Completed redo scan
10832 redo blocks read, 197 data blocks need recovery
Fri Apr 27 10:57:59 2007
Started redo application at
Thread 1: logseq 1106, block 36758
Fri Apr 27 10:57:59 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1106 Reading mem 0
Mem# 0 errs 0: /opt/app/oracle/oradata/ORADB/redo01.log
Fri Apr 27 10:57:59 2007
Hex dump of (file 1, block 14712) in trace file /opt/app/oracle/admin/ORADB/bdump/oradb_p000_1771.trc
Corrupt block relative dba: 0x00403978 (file 1, block 14712)
Bad header found during crash/instance recovery
Data in bad block:
type: 6 format: 6 rdba: 0x0000a206
last change scn: 0x4b33.00403978 seq: 0xf4 flg: 0x01
spare1: 0x2f spare2: 0x4b spare3: 0x401
consistency value in tail: 0x3258c203
check value in block header: 0x0
block checksum disabled
Reread of rdba: 0x00403978 (file 1, block 14712) found same corrupted data
Fri Apr 27 10:57:59 2007
Completed redo application
Fri Apr 27 10:57:59 2007
Hex dump of (file 2, block 2) in trace file /opt/app/oracle/admin/ORADB/bdump/oradb_dbw0_29123.trc
Corrupt block relative dba: 0x00800002 (file 2, block 2)
Bad header found during preparing block for write
Data in bad block:
type: 25 format: 3 rdba: 0x00020000
last change scn: 0x01f4.4b190080 seq: 0x0 flg: 0x00
spare1: 0x1d spare2: 0xa2 spare3: 0x0
consistency value in tail: 0x1d020000
check value in block header: 0x2
block checksum disabled
Fri Apr 27 13:32:10 2007
Starting ORACLE instance (normal)
Fri Apr 27 13:32:10 2007
System parameter db_block_buffers enabled without VLM on.

千问 · 2007-9-26 18:42:10

alert log & related trace file

千问 · 2007-9-26 18:42:10

大家帮帮忙吧
alter database open的时候报错
貌似时trc文件有损坏??

千问 · 2007-9-26 18:42:10

自己
顶
等好心人...

千问 · 2007-9-26 18:42:10

有坏块,说的很清楚了.

千问 · 2007-9-26 18:42:10

楼上
的
怎么解决??

千问 · 2007-9-26 18:42:10

Reread of rdba: 0x00403978 (file 1, block 14712) found same corrupted data
注意看这里。

千问 · 2007-9-26 18:42:10

恢复
如果用rman做过备份的话那就更容易处理一些

千问 · 2007-9-26 18:42:10

楼上的
想
说明什么?
新手啊,多帮忙哈

千问 · 2007-9-26 18:42:10

晕啊
现在的alter_log中
出现了ora-600的内部错误...
Completed: alter database mount
Fri Apr 27 16:09:19 2007
alter database open
Fri Apr 27 16:09:20 2007
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Apr 27 16:09:20 2007
Started redo scan
Fri Apr 27 16:09:20 2007
Completed redo scan
10832 redo blocks read, 197 data blocks need recovery
Fri Apr 27 16:09:20 2007
Started redo application at
Thread 1: logseq 1106, block 36758
Fri Apr 27 16:09:20 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1106 Reading mem 0
Mem# 0 errs 0: /opt/app/oracle/oradata/ORADB/redo01.log
Fri Apr 27 16:09:20 2007
Completed redo application
Fri Apr 27 16:09:20 2007
Errors in file /opt/app/oracle/admin/ORADB/bdump/oradb_p001_6301.trc:
ORA-00600: internal error code, arguments: [2037], [12650165], [112525312], [71], [44], [0], [1199898817], [101909185]

怎么办??