INTERMITTENT ORA-01115、27091、27069 WHILE RUNNING BACKUPS-1296217.1
In this Document
Applies to:
Oracle Server - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.
10.2.0.1 thru 10.2.0.5
Potentially 11.1
Fixed in 11.2
Symptoms
Any of the following errors are seen in the alert.log and/or trace files
Generic example from alert log:
- ORA-19883: Unused Block Optimization stopped for datafile
- ORA-01115: IO error reading block from file (block #
) - ORA-27091: unable to queue I/O
- ORA-27069: attempt to do I/O beyond the range of the file
- Additional information:
- Additional information: 1
- Additional information:
Also the trace file may show:
- "Error: Bitmap
for file at block of datafile
has incorrect block type, expected: 30, got:block type like 6>"
The errors can occur within any of several datafiles and tablespaces during the backups
...
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
Another symptom is evidence of TAIL BITMAP block optimization after the backup
*** 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)
You can find several key indicators in the Trace file
Bold indicates key identifiers or characteristics of the problem
*** 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
Cause
This problem is due to bug: 8354642
If there is an extension of a LMT datafile during a backup operation, you may find the bitmap used by LMT is incorrectly evaluated leading to
The error does not impact the backup: the problem is during the file size evaluation after the backup has completed and we attempt to determine the size of the datafile using incorrect information after the datafile extension and backup
Solution
FIX
The best is to go to 11.2 or higher
or if available apply a single-patch for 8354642
Workaround
One possible simple workaround is to pre-allocate extents in LMTs that may be likely to extend during a backup time window.
References
BUG:8354642 - INTERMITTENT ORA-01115/ORA-27091/ORA-27069 WHILE RUNNING RMAN BACKUPSNOTE:1088018.1 - Master Note for Handling Oracle Database Corruption Issues
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-753152/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Connected to an idle instance – while database is runningWhileDatabase
- Errors Ora-00202, Ora-27091 and Ora-27069 Appear in the alert log File-344764.1ErrorAPP
- Fixed the bug:while running alert/confirm in javascript the chrome freezesWhileJavaScriptChrome
- ORA-01115 ORA-01110 ORA-27091 ORA-27072 on AIX 5LAI
- 11.2.0.1 Grid Infrastructure Installation Failed at .... While Running root.shASTStructAIWhile
- ORA-01115 ORA-01110 ORA-27091 ORA-27072 問題解決方法
- ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error (Doc ID 559697.1)Error
- ORA-00604,ORA-01115,ORA-01110,ORA-27091,ORA-27072,IBM AIX RISC System/6000 ErrorIBMAIError
- Intermittent TNS Listener Hang, New Child Listener Process Forked [ID 340091.1]MIT
- Qt5執行緒錯誤:QThread: Destroyed while thread is still running(執行runThread->exit(0))QT執行緒threadWhile
- Java 迴圈 - for, while 及 do…whileJavaWhile
- while迴圈以及do while迴圈While
- Running the app on your deviceAPPdev
- Check the transaction running in oracleOracle
- Long running Operations in OracleOracle
- Java:運用while()與do....while與for()JavaWhile
- Java迴圈結構-for,while及do…whileJavaWhile
- Java while和do while迴圈詳解JavaWhile
- 應用程式報ORA-01115錯誤
- do-while語句和while的區別While
- Java 迴圈結構 - for, while 及 do...whileJavaWhile
- c# while-do while-foreach-if-gotoC#WhileGo
- python while/forPythonWhile
- SCSS @while指令CSSWhile
- while迴圈While
- Object-C,迴圈語句for,while,do-whileObjectWhile
- C#練習,應用for,while,do-while迴圈C#While
- Laravel: Up and Running (1):介紹Laravel
- How to CANCEL a query running in another session?Session
- PHP For & While 迴圈PHPWhile
- JavaScript while 語句JavaScriptWhile
- for while改變indexWhileIndex
- 善用 do-whileWhile
- ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file問題解決
- 榮耀手環4 Running版評測 榮耀手環4 Running版值得買嗎?
- Java基礎 迴圈語句 for while do.....while語句JavaWhile
- ORA-27069和OSD-4026錯誤引起資料庫CRASH資料庫
- running-a-command-prompt-as-nt-authoritysystem