SQL> -- control file 다중화
SQL> -- 1. control file 백업
SQL> create pfile = '/home/oracle/spfileorcl.ora_080316' from spfile;

파일이 생성되었습니다.

SQL> -- 2. 파라메터값 변경
SQL> select name from v$controlfile;

NAME
-------------------------------------------------------------------------------------------

/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_3trzhg7o_.ctl
/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_3trzhgfx_.ctl

SQL> alter system set control_files = '/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_3trzh
  2     ,'/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_3trzhgfx_.ctl'
  3     ,'/u01/app/oracle/oradata/ORCL/controlfile/control2.ctl'
  4   scope=spfile;

시스템이 변경되었습니다.

SQL> -- 3. shutdown
SQL> shutdown immediate
데이터베이스가 닫혔습니다.
데이터베이스가 마운트 해제되었습니다.
ORACLE 인스턴스가 종료되었습니다.
SQL> -- 4. 파일 복사
SQL>host cp /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_3trzhg7o_.ctl /u01/app/oracle/oradata/ORCL/controlfile/control2.ctl
SQL>
SQL> -- 5. startup
SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size             100664912 bytes
Database Buffers          180355072 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
SQL>