一个和控制文件有关的问题

--一个开发数据库，启动报错：

Mon Nov 27 15:10:02 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Nov 27 15:10:02 2006
ALTER DATABASE OPEN
Mon Nov 27 15:10:02 2006
Rolling back half complete log switch of thread 1
Mon Nov 27 15:10:05 2006
Errors in file /opt/oracle/admin/orcl/bdump/orcl_lgwr_7508.trc:
ORA-00202: controlfile: '/opt/oracle/oradata/orcl/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux-ia64 Error: 5: Input/output error
Additional information: 119
Mon Nov 27 15:10:05 2006
Errors in file /opt/oracle/admin/orcl/bdump/orcl_lgwr_7508.trc:
ORA-00204: error in reading (block 119, # blocks 1) of controlfile
ORA-00202: controlfile: '/opt/oracle/oradata/orcl/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux-ia64 Error: 5: Input/output error
Additional information: 119
LGWR: terminating instance due to error 204
Mon Nov 27 15:10:07 2006
Errors in file /opt/oracle/admin/orcl/bdump/orcl_dbw0_7506.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Mon Nov 27 15:10:07 2006
Errors in file /opt/oracle/admin/orcl/bdump/orcl_pmon_7504.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Instance terminated by LGWR, pid = 7508

三个控制文件在操作系统下cp,也是报io error.

trace控制文件时，用

alter database backup controlfile to trace; 可以

alter database backup controlfile to '.....'; 报io error.

重建控制文件即可.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/936/viewspace-60700/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/936/viewspace-60700/