系统环境
OS WINDOWS 2003
Oracle版本 10g
1 背景
在做数据库测试的时候,突然停电导致虚拟机开机一直蓝屏
2 恢复流程
Linux下安装了rehl6.4+Oracle10g
把控制文件、日志文件、数据文件拷贝至对应位置启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 872415232 bytes
Fixed Size 2024720 bytes
Variable Size 222300912 bytes
Database Buffers 645922816 bytes
Redo Buffers 2166784 bytes
ORA-00205: error in identifying control file, check alert log for more info
alert_log
MMNL started with pid=12, OS id=3123
Fri May 30 00:37:59 2014
starting up 1 shared server(s) ...
Fri May 30 00:37:59 2014
ALTER DATABASE MOUNT
Fri May 30 00:37:59 2014
ORA-00202: control file: '/app/oracle/oradata/orcl10g/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Fri May 30 00:37:59 2014
ORA-205 signalled during: ALTER DATABASE MOUNT...
晚上找此错误解决方案无果
------解决方案--------------------
看看该文件是否存在?
ORA-00202: control file: '/app/oracle/oradata/orcl10g/control01.ctl'