本帖最后由 eavin_wang 于 2013-9-27 14:35 编辑

问题：数据库被一同事shutdown abort后，无法启动，报错如下：

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [4193], [3422], [3470], [], [], [], [], []

Current SQL statement for this session:

update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1

我的操作：

因为没备份，不能直接恢复；

1)加隐含参数，等都试过，还是无法跳过坏块；

报错如下：

Thu Sep 12 20:37:38 CST 2013

Errors in file /opt/oracle/admin/orcl/udump/orcl_ora_6754.trc:

ORA-00600: internal error code, arguments: [4193], [3422], [3470], [], [], [], [], []

Thu Sep 12 20:37:42 CST 2013

Doing block recovery for file 1 block 11

Resuming block recovery (PMON) for file 1 block 11

Block recovery from logseq 6, block 3 to scn 223208881779

2)用bbed将(file # 1, block # 11)设置为坏块： seq: 0xff，修改tailchk

但启动的时候还是报错：

ORA-01578: ORACLE data block corrupted (file # 1, block # 11)

ORA-01110: data file 1: '/opt/oracle/oradata/orcl/system01.dbf'

为什么设置了(file # 1, block # 11)为坏块，数据库还是无法跳过呢？

下面是相关信息，请各位帮我看看：

1、 OS

Linux orcl 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

2、db

SQL>  startup mount pfile='/u01/oracle/rdb0912/pf0926.ora';

ORACLE instance started.

Total System Global Area 2516582400 bytes

Fixed Size                    2098368 bytes

Variable Size                  536873792 bytes

Database Buffers         1962934272 bytes

Redo Buffers                   14675968 bytes

Database mounted.

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

PL/SQL Release 10.2.0.5.0 - Production

CORE        10.2.0.5.0        Production

TNS for Linux: Version 10.2.0.5.0 - Production

NLSRTL Version 10.2.0.5.0 - Production

SQL>

3，alert log

Hex dump of (file 1, block 11) in trace file /opt/oracle/admin/orcl/udump/orcl_ora_24126.trc

Corrupt block relative dba: 0x0040000b (file 1, block 11)

Bad check value found during buffer read

Data in bad block:

type: 2 format: 2 rdba: 0x0040000b

last change scn: 0x0033.f847b6e3 seq: 0xff flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0xb6e302ff

check value in block header: 0x9fe1

computed block checksum: 0x515e

Reread of rdba: 0x0040000b (file 1, block 11) found same corrupted data

Fri Sep 27 13:19:16 CST 2013

Errors in file /opt/oracle/admin/orcl/udump/orcl_ora_24126.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file # 1, block # 11)

ORA-01110: data file 1: '/opt/oracle/oradata/orcl/system01.dbf'

Error 604 happened during db open, shutting down database

USER: terminating instance due to error 604

Instance terminated by USER, pid = 24126

ORA-1092 signalled during: ALTER DATABASE OPEN...

4，orcl_ora_24126.trc

[oracle@orcl rdb0912]$ more /opt/oracle/admin/orcl/udump/orcl_ora_24126.trc

/opt/oracle/admin/orcl/udump/orcl_ora_24126.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /opt/oracle/product/10.2.0/db

System name:        Linux

Node name:        orcl

Release:        2.6.18-164.el5

Version:        #1 SMP Tue Aug 18 15:51:48 EDT 2009

Machine:        x86_64

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 15

Unix process pid: 24126, image: oracle@orcl (TNS V1-V3)

*** ACTION NAME

) 2013-09-27 13:19:15.506

*** MODULE NAME

sqlplus@orcl (TNS V1-V3)) 2013-09-27 13:19:15.506

*** SERVICE NAME

) 2013-09-27 13:19:15.506

*** SESSION ID

544.3) 2013-09-27 13:19:15.506

Successfully allocated 7 recovery slaves

Using 158 overflow buffers per recovery slave

Thread 1 checkpoint: logseq 1, block 2, scn 223209682091

start recovery at logseq 1, block 2, scn 223209682091

----- Redo read statistics for thread 1 -----

Read rate (ASYNC): 0Kb in 0.03s => 0.02 Mb/sec

Total physical reads: 4096Kb

Longest record: 0Kb, moves: 0/1 (0%)

Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb

Last redo scn: 0x0033.f85574ac (223209682092)

----------------------------------------------

----- Recovery Hash Table Statistics ---------

Hash table buckets = 32768

Longest hash chain = 0

Average hash chain = 0/0 = 0.0

Max compares per lookup = 0

Avg compares per lookup = 0/0 = 0.0

----------------------------------------------

*** 2013-09-27 13:19:15.643

KCRA: start recovery claims for 0 data blocks

*** 2013-09-27 13:19:15.644

KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0

*** 2013-09-27 13:19:15.651

Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0

*** 2013-09-27 13:19:15.651

Completed redo application

*** 2013-09-27 13:19:15.651

Completed recovery checkpoint

----- Recovery Hash Table Statistics ---------

Hash table buckets = 32768

Longest hash chain = 0

Average hash chain = 0/0 = 0.0

Max compares per lookup = 0

Avg compares per lookup = 0/0 = 0.0

----------------------------------------------

Hex dump of (file 1, block 11)

Dump of memory from 0x00000000D5F50000 to 0x00000000D5F52000

0D5F50000 0000A202 0040000B F847B6E3 04FF0033  [......@...G.3...]

0D5F50010 00009FE1 00270000 000020E4 1F1F0D5E  [......'.. ..^...]

0D5F50020 1FE80000 1DE81EE8 1BE81CE8 19E81AE8  [................]

0D5F50030 17E818E8 15E816E8 13E814E8 11E812E8  [................]

0D5F50040 0FE810E8 0DE80EE8 0BE80CE8 09E80AE8  [................]

0D5F50050 07E808E8 05E806E8 03E804E8 01E802E8  [................]

0D5F50060 000000E8 00000000 00000000 00000000  [................]

0D5F50070 00000000 00000000 00000000 00000000  [................]

Repeat 7 times

0D5F500F0 00000000 00000000 00000000 00480022  [............".H.]

0D5F50100 001E0020 000A0018 00020002 00060004  [ ...............]

0D5F50110 00040002 00010003 00020002 00000002  [................]

0D5F50120 0000000F 0000000F 00000000 00000000  [................]

0D5F50130 0027010B 00010408 0040000B 001E0D5E  [..'.......@.^...]

0D5F50140 F847B54C 00000033 F847B54D 00000033  [L.G.3...M.G.3...]

0D5F50150 00000000 F847B6E3 24EF0033 01800ED7  [......G.3..$....]

0D5F50160 00000000 00000000 00000104 00000000  [................]

0D5F50170 00040000 000020E4 0040000B 001D0D5E  [..... ....@.^...]

0D5F50180 00338000 F847B6DA 0040006A 00400069  [..3...G.j.@.i.@.]

0D5F50190 010512FF 00000002 0000002C 0C110014  [........,.......]

0D5F501A0 00000000 00000000 00020001 00040003  [................]

0D5F501B0 00060005 00080007 000A0009 0010000B  [................]

0D5F501C0 5359535F 32554D53 00002430 000002C1  [_SYSSMU20$......]

0D5F501D0 000009C1 4A3102C3 3F5D29C5 00002202  [......1J.)]?."..]

0D5F501E0 000034C1 241804C3 00595FC2 00000080  [.4.....$._Y.....]

0D5F501F0 000007C1 000002C1 000002C1 00480022  [............".H.]

0D5F50200 001E0020 000A0018 00020002 00060004  [ ...............]

0D5F50210 00040002 00010003 00020002 00000002  [................]

0D5F50220 0000000F 0000000F 00000000 00000000  [................]

0D5F50230 002A010B 00010408 0040000B 001D0D5E  [..*.......@.^...]

。。。。。

0D5F51F90 010512FF 00000002 0000002C 0C110014  [........,.......]

0D5F51FA0 00000000 00000000 00020001 00040003  [................]

0D5F51FB0 00060005 00080007 000A0009 0010000B  [................]

0D5F51FC0 5359535F 32554D53 00002430 000002C1  [_SYSSMU20$......]

0D5F51FD0 000009C1 4A3102C3 3F5D29C5 00002202  [......1J.)]?."..]

0D5F51FE0 000034C1 241804C3 00595FC2 00000080  [.4.....$._Y.....]

0D5F51FF0 000007C1 000002C1 000002C1 B6E302FF  [................]

Corrupt block relative dba: 0x0040000b (file 1, block 11)

Bad check value found during buffer read

Data in bad block:

type: 2 format: 2 rdba: 0x0040000b

last change scn: 0x0033.f847b6e3 seq: 0xff flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0xb6e302ff

check value in block header: 0x9fe1

computed block checksum: 0x515e

Reread of rdba: 0x0040000b (file 1, block 11) found same corrupted data

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file # 1, block # 11)

ORA-01110: data file 1: '/opt/oracle/oradata/orcl/system01.dbf'