ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 一个和控制文件有关的问题

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

原创 Linux操作系统 作者:jlandzpa 时间:2019-04-25 17:15:05 0 删除 编辑

--一个开发数据库,启动报错:

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2001-10-12

  • 博文量
    110
  • 访问量
    81259