[10g] spfile에서의 control file 다중화(추가/삭제)

/********************************************************************************************
-- Title : [10g] spfile에서의 control file 다중화(추가/삭제)
-- Reference : 솔데스크
-- Key word : 컨트롤 파일 추가
********************************************************************************************/

-- control file 확인
select * from v$controlfile;

-- control file 추가(control04.ctl)
alter system set control_files = '/home/oracle/oradata/ORCL/control01.ctl'
                                          , '/home/oracle/oradata/ORCL/control02.ctl'
                                          , '/home/oracle/oradata/ORCL/control03.ctl'
                                          , '/home/oracle/oradata/ORCL/control04.ctl' scope=spfile;

-- oracle 리스타트
shutdown immediate
startup

-- control file 추가 확인
select * from v$controlfile;

-- control file 삭제(control04.ctl)
alter system set control_files = '/home/oracle/oradata/ORCL/control01.ctl'
                                          , '/home/oracle/oradata/ORCL/control02.ctl'
                                          , '/home/oracle/oradata/ORCL/control03.ctl' scope=spfile;

-- oracle 리스타트
shutdown immediate
startup

-- control file 추가 확인
select * from v$controlfile;