spfile백업후 시행할것.
(
SQL> create pfile='/home/oracle/initorcl.ora' from spfile;

File created.
)

SQL> --컨트롤 파일 다중화
SQL> SHOW PARAMETER CONTROL

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ----------------------------

control_file_record_keep_time        integer                7
control_files                        string                 /u01/app/oracle/oradata/ORCL

                                                            ontrolfile/o1_mf_47v1ptbz_.c

                                                            , /u01/app/oracle/flash_reco

                                                            ry_area/ORCL/controlfile/o1_

                                                            _47v1ptg2_.ctl
SQL> ALTER SYSTEM SET control_files = '/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_47
ptbz_.ctl','/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_47v1ptg2_.ctl',
  '/u01/app/oracle/oradata/ORCL/controlfile/c3.ctl' scope=spfile;

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

SQL> shutdown immediate;
데이터베이스가 닫혔습니다.
데이터베이스가 마운트 해제되었습니다.
ORACLE 인스턴스가 종료되었습니다.
SQL> exit
C:>telnet 192.168.186.3
[oracle@edrsr4p1 ~]$ cp /u01/app/oracle/oradata/ORCL/controlfile/o1_mf_47v1ptbz_.ctl /u01/app/oracle/oradata/ORCL/controlfile/c3.ctl
[oracle@edrsr4p1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 25 15:57:58 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  163577856 bytes
Fixed Size                  1218292 bytes
Variable Size              92277004 bytes
Database Buffers           67108864 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
SQL>