RE: error

From: Dimensional DBA <dimensional.dba_at_comcast.net>
Date: Mon, 7 Mar 2016 12:05:14 -0800
Message-ID: <013601d178ac$afdd9ee0$0f98dca0$_at_comcast.net>

There are a lot of potential causes. Please see the following notes.  

ORA-1115: I/O ERROR READING BLOCK (Doc ID 1013621.6)

OERR: ORA-19883 "Unused Block Optimization stopped for datafile %s" Reference Note (Doc ID 2010633.1)  

Matthew Parker

Chief Technologist

Dimensional DBA

425-891-7934 (cell)

D&B 047931344

CAGE 7J5S7 Dimensional.dba_at_comcast.net

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn

www.dimensionaldba.com <http://www.dimensionaldba.com/>  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian
Sent: Monday, March 7, 2016 11:44 AM
To: oracle-l (oracle-l_at_freelists.org) Subject: error  

Ok, I just got this error in an email. I am fairly new to RAC so is this an error I need to fix? Or is it a runaway query type of error?  

prod2 oracle error found

199,201d198

< ORA-19883: Unused Block Optimization stopped for datafile
+PROD_DG1/prod/datafile/i_a_m002.269.717526953

< ORA-01115: IO error reading block from file
+PROD_DG1/prod/datafile/i_a_m002.269.717526953 (block # 3599834) <
ORA-17510: Attempt to do i/o beyond file size    

Brian  

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 07 2016 - 21:05:14 CET