昨天在群里发现有人问这个问题,我自己其实没碰到过的,于是在网上找了下,下面这种情况似乎蛮多的,记在这里好了!
database: 10.2.0.1.0
os: solaris 10
oracle不能启动,只能mount,open的时候报错ORA-3113 "end of file on communication channel"
查看alert文件:
Completed: ALTER DATABASE MOUNT
Tue Jul 24 10:43:21 2007
alter database open
Tue Jul 24 10:43:21 2007
Rolling back half complete log switch of thread 1
Tue Jul 24 10:43:21 2007
Errors in file /testbed/oracle/admin/bcqadb/bdump/bcqadb_lgwr_13512.trc:
ORA-00202: control file: '/testbed/oracle/oradata/bcqadb/control01.ctl'
ORA-27091: unable to queue I/O
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 435
Additional information: 1
Additional information: 433
Tue Jul 24 10:43:21 2007
Errors in file /testbed/oracle/admin/bcqadb/bdump/bcqadb_lgwr_13512.trc:
ORA-00204: error in reading (block 435, # blocks 1) of control file
ORA-00202: control file: '/testbed/oracle/oradata/bcqadb/control01.ctl'
ORA-27091: unable to queue I/O
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 435
Additional information: 1
Additional information: 433
LGWR: terminating instance due to error 204
Instance terminated by LGWR, pid = 13512
执行alter database open resetlogs,问题解决!
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12125877/viewspace-366248/ ,如需转载,请注明出处,否则将追究法律责任。