RAC更换controlfile位置

1.Stop Instance
srvctl stop instance -d dbname -i instance1,instance2 -o immediate
2.Start database to nomount
srvctl start database -d dbname -o nomount
3.Restore controlfile to new location
restore controlfile to '+_REDO2//control02.ctl' from '+//CONTROLFILE/current.257.1067347003';
4.Modify database parameter
alter system set control_files='+//control01.ctl','+//control02.ct' scope=spfile sid='*';
5.Restart Database
srvctl stop database -d **
srvctl start database -d **

posted @ 2021-03-16 16:41  菲阳公社  阅读(86)  评论(0)    收藏  举报