Re: hardware problem?

From: Howard Latham <howard.latham_at_gmail.com>
Date: Mon, 3 Nov 2008 19:11:24 +0000
Message-ID: <713d96d10811031111t6b2a560ey60a42232e454e858@mail.gmail.com>


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
>> files
>> as they are backed up.
>>
>> Your SysAdmin should be able to check the Event log to confirm/deny the
>> hardware theory.
>>
>> GL!
>>
>> Rich
>>
>> > 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
>> >
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

-- 
Howard A. Latham

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 03 2008 - 13:11:24 CST

Original text of this message