创建表导致数据库关闭
使用create table 。。。as select 创建表(使用dblink将远程数据库表和本地库表关联,并在本地库创建表),结果出现错误,查看日志如下:
Thu Dec 10 15:18:17 2009
Errors in file d:\oracle\admin\ora9\udump\ora9_ora_1180.trc:
ORA-01114: 将块写入文件 9 时出现 IO 错误 (块 # 2080753)
ORA-27069: skgfdisp: 尝试在文件范围外执行 I/O
OSD-04026: 传递的参数无效。 (OS 2080776)
ORA-01114: 将块写入文件 9 时出现 IO 错误 (块 # 2080753)
ORA-27069: skgfdisp: 尝试在文件范围外执行 I/O
OSD-04026: 传递的参数无效。 (OS 2080776)
ORA-01114: 将块写入文件 9 时出现 IO 错误 (块 # 2080753)
ORA-27069: skgfdisp: 尝试在文件范围外执行 I/O
OSD-04026: 传递的参数无效。 (OS 2080776)
ORA-01114: 将块写入文件 时出现 IO 错误 (块 # )
Thu Dec 10 15:18:19 2009
Errors in file d:\oracle\admin\ora9\udump\ora9_ora_1180.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 9 (block # 2080753)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: 传递的参数无效。 (OS 2080776)
ORA-01114: IO error writing block to file 9 (block # 2080753)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: 传递的参数无效。 (OS 2080776)
ORA-01114: IO error writing block to file 9 (block # 2080753)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: 传递的参数无效。 (OS 2080776)
ORA-01114: IO error writing block to file (block # )
Thu Dec 10 15:18:47 2009
KCF: write/open error block=0x10200b online=1
file=9 D:\ORACLE\ORADATA\ORA9\USERS01.DBF
error=27069 txt: 'OSD-04026: 传递的参数无效。 (OS 1056779)'
Thu Dec 10 15:18:47 2009
Errors in file d:\oracle\admin\ora9\bdump\ora9_dbw0_3436.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 9 (block # 1056779)
ORA-01110: data file 9: 'D:\ORACLE\ORADATA\ORA9\USERS01.DBF'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: 传递的参数无效。 (OS 1056779)
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 3436
看了下日志,提示文件 9 'D:\ORACLE\ORADATA\ORA9\USERS01.DBF'写入块失败,且运行sql语句后,数据库自动关闭,再次打开数据库,检查表空间、数据文件都是正常的,且空间足够。
运行了2次sql都是这个失败信息。
各位高手帮忙分析下错误原因,谢谢了。