ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file問題解決
Subject: | DB <9.2.0.3 Cannot AUTOEXTEND to 4Gb boundary in NT | |||
Doc ID: | Note:317174.1 | Type: | PROBLEM | |
Last Revision Date: | 02-AUG-2005 | Status: | MODERATED |
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1.0Microsoft Windows (32-bit)
Symptoms
When a datafile has been configured such that it will autoextend onto a 4GB boundary, any attempt to autoextend the file causes the file the database to crash (when in noarchive log mode). If the database was in archive log mode,will be marked offline recover and access to the database continues.
The following error appears in the alert.log :
.
KCF: write/open error block=0x32002 online=1
file=11 'E:ORACLEORA92BORGMAXIMO.ORA'
error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)'
Automatic datafile offline due to write error on
file 11: 'E:ORACLEORA92BORGMAXIMO.ORA'
.
Any attempt to online / recover this file results in :
.
ORA-283: recovery session canceled due to errors
ORA-1115: IO error reading block from file 11 (block # 204802)
ORA-1110: data file 11: 'E:ORACLEORA92BORGMAXIMO.ORA'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-4026: Invalid parameter passed. (OS-204802)
Cause
Its a Bug specific to NT platform only. Cannot AUTOEXTEND to 4Gb boundary
Solution
This bug is fixed in 9203. Upgrading the database to the latest relase followed by a recovery will solve this problem.
Here are the steps:
1.Do a clean shutdown of the database
2. Upgrade the database to the latest version ( greater than 9.2.0.3) as this bug is fixed in 9203.
If the database version is below 9i Rel 2(9.2.0.1) then first upgrade to 9iRel2 and then apply the latest available patchset.
Kindly check metalink for the latest patchset available
3.Mount the database
4.Do a COMPLTE recovery of the dataabse
5.Then start the database in migrate mode and upgrade the database. Refer Note 159657.1: Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9i
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
References
Bug 1668488 - Unable To Recover Datafile That Has Auto Extended Onto A 4gb BoundaryErrors
IO error reading block from file來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-84512/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- goldengate extract abended unable to queue I/O, I/O beyond file sizeGo
- Oracle I/O問題解析Oracle
- [Oracle Script] check File I/OOracle
- 等待事件:Disk file operations I/O事件
- 解決The jar file has no source attachment問題JAR
- MySQL range問題MySql
- db file async I/O submit 等待事件優化MIT事件優化
- db file async I/O submit 等待事件說明MIT事件
- Docker啟動故障問題 no such file or directory解決方法Docker
- mac下/usr/local/bin No such file or directory問題解決Mac
- gunzip時,提示file too large(問題已解決)
- Standby OS i/o問題導致Primary 庫不能正常歸檔問題
- 解決「問題」,不要解決問題
- WARNING:Could not lower the asynch I/O limit 錯誤解決MIT
- Java I/O系統學習系列一:File和RandomAccessFileJavarandomMac
- db file async I/O submit等待事件的故障診斷MIT事件
- 解決 ALL MIRROR URLS ARE NOT USING FTP, HTTP[S] OR FILE 問題FTPHTTP
- mysqld: File './binlog.~rec~' not found 問題解決處理MySql
- ORA-31640: unable to open dump file 問題解決
- (問題解決)Cannot set LC_CTYPE to default locale: No such file or directory
- 解決eclipse中出現Resource is out of sync with the file system問題Eclipse
- Using UTL_FILE Package To Perform File I/O (UNIX) And Basic FAQ_44307.1PackageORM
- Veritas Quick I/O and Cached Quick I/OUI
- 解決: gsrvr.exe錯誤,記憶體不能為讀,地圖白屏,I/O錯誤 問題。(轉載)VR記憶體地圖
- 網路I/O模型 解讀模型
- "萬字" Java I/O 詳解Java
- 計算機I/O與I/O模型計算機模型
- I/O埠和I/O記憶體記憶體
- 【問題處理】Oracle process running out of OS kernel I/O resourcesOracle
- MySQL 8.0.12 --secure-file-priv 資料匯出問題解決MySql
- Authentication failure 以及xxx is not in the sudoers file 問題的解決辦法AI
- Latex編譯錯誤:Unable to load picture or PDF file 問題解決編譯
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- IRP(I/O Request Package)詳解Package
- 解決問題
- html/template 模板range輸出問題HTML
- X201i 滑鼠卡的問題解決辦法
- 發現問題,解決問題