Solved

Block corruption Oracle 10g Standard Edition RAC ASM

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 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.

743 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now