system表空间数据文件坏块故障处理

ALLSTARS_ORACLE

我是一名初级DBA，刚接手一个生产数据库，近期在日常巡检时发现alter报错如下：
Wed Nov 14 15:15:01 2012
Errors in file /ora_app/app/oracle/admin/SOC/bdump/soc_smon_4372.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 164756)
ORA-01110: data file 1: '/ora_data/oradata/SOC/system01.dbf'

后来我用dbv工具检测了一下，结果如下：

[oracle@nx ~]$ dbv FILE='/ora_data/oradata/SOC/system01.dbf'
DBVERIFY: Release 10.2.0.1.0 - Production on Sun Nov 18 15:41:39 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
DBVERIFY - Verification starting : FILE = /ora_data/oradata/SOC/system01.dbf
Page 155998 is marked corrupt
Corrupt block relative dba: 0x0042615e (file 1, block 155998)
Bad check value found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x0042615e
last change scn: 0x0000.08f33a7a seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x3a7a0601
check value in block header: 0x34e7
computed block checksum: 0x2ec2
Page 156380 is marked corrupt
Corrupt block relative dba: 0x004262dc (file 1, block 156380)
Bad check value found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x004262dc
last change scn: 0x0000.0934e71b seq: 0x3 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xe71b0603
check value in block header: 0x6a5b
computed block checksum: 0xd178
Page 164756 is marked corrupt
Corrupt block relative dba: 0x00428394 (file 1, block 164756)
Bad check value found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x00428394
last change scn: 0x0000.0917fd5b seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xfd5b0601
check value in block header: 0x7518
computed block checksum: 0x1e2f

DBVERIFY - Verification complete
Total Pages Examined         : 1048576
Total Pages Processed (Data) : 100747
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 97968
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1765
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 848093
Total Pages Marked Corrupt   : 3
Total Pages Influx           : 0
Highest block SCN            : 210041265 (0.210041265)

数据库是未归档，也没有备份，因为是生产库，数据量也较大，在此求助各位大侠，看看有什么比较好的策略解决这个问题？




我没用你提供的SQL语句去查，因为我有些没看懂，就用了下面最简单的方式查了一下，结果如下：

SQL> col OWNER for a10

SQL> col SEGMENT_NAME for a10

SQL> col TABLESPACE_NAME for a15

SQL> selectowner,segment_name,segment_type,tablespace_name from dba_extents where file_id= 1 and block_id between 164756 and block_id + blocks-1;

ERROR:

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

ORA-01110: data file 1:'/ora_data/oradata/SOC/system01.dbf'


no rows selected



SQL> selectowner,segment_name,segment_type,tablespace_name from dba_extents where file_id= 1 and block_id between 156380 and block_id + blocks-1;

ERROR:

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

ORA-01110: data file 1:'/ora_data/oradata/SOC/system01.dbf'


no rows selected



SQL> select owner,segment_name,segment_type,tablespace_namefrom dba_extents where file_id = 1 and block_id between 155998 and block_id +blocks-1;

ERROR:

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

ORA-01110: data file 1:'/ora_data/oradata/SOC/system01.dbf'

no rows selected