Oracle 在运行备份时间歇发生ORA-01115 ORA-27091 ORA-27069

如果自己搞不定可以找诗檀软件专业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: 30got:<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

*

沪ICP备14014813号-2

沪公网安备 31010802001379号