尝试进行recover datafile时报告下列错误:ORA-00283 ORA-01115 ORA-01110 ORA-27069 OSD-04026

来源：互联网发布：大数据时代与广告编辑：程序博客网时间：2024/04/29 10:28

操作系统环境：WIndows 2003 Server （32Bit）
数据库版本：9.2.0.1 ARCHIVED mode
错误现象：写入数据文件11时报告I/O错误，尝试进行recover时报告下列错误：
        ORA-00283：恢复会话因错误而取消
        ORA-01115：从文件11读取块时出现IO错误（块#1046535）
        ORA-01110：数据文件11:‘E:\ORACLE\ORA92\DQSBNET\NETREP_DATA.DBF’
        ORA-27069：skgfdisp:尝试在文件范围外执行I/O
        OSD-04026：传递的参数无效（OS 1046535）

检索Metalink发现此现象为Oracle Bug，
        DB <9.2.0.3 Cannot AUTOEXTEND to 4Gb boundary in NT [ID 317174.1]

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.

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

我的操作：

下载9.2.0.4补丁p3095277_9204_WINNT.zip
alter database datafile 11 offline;
shutdown immediate
升级Oracle软件至9.2.0.4
startup nomount
alter system set shared_pool_size=150m scope=spfile;
alter system set java_pool_size=150m scope=spfile;
shutdown immediate
startup migrate
spool patch.log
@?\rdbms\admin\catpatch.sql
spool off
shutdown immediate
startup
recover datafile 11; -- 选择auto方式
alter database datafile 11 online;
shutdown immedaite
cold backup

截图：

0 0