如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
ORA-01115 oerr ora 1115 01115, 00000, "IO error reading block from file %s (block # %s)" // *Cause: Device on which the file resides is probably offline // *Action: Restore access to the device ORA-27091 oerr ora 27091 27091, 00000, "unable to queue I/O" // *Cause: read/write/readv/writev system call returned error, additional // information indicates starting block number of I/O // *Action: check errno ORA-27069 oerr ora 27069 27069, 00000, "attempt to do I/O beyond the range of the file" // *Cause: 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 // *Action: check for trace file and contact Oracle Support
适用于：
Oracle Database – Enterprise Edition –版本10.2.0.4及以上
本文信息适用于任何平台。
10.2.0.1 到 10.2.0.5
有可能 11.1
11.2中修正
症状
以下任一错误显示在alert.log 和/或 跟踪文件中
alert log中通用示例：
文件<trace file name>中错误:
- ORA-19883: Unused Block Optimization stopped for datafile <data file name>
- ORA-01115: IO error reading block from file <data file name> (block # <Block#>)
- ORA-27091: unable to queue I/O
- ORA-27069: attempt to do I/O beyond the range of the file
- Additional information: <Block#>
- Additional information: 1
- Additional information: <Incorrect last Block#>
跟踪文件也可能显示：
- “Error: Bitmap <bitmap#> for file <file#> at block <block#> of datafile <file#>
has incorrect block type, expected: 30, got:<different block type like 6>”
在备份时，该错误可能出现在任意几个数据文件和表空间中。
例如
…
ORA-01115: IO error reading block from file +MT_DATA_01/MT/datafile/abd.451.677765651 (block # 2899969)
ORA-17510: Attempt to do i/o beyond file size
另一个症状是备份后TAIL BITMAP块优化的证据
*** ACTION NAME:(0000145 STARTED16) 2010-12-30 23:09:54.192
*** MODULE NAME:(backup full datafile) 2010-12-30 23:09:54.192
*** SERVICE NAME:(abc_backup) 2010-12-30 23:09:54.192
…
…
Bitmap 2 for file xx at block xxxx of datafile …
Rereading bitmap…
Backup Optimization context dump (krbodmpcx)
你可以在跟踪文件中找到一些关键指标
粗体表示问题的关键标识符或特性
*** 2010-12-30 23:09:54.192
*** ACTION NAME:(0000145 STARTED16) 2010-12-30 23:09:54.192
*** MODULE NAME:(backup full datafile) 2010-12-30 23:09:54.192
*** SERVICE NAME:(abc_backup) 2010-12-30 23:09:54.192
*** SESSION ID:(939.28844) 2010-12-30 23:09:54.192
Bitmap 2 for file 179 at block 2891777 of datafile 179 has incorrect block type, expected: 30, got:6
Rereading bitmap 2 for file 179 relocated at block 2899969 in datafile 179
Backup Optimization context dump (krbodmpcx)
============================================
Information about file being optimized
Datafile name : +ABC_DATA_01/ABC/datafile/X2_idx_h1.451.677765651
Absolute file number : 179
Relative file number : 179
Tablespace number : 176
Tablespace blocksize : 16384
Tablespace is SFT : FALSE
Chkpoint SCN of datafile: 193955971853
Last block in backup : 2891776 <
Information about datafile holding bitmaps
Absolute file number : 179
Relative file number : 179
Chkpoint SCN bitmap file: 193955971853
Blocks mapped per bit : 4
Blocks mapped per byte : 32
Blocks mapped per bitmap: 516096
Bitmaps related information
Number of bitmaps used : 6
Number of head bitmaps : 2
Number of tail bitmaps : 4 <
Number of bitmaps read : 2
Space header related information
SCN of Space Header : 193956083782
Last deallocation scn : 170474335925
Last block in file : 2899972
Space header rel-fno(hc): 179
Size of file in blocks : 2899972
End of data blocks : 2899968 <969 reporting the ORA-1115 and ORA-17510
Max size of file : 3276804
Information about current bitmap
SCN bitmap : 172874328713
Current bitmap number : 2
Valid bitmap? : NO
First block in bitmap : 516101
Last block in bitmap : 1032196
First block in bytemap : 1032165
Statistics fields
Number of blocks read : 1030943
Number of unread blocks : 64
Status fields
All bitmaps processed? : NO
============================================
ORA-19883: Message 19883 not found; product=RDBMS; facility=ORA
; arguments: [+ABC_DATA_01…/X2_idx_h1.451.677765651]
ORA-01115: IO error reading block from file +ABC_DATA_01…/X2_idx_h1.451.677765651 (block # 2899969)
ORA-17510: Attempt to do i/o beyond file size
原因
该问题是由于 bug: 8354642
如果在备份操作时有LMT数据文件的控制，你可能发现LMT使用的位图被错误计算，导致
ORA-17510: Attempt to do i/o beyond file size error.
该错误不影响备份：问题发生在备份完成后的文件大小计算期间，且在数据文件扩展和备份后，我们使用不正确的信息来确定数据文件的大小
解决方案
修正
最好是到11.2或更高版本
或者如果有，对8354642应用单个补丁
参阅MOS文档ID12827745.8
解决方法
One possible simple workaround is to pre-allocate extents in LMTs that may be likely to extend during a backup time window.一种可能的简单解决方法是在可能会在备份时间窗口期间扩展的LMT中预分配extent。
参考
BUG:8354642 – INTERMITTENT ORA-01115/ORA-27091/ORA-27069 WHILE RUNNING RMAN BACKUPS
NOTE:1088018.1 – Master Note for Handling Oracle Database Corruption Issues
Comment