Oracle Controlfile Multiplexing

Oracle

A control file is a small binary file that is part of an Oracle database. The control file is used to keep track of the database’s status and physical structure.

We can do controlfile multiplexing in 2 ways

  1. Using pfile
  2. Using Spfile

1. Using pfile:

  1. Shut down the database. SQL> shut immediate
  2. go to the pfile location and edit the pfile. cd /u01/app/oracle/admin/cts/pfile vi init.ora press “i” to eit

control_files=’/u01/app/oracle/oradata/cts/controlfile01.ctl’,’/u01

/app/oracle/oradata/cts/controlfile02.ctl’,’/u01/app/oracle/oradata

/cts/controlfile03.ctl’,’/u01/app/oracle/oradata/cts/controlfile04.ctl’

Press ESC+SHIFT + : + wq –> to save

  1. copy the controlfile01.ctl and change the as controlfile04.ctl cd /u01/app/oracle/oradata/cts/ cp controlfile01.ctl controlfile04.ctl
  2. start the database using PFILE and check the controfiles SQL> startup nomount

pfile=’/u01/app/oracle/admin/cts/pfile/init.ora’

SQL> select *from v$controlfile;

2. Using Spfile:

  1. check the controlfiles and modify the spfile SQL> select *from v$controfile SQL> alter system set

control_files=’/u01/app/oracle/oradata/cts/controlfile01.ctl’,’/u01

/app/oracle/oradata/cts/controlfile02.ctl’,’/u01/app/oracle/oradata

/cts/controlfile03.ctl’,’/u01/app/oracle/oradata/cts/controlfile04.

ctl’,’/u01/app/oracle/oradata/cts/controlfile05.ctl’ scope=spfile;

  1. Shut down the database. SQL> shut immediate
  2. copy the controlfile01.ctl and change as controlfile05.ctl cd /u01/app/oracle/oradata/cts/ cp controlfile01.ctl controlfile05.ctl
  3. start the database and check the conrofiles SQL> startup SQL> select *from v$controlfile;