数据文件超过4GB，报'OSD-04026: 无效的参数经过. (OS 561523)'

lxqin117

求助，环境WINDOW2003，32bit,oracle 8.1.6,出现KCF: write/open error block=0x89173 online=1
     file=7 F:\DATABASE\COTAB_01.ORA
     error=27069 txt: 'OSD-04026: 无效的参数经过. (OS 561523)'
Automatic datafile offline due to write error on
file 7: F:\DATABASE\COTAB_01.ORA   
当前文件已经达到4GB
用备份恢复，每次恢复到那个时间点就报错
请问还有啥好办法，可以解决？
已经尝试过单个数据文件恢复和全库恢复，每次都是到那个时间点就报错了，也无法正常EXP出来

Maclean Liu(刘相兵

OSD-04026  ，文件系统是否是NTFS? 若fat32则 存在4g的限制

lxqin117

是NTFS的，当前大小是4194308KB,BLOCK 大小是4096

Maclean Liu(刘相兵

1. Hdr: 1668488 8.1.7.0.0 RDBMS 8.1.7.0.0 OSD PRODID-5 PORTID-912 ORA-27069
   
2. Abstract: UNABLE TO RECOVER DATAFILE THAT HAS AUTO EXTENDED ONTO A 4GB BOUNDARY
   
3. 
   
4. *** 03/02/01 08:56 am ***
   
5. Problem Description
   
6. ===================
   
7. When a datafile has been configured such that it will autoextend onto a
   
8. 4GB boundary, any attempt to autoextend the file causes the database to
   
9. crash (when in noarchive log mode). Checkpoint writer (CKPT) and database
   
10. writer (DBWR) report :
    
11. 
    
12.   KCF: write/open error block=0x32002 online=1
    
13.        file=5 E:\ORACLE\ORADATA\V817\XXX.DBF
    
14.        error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)'
    
15. 
    
16.   ksedmp: internal or fatal error
    
17.   ORA-1242: data file suffered media failure: database in NOARCHIVELOG mode
    
18.   ORA-1114: IO error writing block to file 5 (block # 204802)
    
19.   ORA-1110: data file 5: 'E:\ORACLE\ORADATA\V817\XXX.DBF'
    
20.   ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
    
21.   OSD-4026: Invalid parameter passed. (OS-204802)
    
22. 
    
23. The database can be reopened and appears to work without error. If the
    
24. database was in archive log mode, the file will be marked offline recover
    
25. and access to the database continues. The following error appears in the
    
26. alert.log :
    
27. 
    
28.   KCF: write/open error block=0x32002 online=1
    
29.        file=5 E:\ORACLE\ORADATA\V817\XXX.DBF
    
30.        error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)'
    
31.   Automatic datafile offline due to write error on
    
32.   file 5: E:\ORACLE\ORADATA\V817\XXX.DBF
    
33. 
    
34. Any attempt to online / recover this file results in :

复制代码

Maclean Liu(刘相兵

Resizing files below, on and above the 4GB boundary works correctly.

Workaround
==========
None if it has already happened and the customer is in archive log mode.
Restart the database if in noarchive log mode.
Avoid autoextend where files can autoextend onto 4GB boundary.



这是win+8.1.6上的bug ， 库不大的话 exp升级下吧。。。

lxqin117

谢谢您的帮助