Monday, 4 June 2018

ORA-01115 ORA-27072 : I/O error reading block from file | Oracle Database

ORA-01115: IO error reading block from file | ORA-27072: File I/O error


How to resolve ORA-01115 | ORA-01110 | ORA-27072 Oracle Errors? Why am I getting Oracle 01115, 01110, 27072 Errors and how to solve the same?

ORA-01115 | ORA-01110 | ORA-27072 Oracle Errors


I was simply trying to create a table when I got the below mentioned errors.

SQL> CREATE TABLE tab1 (id NUMBER) TABLESPACE USERS;
CREATE TABLE tab1 (id NUMBER) TABLESPACE USERS
*
ERROR at line 1:
ORA-01115: IO error reading block from file 4 (block # 3)
ORA-01110: data file 4: '/u01/app/oracle/oradata/ORADB11G/users01.dbf'
ORA-27072: File I/O error
Additional information: 4
Additional information: 2

Cause: 

Normally you can get ORA-01115 in any of the below mentioned scenarios,

1) Your datafile/tablespace is offline.
2) Your datafile is corrupt.
3) Your datafile is missing.

Also ORA-27072 also points to the above mentioned reasons where it is simply stating that Oracle is unable to fetch/Store information from/to the physical file.

Solution:

1) If the tablespace/datafile is OFFLINE, below mentioned queries will help you bring it ONLINE.

ALTER TABLESPACE users ONLINE;

ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' ONLINE;

Know more about Managing Tablespaces Availability  OR Managing Datafile Availability

2) If the datafile is corrupt/delete.

You can check if there is any type of physical damage/corruption to your database from below mentioned 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)
I hope this helps !!

No comments:

Post a comment