Solved

Block corruption Oracle 10g Standard Edition RAC ASM

Posted on 2014-01-21
5
836 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

717 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