oracle表坏块处理,求助，oracle有坏块，怎么处理，

检查alert

Thu Jun 30 06:42:17 2011

Hex dump of (file 83, block 7620) in trace file /oracle/base/admin/SZQX/udump/szqx_ora_6861.trc

Corrupt block relative dba: 0x14c01dc4 (file 83, block 7620)

Fractured block found during buffer read

Data in bad block:

type: 6 format: 2 rdba: 0x14c01dc4

last change scn: 0x0a41.2b8c8ea2 seq: 0x1 flg: 0x06

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

consistency value in tail: 0x3a1e0601

check value in block header: 0xb425

computed block checksum: 0xb0bc

Reread of rdba: 0x14c01dc4 (file 83, block 7620) found same corrupted data

Thu Jun 30 06:42:26 2011

Corrupt Block Found

TSN = 6, TSNAME = INDEXS

RFN = 83, BLK = 7620, RDBA = 348134852

OBJN = 51520, OBJD = 53168, OBJECT = IDX_CITYWFNEW_1, SUBOBJECT =

SEGMENT OWNER = SZIDC, SEGMENT TYPE = Index Segment

Thu Jun 30 06:44:29 2011

Hex dump of (file 83, block 7620) in trace file /oracle/base/admin/SZQX/udump/szqx_ora_7272.trc

Corrupt block relative dba: 0x14c01dc4 (file 83, block 7620)

Fractured block found during buffer read

Data in bad block:

type: 6 format: 2 rdba: 0x14c01dc4

last change scn: 0x0a41.2b8c8ea2 seq: 0x1 flg: 0x06

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

consistency value in tail: 0x3a1e0601

check value in block header: 0xb425

"alert_SZQX.log" 367680L, 15749941C                                                    365632,1      99%

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

consistency value in tail: 0x3a1e0601

check value in block header: 0xb425

computed block checksum: 0xb0bc

Reread of rdba: 0x14c01dc4 (file 83, block 7620) found same corrupted data

Thu Jun 30 11:35:02 2011

SQL>  select * from dba_extents where file_id=83 and 7620 between block_id and block_id+blocks-1;

OWNER                          SEGMENT_NAME         PARTITION_ SEGMENT_TYPE       TABLESPACE_NAME              EXTENT_ID    FILE_ID    BLOCK_ID      BYTES     BLOCKS RELATIVE_FNO

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

SZIDC                          IDX_CITYWFNEW_1                 INDEX              INDEXS                      15          83       7561    1048576        128           83

数据库没有备份，重建index怎么写呀？下面写法有没有问题？

alter index SZIDC.IDX_CIYWFNEW_1 rebuild online parallel 16 tablespace INDEXS nologging;

parallel 16是什么意思？ tablespace indexs nologging是什么意思？

如果重做完了后怎么查看是否恢复正常了。

具体怎么处理，请大侠指导，谢谢！

[本帖最后由 FROG2611 于 2011-6-30 12:34 编辑]