To multiplex your control files, we copy the control file to multiple locations and change the CONTROL_FILES parameter in the text based initialization file init. ora to include all control files names. 2. Copy the control file to more locations using operating system command.

Why do we use multiplex control files?

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.

What are the steps to multiplex control file using Pfile and Spfile?