3 Ways To Fix ORA-01115 : IO Error Reading Block From File
Summary:
This tutorial helps you to acquire knowledge on what’s this Oracle error ORA-01115 is and causes behind its frequent occurence. So Just scroll down to this post to know how to get rid of this ORA-01115 : IO error reading block from file.
What’s This ORA-01115 : IO Error Reading Block From File Is?
Oracle is a Relational Database Management System from the oracle corporation. This is one of the trusted and widely used base relational database systems. This system is built in a way that data objects can be directly accessed by users through structured query language. Oracle is fully scalable relational database architecture which is used by global enterprises which manage and process data across wide and local area network. The purpose of this database is to restore and retrieve related information.
In spite of having so many catchy features, this database also gets stuck into annoying error like ‘ORA-01115: IO error reading block from file (block #)’.
However, the root cause of the above ORA-01115 oracle error is that you are trying to connect with the user that doesn’t belong to dba, asmadmin, oper etc Operating System group.
When the Oracle file failed to read a data block from an open data file then it shows an error like ORA-01115. So before you think about any database issue, it is instructed to check the error message stacks seen before and after the ORA-01115 error in the database.
Although there can be several other reasons for such type of error when comparing the same error over the net or the previous occurrence. No matter whatever the reasons are, it is really very important to check the issue by looking at the other error messages which is represented with the same error.
What Are The Reasons Of ORA-01115 Error: IO Error Reading Block From File?
Before getting into the solution section, it is important to know the reasons for such error. Mentioned below are the common reasons for ORA-01115 Error: IO Error Reading Block From File.
- The Oracle error 01115 also occurs when the datafile or tablespace is offline.
- When the datafile goes missing.
- Database might have lost communication with the underlying ASM instance
- Can be caused by any hardware problems
- Physical data block corruption at the storage level
- A Oracle BUG
- Oracle datafile is corrupt.
- this error can also occur when you attempt to write in the file but the device having the file is either goes offline or running out of space. Mainly this happen because the temporary file is not allocated at the time of creation.
How To Fix ORA-01115 : IO Error Reading Block From File?
Method 1# Fix Tablespace/Datafile OFFLINE issue
If your datafile/tablespace is showing OFFLINE then try the below given queries to bring it back to ONLINE status.
ALTER TABLESPACE users ONLINE;
ALTER DATABASE DATAFILE ‘/u02/oracle/rbdb1/stuff01.dbf’ ONLINE;
Method 2# Resolve Data File Corruption Issue
As I have already mentioned that among various causes of getting Oracle IO Error Reading Block From File one reason can be the data file corruption or damage.
So just check whether your datafile is got corrupted or damaged with the following methods:
- RMAN LIST/ADVICE/REPAIR FAILURE (Display failure issues with status OPEN giving priority to HIGH critical issues. If not found, displays the LOW priority issues)
- RMAN VALIDATE
- Health Monitor (DBMS_HM Package inside Oracle Database)
Method 3# Try Professional Recommended Option
To fix error ORA-01115: IO error reading block from file in Oracle, it is better to use the third party tool which can help you to fix the error of Oracle and can restore the corrupted data.
It is better to use Oracle Repair Tool which is powerful and comprehensive data recovery software that is designed to restore the corrupted or damaged Oracle database file.
- In case sudden database fails, then Oracle Repair Tool meets this requirement perfectly.
- This software searches the entire Oracle databases that is present in the system and also shows the preview of recoverable database objects.
- It restores data from both database and backup files.
- Moreover this software saves recovered data as Transact-SQL script.
- Oracle Repair Tool is easy to use and it does not require any special skills.
Step To Use Oracle Repair Tool
1: Search Initial screen of Oracle Repair Tool with a pop-up window showing options to select or search corrupt Oracle databases in your computer.
2: Click Scan File to initiate the scan process after selecting the oracle database. The recoverable database objects get listed in left-side pane.
3: Click an object to see its preview.
4: : Click Start Repair in the icon bar to start the repair process. A pop-up window is displayed which show the steps needed to perform further. Click next and continue.
5: Give the user name, password and path of the blank database where you want to save the repaired database objects. 6: Repairing and restoring various database objects after establishing a connection with blank oracle database.
Always keep updated backup of your Oracle database so that when such 01115 error put your crucial data at risk you can easily restore it back.
Different methods are mentioned in this blog to fix ora-01115 error or you can use the alternative methods to retrieve corrupted/ deleted Oracle datafile.
As the recommended recovery software ensure guaranteed recovery of oracle database files. It works with all versions of Windows and well compatible with entire Oracle version.
Jacob Martin is a technology enthusiast having experience of more than 4 years with great interest in database administration. He is expertise in related subjects like SQL database, Access, Oracle & others. Jacob has Master of Science (M.S) degree from the University of Dallas. He loves to write and provide solutions to people on database repair. Apart from this, he also loves to visit different countries in free time.