[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