multiplex Control Files in Oracle

How to multiplex Control Files in Oracle

Control File is a physical component of every Oracle Database.Control File includes information like database name,
name and location of data files and redo log files
If the control files are corrupt, can you start your database?
No, you can’t do it. So what should be done to avoid such type of corruption?
As a DBA, it’s your responsibility to multiplex control files to protect your organization in case of possible
data loss due to media failure or control file corruption.
Here below step to multiplexing contol file.

firstly connect to the database.
then see where the exiting control files are located.
SQL> show parameter control_files


NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time     integer 7
control_files     string /shared/sync/data/control02.ct
l, /shared/sync/data/control01
.ctl

check db _name
show parameter db_name

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name     string sync

shutdown the database

then in os level copy the control file in new location
cp /shared/sync/data/control02.ctl /shared/sync/data/control03.ctl

startup nomount

alter system set control_files='/shared/sync/data/control02.ctl','/shared/sync/data/control01.ctl','/shared/sync/data/control03.ctl' 
scope=spfile;
--In above step we added new location of cotrol file in pfile.

shutdwon immediate 
startup
check controlfile

SQL> show parameter control

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time     integer 7
control_files     string /shared/sync/data/control02.ct
l, /shared/sync/data/control01
.ctl, /shared/sync/data/contro
l03.ctl
-- above we are seeing new control file is added on parameter file.