ASM添加控制文件
一查看控制文件
SQL> select
name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+SYSTEDG/prod1/controlfile/current.260.885576603
二向参数文件添加控件文件
SQL> alter
system set
control_files='+SYSTEDG/prod1/controlfile/current.260.885576603','+SYSTEDG'
scope=spfile;
三通过rman物理拷贝控制文件
SQL>
shutdown immediate
SQL> start
nomount
[oracle@ogg1
dbs]$ rman target / nocatalog
RMAN>
restore controlfile from '+SYSTEDG/prod1/controlfile/current.260.885576603';
四查看控制文件
[oracle@ogg1
dbs]$ sqlplus / as sysdba
SQL> alter
database mount;
SQL> alter
database open;
SQL> select
name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+SYSTEDG/prod1/controlfile/current.260.885576603
+SYSTEDG/prod1/controlfile/current.268.885662913
来自: