本文在11gr2 rac + ASM环境下实现,总体思路是通过rman复制多个控制文件,然后修改参数文件的control_file参数即可,操作需要nomount状态下;多个控制文件增加数据库安全性
1,查看当前control file设置,只有一个控制文件
sys@LISDB1(dtydb3)>show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/lisdb/controlfile/curren
t.352.826293519
control_management_pack_access string DIAGNOSTIC+TUNING
sys@LISDB1(dtydb3)>select name from v$controlfile;
NAME
--------------------------------------------------
+DATA/lisdb/controlfile/current.352.826293519
2,关闭
1,查看当前control file设置,只有一个控制文件
sys@LISDB1(dtydb3)>show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/lisdb/controlfile/curren
t.352.826293519
control_management_pack_access string DIAGNOSTIC+TUNING
sys@LISDB1(dtydb3)>select name from v$controlfile;
NAME
--------------------------------------------------
+DATA/lisdb/controlfile/current.352.826293519
2,关闭