FixedSize 1218968 bytes
VariableSize 104859240 bytes
DatabaseBuffers 171966464 bytes
RedoBuffers 7168000 bytes
ORA-00205:error in identifying control file, check alert log for more info
查看告警日志,报提示找不到controlfile1
Fri Jun 22 13:16:07 2012
Errors in file /DBSoft/admin/WWL/udump/wwl_ora_5104.trc:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/DBSoft/oradata/WWL/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
通过RMAN来进行控制文件的恢复:
1、强制启动数据库到nomount状态
SQL> startupforce nomount;
ORACLE instancestarted.
Total SystemGlobal Area 285212672 bytes
Fixed Size 1218968 bytes
VariableSize 109053544 bytes
Database Buffers 167772160 bytes
RedoBuffers 7168000 bytes
SQL> exit
2、执行restore控制文件恢复
RMAN>restore controlfile;
3、打开数据库
SQL>alter database mount;
Database altered.
SQL>alter database open;
Database altered.
相关阅读: