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

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


$ sqlplus / as sysdba


SQL> select name from v$CONTROLFILE;


/u02/oracle/oradata/orcl/control01.ctl
/u02/oracle/oradata/orcl/control02.ctl


SQL> shutdown immediate;


SQL> quit


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

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

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


$ sqlplus / as sysdba


SQL> startup nomount;


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


SQL> shutdown immediate;


SQL> startup;


SQL> SELECT name FROM v$CONTROLFILE;


/u02/oracle/oradata/orcl/control/control01.ctl
/u02/oracle/oradata/orcl/control/control02.ctl
/u03/oracle/oradata/orcl/control/control03.ctl


SQL> quit

Удаляем старые controlfile

$ rm /u02/oracle/oradata/orcl/control01.ctl
$ rm /u02/oracle/oradata/orcl/control02.ctl