Q

Input/output errors

I have the following error:

ERROR at line 1:
ORA-01115: IO error reading block from file 2 (block # 2772)
ORA-01110: data file 2: '/home5/oracle/oradata/lrec_ts_files/lrec.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2771

I have the following error:

ERROR at line 1:
ORA-01115: IO error reading block from file 2 (block # 2772)
ORA-01110: data file 2: '/home5/oracle/oradata/lrec_ts_files/lrec.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2771
It looks to me like the database is having problems performing I/O on the file '/home5/oracle/oradata/lrec_ts_files/lrec.dbf.' There are a few causes for this.

  1. The OS cannot perform I/O on the disk volume. Try the following:

       cd /home5/oracle/oradata/lrec_ts_files
       ls -l
    

    If you can do a directory listing, then the OS can see this volume just fine. If not, then you will have to resolve the OS issue as this is not a database problem.

  2. The datafile is bad for some reason. You can use the dbverify utility to see if the datafile is corrupt. If the datafile is bad, restore it from a backup.
  3. There is a bad spot on your disk. The dbverify utility should report this condition.
This was first published in August 2005

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close