In Oracle often block in file mark as corrupt when disk detect smart error.
Standalone server HP DL 380 G7 with ESXi 5.0.0 3086167
ESXi on SD card
Disk for System (RAID 1)
Disk for Data (RAID 5)
Disk for Backup (RAID 1)
And also 1 disk as spare disk for System and Data
In ESXi log only warning:
Device naa.600508b1001cd4ee56e9859ab06695ae performance has deteriorated. I/O latency
increased from average value of 6550 microseconds to 8922215 microseconds.
warning
In Guest OS (SUSE Sles 11 sp1)
[1594828.619684] mptscsih: ioc0: target reset: SUCCESS (sc=ffff880096add280)
[1594840.266679] mptscsih: ioc0: attempting target reset! (sc=ffff8800b4799e80)
[1594840.266684] sd 0:0:1:0: [sdb] CDB: Read(10): 28 00 23 a5 da a7 00 04 00 00
Why Oracle corrupted file/block and how we can fix it?
