探索Oracle之RMAN_07控制文件丢失恢复(二)

2014-11-24 18:50:12 · 作者: · 浏览: 2
em Global Area 285212672 bytes


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.


相关阅读: