control03.ctl这个控制文件损坏了,在INIT<SID>.ORA 初始化参数文件里,
把这个文件去掉,然后再启动数据库
把这个文件去掉,然后再启动数据库
解决方案 »
- 如何在windows2008下安装oracle10g????
- 请教一个oracle管理的问题!
- toad
- PL/SQL存储过程
- 64位oracle在linux(x64)下安装如何打补丁p6810189_10204_linux-x86-64.zip
- 哪里可以下载Microsoft office visio 2003画图软件
- oracle程序员,有没有好用的在线帮助手册?
- 关于在asp中用ADO读取oracle中的clob字段出现错误的问题。
- Oraoledb.oracle以及MSDAORA.1作为驱动好像对于开发有很大的区别?
- 急——用存储过程解决自增字段的问题
- 低价转让 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那我是不是该把控制文件都重新设置过?