Multiplexing Control File

Manually add control files
Method 1,
1. Modify the control file information in the parameter file spfile.
SQL> alter system set control_files =
'/Database/oradata/yang/control01.ctl ',
'/Database/oradata/yang/control02.ctl ',
'/Database/oradata/yang/control03.ctl ',
'/Database/control04.ctl' scope = spfile;
2. The cp control file must be properly shut down (otherwise, the newly added control file is different from the original control file SCN)
SQL> shutdown immediate
SQL> host cp/database/oradata/yang/control01.ctl
/Database/control04.ctl
3. Start database viewing
SQL> startup
SQL> show parameter control;
Or fuzzy query SQL> select value from v $ parameter where name like 'control _ files ';

Method 2
Use the original spfile file to create a pfile file and use the vi editor to modify the control file information in the pfile file. Then, use the pfile file to create the spfile file and close the database normally, copy the control file to a new location.