Modify the control file in RAC and ASM Environments

1. Currently, there is only one control file. We plan to add three to ensure security.

SQL> select name from v $ controlfile;

NAME
--------------------------------------------------------------------------------

+ DATA/tyolap/controlfile/current.256.772291325

2. Execute the following SQL

Alter system set control_files = '+ DATA/tyolap/controlfile/control01.ctl', '+ DATA/tyolap/controlfile/control02.ctl ', '+ DATA/tyolap/controlfile/control03.ctl' scope = spfile;

3. Stop the database.

[Grid @ dtydb3 ~] $ Srvctl stop database-d tyolap

4. Copy the control file

ASMCMD> pwd
+ Data/TYOLAP/CONTROLFILE
ASMCMD> ls
Current.256.772291325
Test. ctl
ASMCMD> cp Current.256.772291325 control01.ctl
Copying + data/TYOLAP/CONTROLFILE/Current.256.772291325-> + data/TYOLAP/CONTROLFILE/control01.ctl
ASMCMD> cp Current.256.772291325 control02.ctl
Copying + data/TYOLAP/CONTROLFILE/Current.256.772291325-> + data/TYOLAP/CONTROLFILE/control02.ctl
ASMCMD> cp Current.256.772291325 control03.ctl
Copying + data/TYOLAP/CONTROLFILE/Current.256.772291325-> + data/TYOLAP/CONTROLFILE/control03.ctl
ASMCMD>

5. Restart the database.

[Grid @ dtydb3 ~] $ Srvctl start database-d tyolap

6. Verification results

SQL> select name from v $ controlfile;

NAME
--------------------------------------------------------------------------------
+ DATA/tyolap/controlfile/control01.ctl
+ DATA/tyolap/controlfile/control02.ctl
+ DATA/tyolap/controlfile/control03.ctl