?
Solved

Block corruption Oracle 10g Standard Edition RAC ASM

Posted on 2014-01-21
5
Medium Priority
?
863 Views
Last Modified: 2014-03-27
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
0
Comment
Question by:carlino70
  • 3
  • 2
5 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39797772
You may need to recover that file from your backup.
0
 

Author Comment

by:carlino70
ID: 39797977
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
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 2000 total points
ID: 39798324
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
 

Author Closing Comment

by:carlino70
ID: 39799583
Thank you
0
 

Author Comment

by:carlino70
ID: 39960130
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question