今天同事添加RAC中的控制文件,但出错,他只做了,
SQL>alter system set control_files='+DATA/orcl/controlfile/current260.700853137',
' +FLUSHRECOVER/orcl/controlfile/current.256.700853137','+DATA/control03.ctl','+DATA/control04.ctl'
却没有复制控制文件到相应的目录下面导致数据库不能启动,所以不能启动数据库
SQL>alter system set control_files='+DATA/orcl/controlfile/current260.700853137',
' +FLUSHRECOVER/orcl/controlfile/current.256.700853137','+DATA/control03.ctl','+DATA/control04.ctl'
却没有复制控制文件到相应的目录下面导致数据库不能启动,所以不能启动数据库
遂进入RMAN中进行控制文件的复制
rman target / nocatalog
restore controlfile to '+DATA/control03.ctl' from '+DATA/orcl/controlfile/current.260.700853137';
restore controlfile to '+DATA/control04.ctl' from '+DATA/orcl/controlfile/current.260.700853137';
完成,退出,启动数据库,成功
rman target / nocatalog
restore controlfile to '+DATA/control03.ctl' from '+DATA/orcl/controlfile/current.260.700853137';
restore controlfile to '+DATA/control04.ctl' from '+DATA/orcl/controlfile/current.260.700853137';
完成,退出,启动数据库,成功
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+DATA/orcl/controlfile/current.260.700853137
+FLUSHRECOVER/orcl/controlfile/current.256.700853137
+DATA/control03.ctl
+DATA/control04.ctl
--------------------------------------------------------------------------------
+DATA/orcl/controlfile/current.260.700853137
+FLUSHRECOVER/orcl/controlfile/current.256.700853137
+DATA/control03.ctl
+DATA/control04.ctl
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22779291/viewspace-625243/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22779291/viewspace-625243/