Oracle数据库坏块

shawnephay

导入数据的时候,发现oracle数据库有坏块,请问通过alert文件和trc文件能否定位出，是逻辑的坏块还是物理硬盘坏块？（alert和trc文件件附件）
谢谢。

Liu Maclean(刘相兵

1. Corrupt block relative dba: 0x19440773 (file 101, block 264051)
   
2. Fractured block found during buffer read
   
3. Data in bad block:
   
4. type: 6 format: 2 rdba: 0x19440773
   
5. last change scn: 0x0000.2d777353 seq: 0x1 flg: 0x06
   
6. spare1: 0x0 spare2: 0x0 spare3: 0x0
   
7. consistency value in tail: 0x30373030
   
8. check value in block header: 0xf806
   
9. computed block checksum: 0xee54
   
10. Reading datafile '/oradata/ldrk/LDRK_JB_IDX01.dbf' for corruption at rdba: 0x19440773 (file 101, block 264051)
    
11. Reread (file 101, block 264051) found same corrupt data (no logical check)
    
12. Sat Dec 15 08:27:46 2012
    
13. Corrupt Block Found
    
14.          TSN = 25, TSNAME = LDRK_JB_IDX
    
15.          RFN = 101, BLK = 264051, RDBA = 423888755
    
16.          OBJN = 83804, OBJD = 83804, OBJECT = IDX_RKJB_SFZH_BL1, SUBOBJECT =
    
17.          SEGMENT OWNER = LDRK, SEGMENT TYPE = Index Segment
    
18. Errors in file /oracle/diag/rdbms/ldrk/ldrk/trace/ldrk_ora_6815942.trc  (incident=80739):
    
19. ORA-01578: ORACLE 数据块损坏 (文件号 101, 块号 264051)
    
20. ORA-01110: 数据文件 101: '/oradata/ldrk/LDRK_JB_IDX01.dbf'
    
21. Sat Dec 15 08:27:47 2012
    
22. Sweep [inc][80739]: completed
    
23. Hex dump of (file 101, block 264051) in trace file /oracle/diag/rdbms/ldrk/ldrk/trace/ldrk_m001_4195202.trc
    
24. Corrupt block relative dba: 0x19440773 (file 101, block 264051)
    
25. Fractured block found during validation

复制代码

比较明确的物理讹误

请参考 利用RMAN检测数据库坏块的脚本 http://www.askmaclean.com/archiv ... orrupted-block.html

对全库做物理坏块检测， 并考虑recover