Multiplexing Control File

Multiplexing the Control File When Using SPFILE

Sql> shutdown immediate
$ cp /u00/app/oracle/oradata/ota/control01.ctl /u04/ota/control04.ctl

Sql> Startup nomount
Sql> ALTER SYSTEM SET control_files =
‘/u00/app/oracle/oradata/ota/control01.ctl’,
‘/u00/app/oracle/oradata/ota/control02.ctl’,
‘/u00/app/oracle/oradata/ota/control03.ctl’,
‘/u04/ota/control04.ctl’
SCOPE=SPFILE;

Sql> shutdown immediate
Sql> startup
Sql> select name from v$controlfile;
Sql> create PFILE from SPFILE;



Multiplexing the Control File When Using PFILE

Sql> sqlplus /nolog
Sql> Connect /as sysdba
Sql> shutdown immediate

$ cp /u00/app/oracle/oradata/ota/control01.ctl /u0X/ota/control04.ctl

Add this entry in PFILE

control_files = ‘/u00/app/oracle/oradata/ota/control01.ctl’,
‘/u00/app/oracle/oradata/ota/control02.ctl’,
‘/u00/app/oracle/oradata/ota/control03.ctl’,
‘/u0X/ota/control04.ctl’

SQL> startup