[Инсталляция Oracle Database 12c Release 1 в Microsoft Windows 2008 Server]: Мультиплексирование controlfiles

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

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