ORA-27069: attempt to do I/O beyond the range of the file
                                                 Last update (2011-05-17 15:48:50)
                                                                                                                   Date added (2010-07-14 08:40:18)

Summary
Executing a query i get the message
ORA-12801: error signaled in parallel query server P032
ORA-01115: IO error reading block from file 26 (block # 1646734)
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 1646734
Additional information: 2
Additional information: 1496961
But this error is not recorded in the alert_log!

According to Oracle this is an internal error. The range of blocks being read or written is outside the range of the file, Additional information indicates the starting block number, number of blocks in I/O, and the last valid block in the file.

In my case:
Additional information: 1646734 (starting block number)
Additional information: 2 (number of blocks in I/O)
Additional information: 1496961 (last valid block in the file 26)

Workaround
Move datafile's objects to another tablespace and drop the tablespace with the problematic datafile. Usually there is not block corruption and the data blocks can be read!

Sometimes the error is related to the
Bug 8354642: INTERMITTENT ORA-01115/ORA-27091/ORA-27069 WHILE RUNNING RMAN BACKUPS

While running RMAN backups on a heavy loaded system, the following errors are intermittently reported:
ORA-19883: Unused Block Optimization stopped for datafile /oracle/DwhProd/oradata17/DWH01/snap03.dbf
ORA-01115: IO error reading block from file /oracle/DwhProd/oradata17/DWH01/snap03.dbf (block # 2871040)
ORA-27091: unable to queue I/O
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 2871040
Additional information: 1
Additional information: 2867841
The trace file show that is related to the specific bug
*** 2011-05-14 17:59:30.280
*** ACTION NAME:(0000065 STARTED16) 2011-05-14 17:59:30.269
*** MODULE NAME:(backup incr datafile) 2011-05-14 17:59:30.269
*** SERVICE NAME:(SYS$USERS) 2011-05-14 17:59:30.269
*** SESSION ID:(1754.1938) 2011-05-14 17:59:30.269
Bitmap 5 for file 3743 at block 2867840 of datafile 3743 has incorrect block type, expected: 30, got:6
Rereading bitmap 5 for file 3743 relocated at block 2871040 in datafile 3743
Backup Optimization context dump (krbodmpcx)
File is resized during backup and alert log shows that unused block optimization has been stopped due to an I/O error reading the bitmap!.

Note:
It is common to get errors like ORA-19883 ORA-1115 ORA-27091 and ORA-27069 in the alert log while running RMAN backup if a datafile in a locally managed tablespace (LMT) and is extended during backup like a datafile resize or autoextend.

You can apply patch 8354642. More info at:
INTERMITTENT ORA-01115 ORA-27091 ORA-27069 WHILE RUNNING BACKUPS [ID 1296217.1]
Reviews
Filters
Search