RAC+ASM下增加控制文件

来源:互联网 发布:清华教授 软件学院 编辑:程序博客网 时间:2024/05/17 06:11

your original control file is already stored on ASM, so no need to use

restore controlfile to '' from '';

On RMAN, just use

restore controlfile from '<the path to the ASM's control file which you can get crom v$controlfile'

Also, you need to specify sid=* on the alter system when RAC is involved.

Do this:
Code:

alter system set control_files='<path of your current controlfile>','+DISK_GROUP_WHERE_NEW_CONTROLFILE_WILL_RESIDE' scope=spfile sid='*';
shutdown normal
startup nomount

then on RMAN
Code:

rman target / restore controlfile from '<path of your current control file>';

You will see the new of the new control file created.
Then you will mount and open the database and modify the control_files parameter again, but now including both path for your controlfiles. After that, you can shutdown immediate and startup again.
Reply With Quote

原创粉丝点击