ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-27069

ORA-27069

原创 Linux操作系统 作者:ORA8SQL 时间:2012-02-13 18:53:59 0 删除 编辑
Subject:DB <9.2.0.3 Cannot AUTOEXTEND to 4Gb boundary in NT
Doc ID:Note:317174.1Type:PROBLEM
Last Revision Date:02-AUG-2005Status:MODERATED

In this Document
Symptoms
Cause
Solution
References


Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1.0
Microsoft 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 nline=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

6.Shutdown the database and then restart in normal mode. 
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

References

Bug 1668488 - Unable To Recover Datafile That Has Auto Extended Onto A 4gb Boundary

Errors

ORA-1115 IO error reading block from file block # ORA-1110 datafile : ORA-283 recovery session canceled due to errorsOSD-4026 Invalid parameter passed.ORA-27069 { Message text depends on version }
----
客户做过RMAN备份的。直接还原数据库做RECOVER后解决

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26661112/viewspace-716178/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-01-31

  • 博文量
    5
  • 访问量
    5960