Block corruption Oracle 10g Standard Edition RAC ASM

Hi people, I received this information in alert.log from a Oracle Release 10.2.0.4.0 Standard Edition over Windows 2003 (ARCHIVELOG, RAC and ASM)

See the attachment alert-xa211.log for complete info:
Fri Dec 27 20:05:54 2013
Errors in file e:\cots\oracle\product\10.2.0\admin\xa21\udump\xa211_ora_5304.trc:
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
ORA-19501: read error on file "+DATA/xa21/datafile/xa_hisr_hist_data_ts.278.705709643", blockno 1175745 (blocksize=8192)
ORA-27070: async read/write failed 

Open in new window

and
Fri Dec 27 20:05:54 2013
Errors in file e:\cots\oracle\product\10.2.0\admin\xa21\udump\xa211_ora_5304.trc:
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.

Open in new window

I know that lines is indicating some corruption of blocks.
I tried to do a "backup validate" from RMAN:
RMAN> backup validate tablespace xa_hisr_hist_data_ts;  

Open in new window

but failed, then I see:
Starting backup at 20-JAN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=124 instance=xa211 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00017 name=+DATA/xa21/datafile/xa_hisr_hist_data_ts.278.70570
9643
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/21/2014 04:50:
14
ORA-19501: read error on file "+DATA/xa21/datafile/xa_hisr_hist_data_ts.278.7057
09643", blockno 1175681 (blocksize=8192)
ORA-27070: async read/write failed

Open in new window

The daily RMAN backup failed too (see attachment)
Could you guide me to proceed with an alternative solution for the repair of these blocks?
Please tell me for obtain more logs and informacion files.
Regards
alert-xa211.log
alert-xa212.log
xa212-20131228-backup.log
xa212-20131228-exp.log
xa212-20131228-rman.log
carlino70Asked:
Who is Participating?
 
MikeOM_DBAConnect With a Mentor Commented:
You may need previous GOOD backup for that file and the archive logs necessary to recover it.

Another option is to try the DBMS_REPAIR package.

Caveat: If the block cannot be repaired, you can mark it "skip" with SKIP_CORRUPT_BLOCKS procedure -- BUT you loose the data in that block.

Good luck!
0
 
MikeOM_DBACommented:
You may need to recover that file from your backup.
0
 
carlino70Author Commented:
see please this lines in xa212-20131228-rman.log:
. . exporting table                  HIST_MMP_APPL
EXP-00056: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 17 (block # 1175781)
ORA-01110: data file 17: '+DATA/xa21/datafile/xa_hisr_hist_data_ts.278.705709643'
ORA-27070: async read/write failed

Open in new window

It is posible recover the datafile when the backup had failed?
0
 
carlino70Author Commented:
Thank you
0
 
carlino70Author Commented:
Mike, I tried to skip the corrupt blocks, but not work for me:

the error that I see after skip, when I do analyze on the table:

"ORA-01115: IO error reading block from file 17 (block # 1175779)"

Any idea?

Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.