control file 다중화하기 ; ASM환경, RMAN이용

다음과 같은 과정을 거칩니다.
1. 현재상황확인
2. shutdown
3. nomount 후 현재 컨트롤파일 restore(RMAN이용)
* restore controlfile  to '+DATA' from '이전컨트롤파일경로';
3-1. asmcmd로 restore된 controlfile 확인
4. 파라미터파일 수정
5. shutdown 후 startup
5-1. 변경 후 상황확인


1. 현재상황확인

SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +FRA/db1/controlfile/backup.25
                                                 6.779279155

2. shutdown

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

3. nomount 후 현재 컨트롤파일 restore(RMAN이용)
restore controlfile to '+DATA' from '+FRA/db1/controlfile/backup.256.779279155';

RMAN> startup nomount

Oracle instance started

Total System Global Area     239075328 bytes

Fixed Size                     1218724 bytes
Variable Size                 71305052 bytes
Database Buffers             163577856 bytes
Redo Buffers                   2973696 bytes

RMAN> restore controlfile to '+DATA' from '+FRA/db1/controlfile/backup.256.779279155';

Starting restore at 2012-04-01:06:21:08
using channel ORA_DISK_1

channel ORA_DISK_1: copied control file copy
Finished restore at 2012-04-01:06:21:17

3-1. asmcmd로 restore된 controlfile 확인

[oracle@server15 ~]$ export ORACLE_SID=+ASM
[oracle@server15 ~]$ asmcmd
ASMCMD> cd data/db1
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
TEMPFILE/
ASMCMD> cd controlfile
ASMCMD> ls
backup.268.779437277
ASMCMD> exit

4. 파라미터파일 수정

[oracle@server15 ~]$ export ORACLE_SID=db1
[oracle@server15 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 1 06:29:07 2012

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter system set control_files='+FRA/db1/controlfile/backup.256.779279155', '+DATA/db1/controlfile/backup.268.779437277' scope=spfile;

System altered.

5. shutdown 후 startup

SQL> shut
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  239075328 bytes
Fixed Size                  1218724 bytes
Variable Size              71305052 bytes
Database Buffers          163577856 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.

5-1. 변경 후 상황확인

SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +FRA/db1/controlfile/backup.25
                                                 6.779279155, +DATA/db1/control
                                                 file/backup.268.779437277