Home » RDBMS Server » Backup & Recovery » ORA-01115: IO error reading block from file 11 (block # 118736) (11g, 11.2.0.1, Windows server 2008)
ORA-01115: IO error reading block from file 11 (block # 118736) [message #584736] Fri, 17 May 2013 06:11 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

During the scheduled backup we observed that, backup got failed. Error is "ORA-01115: IO error reading block from file 11 (block # 118736)
".

unable to rectify it. Below are the part of log file -


ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [TABLE_DATA:"DW_REP"."DW_MOTOR_CLAIM_INFO_DTLS"]
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 8976
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 3329
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 14341
ORA-02354: error in exporting/importing data
ORA-01115: IO error reading block from file 11 (block # 118736)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1) Incorrect function.
ORA-01115: IO error reading block from file 11 (block # 118736)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1) Incorrect function.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8165
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
000007FF48E018B0     18990  package body SYS.KUPW$WORKER
000007FF48E018B0      8192  package body SYS.KUPW$WORKER
000007FF48E018B0      1703  package body SYS.KUPW$WORKER
000007FF4890BF58         2  anonymous block
Job "SYSTEM"."SYS_EXPORT_FULL_08" stopped due to fatal error at 04:21:40


This is development server. Dont have RMAN configured.

But when we connected to RMAN and issued block recovery, it started process and shows media recovery done. Since no RMAN backup was taken before, what it does here?

C:\Users\Administrator>RMAN

Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 17 10:48:40 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> CONNECT target /

connected to target database: MAGMADEV (DBID=2469200049)

RMAN> blockrecover datafile 11 block 118736;

Starting recover at 17/05/2013
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=573 device type=DISK

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 17/05/2013


Can any body tell me how to resolve this problem?

MOVE, ALTER shrink doesn't worked here.

Waiting for your reply...

Regards,
Ishika
Re: ORA-01115: IO error reading block from file 11 (block # 118736) [message #584760 is a reply to message #584736] Fri, 17 May 2013 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ Have you some backup of the file?
2/ Are you in archived log mode?
3/ Have you all archived logs since the backup of the file?

Regards
Michel

Re: ORA-01115: IO error reading block from file 11 (block # 118736) [message #585348 is a reply to message #584760] Thu, 23 May 2013 23:46 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel.

This is my test database. We have yesterday's backup.
1) Database is in no-archivelog mode.

After having discussion with team, we had import table of previous day's backup. After doing this problem got resolve but data loss occurred.

Regards,
Ishika
Re: ORA-01115: IO error reading block from file 11 (block # 118736) [message #585350 is a reply to message #585348] Fri, 24 May 2013 00:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you don't want to lose data, then enable archive mode
Re: ORA-01115: IO error reading block from file 11 (block # 118736) [message #585352 is a reply to message #585348] Fri, 24 May 2013 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
After doing this problem got resolve but data loss occurred


This is expected with an export/import, you lose all the work since the export.
This why, if don't want to lose anything, you have to enable archived log mode and use RMAN backup.

Regards
Michel
Re: ORA-01115: IO error reading block from file 11 (block # 118736) [message #585365 is a reply to message #585352] Fri, 24 May 2013 06:07 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

I agree with you. This is general test database. So, we haven't enable archivelog mode and RMAN.

This problem occurred during the expdp/impdp only.

Regards,
Ishika
Re: ORA-01115: IO error reading block from file 11 (block # 118736) [message #585398 is a reply to message #585365] Fri, 24 May 2013 10:44 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
So you have to accept and are ready to lose work.

Regards
Michel
Previous Topic: indexes of sysman
Next Topic: Database not working after backup got failed.
Goto Forum:
  


Current Time: Sat Nov 23 05:58:28 CST 2024