datafile 有坏块，但是查不出块上的对象...

ALLSTARS_ORACLE

看起来时是个索引块问题,尝试通过block recover 來恢复了，但是备份似乎太新了。。 想重建对象来着，但是查询不到对象...尝试过备份数据文件沒有报任何错误.


D:\backup>dbv file='D:\APP\ORADATA\DATAFILES\DW02.DBF' blocksize=8192

DBVERIFY: Release 11.2.0.3.0 - Production on Sat Oct 3 14:28:03 2015

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

DBVERIFY - Verification starting : FILE = D:\APP\ORADATA\DATAFILES\DW02.DBF

DBV-00200: Block, DBA 41877816, already marked corrupt
csc(0x0ceb.3746dbf7) higher than block scn(0x0000.00000000)
Page 4129080 failed with check code 6054


DBVERIFY - Verification complete

Total Pages Examined         : 4188160
Total Pages Processed (Data) : 819454
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 3362707
Total Pages Failing   (Index): 1
Total Pages Processed (Other): 4766
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 1233
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 3117068277 (3307.3117068277)


select * from v$database_block_corruption;

FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTION_TYPE
------ ---------- ---------- ------------------ ------------------
     9    4129080          1                  0 FRACTURED

SQL> select tablespace_name,segment_type,owner,segment_name from dba_extents where file_id=9 and 4129080 between block_id AND block_id + blocks - 1;

未选定行

沒招了，请求协助...

ALLSTARS_ORACLE

看了一条ORACLE解释:

39 DBV-00200 to DBV-00201

DBV-00200: Block, DBA number, already marked corrupt
    Cause: The block was previously corrupted. It has been marked as corrupt by the Oracle database server.
    Action: If the block is not currently allocated to a database object, then no action is required. If the block is allocated, then the options and required action depend on the type and nature of the object which owns the block. To repair an allocated block, perform block or file media recovery.

DBV-00201: Block, DBA number, marked corrupt for invalid redo application
    Cause: The block was marked corrupt by the Oracle database server for invalid redo application, ex: media recovery of a NOLOGGING object or direct loaded data.
    Action: If the block is not currently allocated to a database object, then no action is required. If the block is allocated, then the object will need to be rebuilt, or data to be reloaded.

看來不需要做任何操作?