Re: hardware problem?

  • From: "Howard Latham" <howard.latham@xxxxxxxxx>
  • To: oracledbaquestions@xxxxxxxxx
  • 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@xxxxxxxxx>

> 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@xxxxxxxxxxxxxxxxxxxxx> 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
>> >
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>


-- 
Howard A. Latham

Other related posts: