控制文件的恢复

 SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'F:/ORADATA/ORCL/CONTROL01.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check)

 

因为控制文件有三个，所以把CONTROL01.CTL删掉，把CONTROL02.CTL复制成CONTROL01.CTL，就可以了~

 

另外还扯出另外的几个链接:

ORACLE 817控制、日志文件损坏恢复总结 http://hi.baidu.com/zwfha/blog/item/e98743d9c246adeb39012fc0.html/cmtid/9f29ba358708401b91ef394f

 

oracle 控制文件损坏时的恢复

http://blog.csdn.net/liuya1985liuya/archive/2007/10/15/1826003.aspx