컨트롤 파일 다중화, Controlfile Multiplexing

 

-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.110 문제 풀이

1. spfile 구동 시

SQL> shutdown immediate
SQL> exit

os]mkdir /u01/app/oracle/disk1
os]mkdir /u01/app/oracle/disk2
os]mkdir /u01/app/oracle/disk3
os]mkdir /u01/app/oracle/disk4
os]mkdir /u01/app/oracle/disk5

os]sqlplus / as sysdba

SQL> startup open;

SQL> alter system set control_files='/u01/app/oracle/disk1/control01.ctl',
                                                  '/u01/app/oracle/disk2/control02.ctl',
                                                  '/u01/app/oracle/disk3/control03.ctl',
                                                  '/u01/app/oracle/disk3/control01.ctl',
                                                  '/u01/app/oracle/disk4/control02.ctl',
                                                  '/u01/app/oracle/disk5/control03.ctl' scope=spfile;
SQL> shutdown immediate;
SQL> exit

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk1/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk2/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control03.ctl

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk4/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk5/control03.ctl

os]sqlplus / as sysdba

SQL> startup open;
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/disk1/control01.ctl
/u01/app/oracle/disk2/control02.ctl
/u01/app/oracle/disk3/control03.ctl
/u01/app/oracle/disk3/control01.ctl
/u01/app/oracle/disk4/control02.ctl
/u01/app/oracle/disk5/control03.ctl

2. pfile 구동 시

SQL> shutdown immediate
SQL> exit

os]mkdir /u01/app/oracle/disk1
os]mkdir /u01/app/oracle/disk2
os]mkdir /u01/app/oracle/disk3
os]mkdir /u01/app/oracle/disk4
os]mkdir /u01/app/oracle/disk5

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk1/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk2/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control03.ctl

os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk3/control01.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk4/control02.ctl
os]cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/disk5/control03.ctl

-- pfile 수정

os]sqlplus / as sysdba

SQL> startup open;
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/disk1/control01.ctl
/u01/app/oracle/disk2/control02.ctl
/u01/app/oracle/disk3/control03.ctl
/u01/app/oracle/disk3/control01.ctl
/u01/app/oracle/disk4/control02.ctl
/u01/app/oracle/disk5/control03.ctl

참고> http://f1angel.tistory.com/70

cf. 컨트롤 파일 다중화
http://blog.daum.net/itcertification/8212408
http://devidebyzero.egloos.com/2080477
http://sksstar.tistory.com/101
http://dbrang.tistory.com/512

cf. 리두로그 파일
http://www.jigi.net/entry/%EC%98%A4%EB%9D%BC%ED%81%B4-Admin-2

 

cf. 리눅스에서 오라클 설치 시 한글 깨짐 문제
http://secretno.tistory.com/338
http://fafoyoum.blog.me/70021582158

 

cf. Patch
http://cafe.naver.com/ocmkorea/7312