Re: hardware problem?
Date: Mon, 3 Nov 2008 19:11:24 +0000
Has the file been deleted by accident? - not sure but this might be the problem - if so DO NOT shutdown or reboot - export the tablespace.
2008/11/3 Dba DBA <oracledbaquestions_at_gmail.com>
> it happens when i try to create an index or run dbms_repair.
> On Mon, Nov 3, 2008 at 1:59 PM, Rich Jesse <
> rjoralist_at_society.servebeer.com> wrote:
>> Or your backups are not configured correctly and are attempting to backup
>> your live datafiles (which is useless for recovery) and/or are locking
>> as they are backed up.
>> Your SysAdmin should be able to check the Event log to confirm/deny the
>> hardware theory.
>> > i googled this. this looks like a hardware issue right?
>> > ERROR at line 1:
>> > ORA-01115: IO error reading block from file 12 (block # 546933)
>> > ORA-01110: data file 12:
>> > 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\CCDEV\USERS02.DBF'
>> > ORA-27091: unable to queue I/O
>> > ORA-27070: async read/write failed
>> > OSD-04006: ReadFile() failure, unable to read from file
>> > O/S-Error: (OS 121) The semaphore timeout period has expired.
>> > ORA-06512: at "SYS.DBMS_REPAIR", line 293
>> > ORA-06512: at line 1
-- Howard A. Latham -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 03 2008 - 13:11:24 CST