ORA-01115: IO error reading block from file 11 (block # 118736) [message #584736] |
Fri, 17 May 2013 06:11 |
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
|
|
|
|
|
|
|
|
|