Solved

Block corruption Oracle 10g Standard Edition RAC ASM

Posted on 2014-01-21
5
824 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
exp/imp 25 101
create a nested synonym 4 41
Oracle Insert not working 10 48
sql server store procedure contains temp tables need to convert oracle? 3 38
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

730 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