最近oralce数据库老是自动停止,下面是错误信息。。。 control03.ctl这个控制文件损坏了,在INIT<SID>.ORA 初始化参数文件里,把这个文件去掉,然后再启动数据库 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如在INIT<SID>.ORA 初始化参数文件里control_files = (C:\ORAWIN95\DATABASE\ctl1orcl.ora,C:\ORAWIN95\DATABASE\CTL1ORCL1.ORA,C:\ORAWIN95\DATABASE\CTL1ORCL3.ORA)把他改为control_files = (C:\ORAWIN95\DATABASE\ctl1orcl.ora,C:\ORAWIN95\DATABASE\CTL1ORCL1.ORA) 或者将control02.ctl 拷贝一个新的 重命名 为control03.ctl启动数据库。 晕!现在变成这样:Errors in file /export/home/oracle/admin/e3500/bdump/oracle_ckpt_23900.trc:ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: '/data/oradata/e3500/control03.ctl'ORA-27063: skgfospo: number of bytes read/written is incorrectSVR4 Error: 5: I/O errorAdditional information: -1Additional information: 8192ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: '/data/oradata/e3500/control02.ctl'ORA-27063: skgfospo: number of bytes read/written is incorrectSVR4 Error: 5: I/O errorAdditional information: -1Additional information: 8192ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: '/data/oradata/e3500/control01.ctl'ORA-27063: skgfospo: number of bytes read/written is incorrectSVR4 Error: 5: I/O errorAdditional information: -1Additional information: 8192Thu Apr 28 14:24:24 2005CKPT: terminating instance due to error 221Instance terminated by CKPT, pid = 23900那我是不是该把控制文件都重新设置过? DML操作配合analyze问题 连接查询问题 急!关于表内字段名映射后建view的问题 求助:安装oracle 10g 服务器的问题 vc中使用ado连接oracle数据库,添加新纪录出错 性能问题:ORACLE 9i2,我们的数据库数据和客户的是相同的(IMPORT过来的),但是相同的PROCEDURE用T_CURSOR返回记录做查询,我们这边只需要1,2 大括号分割的.dat格式的文本文件如何导入oracle? 求救 如何实现多表修改(在线) 如何获得记录集的记录数? 低价转让 Oracle部分好书 ORACLE如何备份数据???
在INIT<SID>.ORA 初始化参数文件里control_files = (C:\ORAWIN95\DATABASE\ctl1orcl.ora,C:\ORAWIN95\DATABASE\CTL1ORCL1.ORA,C:\ORAWIN95\DATABASE\CTL1ORCL3.ORA)
把他改为control_files = (C:\ORAWIN95\DATABASE\ctl1orcl.ora,C:\ORAWIN95\DATABASE\CTL1ORCL1.ORA)
将control02.ctl 拷贝一个新的 重命名 为control03.ctl
启动数据库。
Errors in file /export/home/oracle/admin/e3500/bdump/oracle_ckpt_23900.trc:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/data/oradata/e3500/control03.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/data/oradata/e3500/control02.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/data/oradata/e3500/control01.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192
Thu Apr 28 14:24:24 2005
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 23900那我是不是该把控制文件都重新设置过?