[Инсталляция Oracle DataBase Server 12.1 в Oracle Linux 6.7]: Мультиплексирование controlfiles

$ mkdir -p /u02/oracle/oradata/12.1/${ORACLE_SID}/CONTROLFILE
$ mkdir -p /u03/oracle/oradata/12.1/${ORACLE_SID}/CONTROLFILE

$ sqlplus / as sysdba

SQL> select name from v$CONTROLFILE;

NAME
--------------------------------------------------------------------------------
/u02/oracle/oradata/12.1/orcl12/control01.ctl
/u02/oracle/oradata/12.1/orcl12/control02.ctl

SQL> shutdown immediate;

SQL> quit

$ cp /u02/oracle/oradata/12.1/${ORACLE_SID}/control01.ctl /u02/oracle/oradata/12.1/${ORACLE_SID}/CONTROLFILE/control01.ctl

$ cp /u02/oracle/oradata/12.1/${ORACLE_SID}/control01.ctl /u02/oracle/oradata/12.1/${ORACLE_SID}/CONTROLFILE/control02.ctl

$ cp /u02/oracle/oradata/12.1/${ORACLE_SID}/control01.ctl /u03/oracle/oradata/12.1/${ORACLE_SID}/CONTROLFILE/control03.ctl

$ sqlplus / as sysdba

SQL> startup nomount;

SQL> ALTER SYSTEM SET control_files = '/u02/oracle/oradata/12.1/orcl12/CONTROLFILE/control01.ctl', '/u02/oracle/oradata/12.1/orcl12/CONTROLFILE/control02.ctl', '/u03/oracle/oradata/12.1/orcl12/CONTROLFILE/control03.ctl' scope=spfile;

SQL> shutdown immediate;

SQL> startup;

SQL> SELECT name FROM v$CONTROLFILE;

NAME
--------------------------------------------------------------------------------
/u02/oracle/oradata/12.1/orcl12/CONTROLFILE/control01.ctl
/u02/oracle/oradata/12.1/orcl12/CONTROLFILE/control02.ctl
/u03/oracle/oradata/12.1/orcl12/CONTROLFILE/control03.ctl

SQL> quit

$ rm /u02/oracle/oradata/12.1/orcl12/control01.ctl
$ rm /u02/oracle/oradata/12.1/orcl12/control02.ctl