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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-27091:unable to queue I/O &OCR
- Qt5執行緒錯誤:QThread: Destroyed while thread is still running(執行runThread->exit(0))QT執行緒threadWhile
- 1002 Running Median
- Java 迴圈 - for, while 及 do…whileJavaWhile
- while迴圈以及do while迴圈While
- python while/forPythonWhile
- Java迴圈結構-for,while及do…whileJavaWhile
- Java while和do while迴圈詳解JavaWhile
- Java:運用while()與do....while與for()JavaWhile
- running-a-command-prompt-as-nt-authoritysystem
- Running Man-奔跑吧,勇士
- Laravel: Up and Running (1):介紹Laravel
- do-while語句和while的區別While
- Java 迴圈結構 - for, while 及 do...whileJavaWhile
- SCSS @while指令CSSWhile
- while迴圈While
- skipped: maximum number of running instances reached (1)
- Error running ‘Application’Command line is too longErrorAPP
- 榮耀手環4 Running版評測 榮耀手環4 Running版值得買嗎?
- C#練習,應用for,while,do-while迴圈C#While
- JavaScript while 語句JavaScriptWhile
- 四、python之 if while forPythonWhile
- [Bash] while & until commandsWhile
- PHP For & While 迴圈PHPWhile
- for while改變indexWhileIndex
- 善用 do-whileWhile
- python while迴圈PythonWhile
- python_while truePythonWhile
- Java基礎 迴圈語句 for while do.....while語句JavaWhile
- 【Mongo】使用killOp幹掉Long Running OperationGo
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- zabbix-server is not running 報錯解決Server
- While executing gem ... (Gem::FilePermissionError)WhileError
- JavaScript do while 語句JavaScriptWhile
- while迴圈補充While
- 【Linux shell】while read lineLinuxWhile
- python-while迴圈PythonWhile
- While True用法小例子While
- P1353 [USACO08JAN] Running S