Multiplexing in control_file is one of the best practices of oracle database setup. It means keeping control files in different mount point or disk groups , so that in case one mount points is inaccessible, control file can be accessed from the available mount point.

NOTE – > This activity needs downtime.

         FOR MULTIPLEXING IN RAC – > STEPS FOR MULTIPLEXING IN ORACLE RAC

In this below DEMO, we will explain the steps for multiplexing control files.

 

DEMO:

1. Check current control files:

Create a directory in the new mount point, where we will keep the new control file.

2. update the control_files parameter by adding the new path also

3. Shutdown the database and start with nomount:

4. restore the controlfile from existing control file .

5. Restart the database:

6. Check whether new control file is available or not :

We can observe controlfile is available now on all 3 locations.