ORA-01578的处理

某天一台数据库测试机出现 ORA-01578，虽说这是测试机但是这是客户用的，随便处理也不行，仔细研究一下。

ORA-01578: ORACLE data block corrupted (file # 2, block # 69449)

ORA-01110: data file 2: '/oracle/app/oradata/BOSS/sysaux01.dbf'

看看是在什么对象上

SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS WHERE file_id = 2 AND 69450 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;

用dbv看看能不能看到什么情况

dbv file =/oracle/app/oradata/BOSS/sysaux01.dbf

[14:26:30 oracle@SXWG]/home/oracle>dbv file =/oracle/app/oradata/BOSS/sysaux01.dbf

DBVERIFY: Release 11.2.0.3.0 - Production on Wed Nov 6 14:26:35 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /oracle/app/oradata/BOSS/sysaux01.dbf

DBV-00200: Block, DBA 8458057, already marked corrupt

DBVERIFY - Verification complete

Total Pages Examined         : 256000

Total Pages Processed (Data) : 36210

Total Pages Failing   (Data) : 0

Total Pages Processed (Index): 36703