[Oracle DataBase Server 12.1 installation on Windows 2008 Server]: Controlfiles multiplexing


CMD> sqlplus / as sysdba


SQL> select name from v$CONTROLFILE;


NAME
--------------------------------------------------
E:\APP\ORACLE\ORADATA\ORA121\CONTROL01.CTL
E:\APP\ORACLE\ORADATA\ORA121\CONTROL02.CTL


SQL> shutdown immediate;


SQL> quit


md e:\app\oracle\oradata\ora121\control
md f:\app\oracle\oradata\ora121\control


copy e:\app\oracle\oradata\ora121\CONTROL01.CTL e:\app\oracle\oradata\ora121\control\CONTROL01.CTL /y
copy e:\app\oracle\oradata\ora121\CONTROL01.CTL e:\app\oracle\oradata\ora121\control\CONTROL02.CTL /y
copy e:\app\oracle\oradata\ora121\CONTROL01.CTL f:\app\oracle\oradata\ora121\control\CONTROL03.CTL /y


sqlplus / as sysdba


SQL> startup nomount;


SQL> ALTER SYSTEM SET control_files = 'e:\app\oracle\oradata\ora121\control\CONTROL01.CTL', 'e:\app\oracle\oradata\ora121\control\CONTROL02.CTL', 'f:\app\oracle\oradata\ora121\control\CONTROL03.CTL' scope=spfile;


SQL> shutdown immediate;


SQL> startup;


SQL> SELECT name FROM v$CONTROLFILE;


NAME
--------------------------------------------------------------
E:\APP\ORACLE\ORADATA\ORA121\CONTROL\CONTROL01.CTL
E:\APP\ORACLE\ORADATA\ORA121\CONTROL\CONTROL02.CTL
F:\APP\ORACLE\ORADATA\ORA121\CONTROL\CONTROL03.CTL


SQL> quit

Remove old controlfiles:

del E:\APP\ORACLE\ORADATA\ORA121\CONTROL01.CTL
del E:\APP\ORACLE\ORADATA\ORA121\CONTROL02.CTL