oracle断电 ora01110,异常断电，出现ORA-00600

本帖最后由 yinlenc 于 2012-5-4 10:38 编辑

(转看 7楼)

异常断电，出现ORA-00600: internal error code, arguments: [4194], [20], [26],

只有用sys用户登录，其他用户不能登录

alert log如下：

Completed: ALTER DATABASE OPEN

Fri May  4 10:02:20 2012

Hex dump of (file 3, block 30723) in trace file /home/oracle/admin/group/bdump/group_j000_21822.trc

Corrupt block relative dba: 0x00c07803 (file 3, block 30723)

Fractured block found during buffer read

Data in bad block:

type: 6 format: 2 rdba: 0x00c07803

last change scn: 0x0000.012dd14e seq: 0x2 flg: 0x06

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

consistency value in tail: 0xd5310601

check value in block header: 0xb1ce

computed block checksum: 0x47c

Reread of rdba: 0x00c07803 (file 3, block 30723) found same corrupted data

Fri May  4 10:02:20 2012

Errors in file /home/oracle/admin/group/bdump/group_j000_21822.trc:

ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []

ORA-01578: ORACLE data block corrupted (file # 3, block # 30723)

ORA-01110: data file 3: '/home/oracle/oradata/group/sysaux01.dbf'

DEBUG: Replaying xcb 0x42dfc304, pmd 0x42faa56c for failed op 8

Doing block recovery for file 2 block 2574

Block recovery from logseq 512, block 64 to scn 19967201

Fri May  4 10:02:20 2012

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

Mem# 0 errs 0: /home/oracle/oradata/group/redo01.log

Block recovery completed at rba 512.73.16, scn 0.19967203

Fri May  4 10:03:11 2012

Errors in file /home/oracle/admin/group/bdump/group_j000_21822.trc:

ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []

ORA-01578: ORACLE data block corrupted (file # 3, block # 30723)

ORA-01110: data file 3: '/home/oracle/oradata/group/sysaux01.dbf'

Fri May  4 10:03:11 2012

Errors in file /home/oracle/admin/group/bdump/group_j000_21822.trc:

ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []

ORA-01578: ORACLE data block corrupted (file # 3, block # 30723)

ORA-01110: data file 3: '/home/oracle/oradata/group/sysaux01.dbf'

接下来，怎么办？？？