1.stop the database
#srvctl stop database -d dbname
2.start database in nomount mode and set the control_files parameter:
sql>alter system set control_files='+DATA/dbname/controlfile/current_controlfile_1.ctl','+DATA/dbname/controlfile/current_controlfile_2.ctl' scope=spfile sid='*';
3.use RMAN restore controlfiles to the new destination:
rman target /
restore controlfile to '+DATA/dbname/controlfile/current_controlfile_1.ctl' from '+DATA/dbname/controlfile/current.controlfile.***.*****';
restore controlfile to '+DATA/dbname/controlfile/current_controlfile_2.ctl' from '+DATA/dbname/controlfile/current.controlfile.***.*****';
4.shutdown and startup the database;
sqlplus / as sysdba
shutdown immediate
exit
#srvctl start database -d dbname
5.check controlfile;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9117394/viewspace-624967/ ,如需转载,请注明出处,否则将追究法律责任。