[2025-05-25] 2 Node RAC 환경에서 Control File (컨트롤 파일) 다중화 실습 (RMAN 사용) (12cR2)

1. 테스트 정보

DB명 : DRDBNEW
RAC1번 : rdb01d(192.168.0.31) 서버 내 DRDBNEW1 인스턴스
RAC2번 : rdb02d(192.168.0.32) 서버 내 DRDBNEW2 인스턴스

 

 

2. 파라미터 파일 백업 (spfile을 pfile로 백업)

[2025-05-25:12:11:39][rdb01d]<SYS@DRDBNEW1> create pfile from spfile;

File created.

Elapsed: 00:00:00.07

 

3. 컨트롤 파일 확인 및 변경

[2025-05-25:12:11:39][rdb01d]<SYS@DRDBNEW1> show parameter control_files;

NAME           TYPE                              VALUE
-------------- --------------------------------- ----------------------------------------------------------------------------------------------
control_files  string                            +FRA1/DRDB/CONTROLFILE/current.256.1196204797, +DATA1/DRDB/CONTROLFILE/current.261.1196204797



[2025-05-25:12:11:39][rdb01d]<SYS@DRDBNEW1> alter system set control_files='+FRA1/DRDB/CONTROLFILE/current.256.1196204797','+DATA1/DRDB/CONTROLFILE/current.261.1196204797','+CRS' scope=spfile sid='*';

System altered.

Elapsed: 00:00:00.35

 

4. 모든 노드를 shutdown 시킨 후 nomount 모드로 시작

[DRDBNEW1:oracle@rdb01d][/home/oracle]$ srvctl stop database -db drdbnew

[DRDBNEW1:oracle@rdb01d][/home/oracle]$ srvctl start database -db drdbnew -o nomount

ora.drdbnew.db
      1        ONLINE  INTERMEDIATE rdb01d                   Dismounted,HOME=/u01
                                                             /app/oracle/product/
                                                             12c/db_1,STABLE
      2        ONLINE  INTERMEDIATE rdb02d                   Dismounted,HOME=/u01
                                                             /app/oracle/product/
                                                             12c/db_1,STABLE

 

5. rman으로 접속 후 컨트롤 파일 restore

RMAN> restore controlfile from '+FRA1/DRDB/CONTROLFILE/current.256.1196204797';

Starting restore at 2025-05-25 12:20:48
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=267 instance=DRDBNEW1 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+FRA1/DRDB/CONTROLFILE/current.256.1196204797
output file name=+DATA1/DRDB/CONTROLFILE/current.261.1196204797
output file name=+CRS/DRDBNEW/CONTROLFILE/current.257.1202041253

--> 이렇게 하면 변경된 spfile의 control_files 파라미터의 내용에 맞게 control file이 restore 되면서 +CRS 디스크 그룹에도 컨트롤 파일이 생성됨

 

6. 생성된 컨트롤 파일 확인

[2025-05-25:12:21:21][rdb01d]<SYS@DRDBNEW1> show parameter control_files;

NAME           TYPE    VALUE
-------------- ------- --------------------------------------------------
control_files  string    +FRA1/DRDB/CONTROLFILE/current.256.1196204797
                       , +DATA1/DRDB/CONTROLFILE/current.261.1196204797
                       , +CRS/DRDBNEW/CONTROLFILE/current.257.1202041253

 

7. 모든 노드를 shutdown 하고 open 모드로 시작

[DRDBNEW1:oracle@rdb01d][/home/oracle]$ srvctl stop database -db drdbnew
[DRDBNEW1:oracle@rdb01d][/home/oracle]$ srvctl start database -db drdbnew



ora.drdbnew.db
      1        ONLINE  ONLINE       rdb01d                   Open,HOME=/u01/app/o
                                                             racle/product/12c/db
                                                             _1,STABLE
      2        ONLINE  ONLINE       rdb02d                   Open,HOME=/u01/app/o
                                                             racle/product/12c/db
                                                             _1,STABLE

 

8. 컨트롤 파일 확인 (v$controlfile 조회)

[2025-05-25:12:25:10][rdb01d]<SYS@DRDBNEW1> col name for a50
[2025-05-25:12:25:10][rdb01d]<SYS@DRDBNEW1> select name from v$controlfile;

NAME
--------------------------------------------------
+FRA1/DRDB/CONTROLFILE/current.256.1196204797
+DATA1/DRDB/CONTROLFILE/current.261.1196204797
+CRS/DRDBNEW/CONTROLFILE/current.257.1202041253

3 rows selected.

Elapsed: 00:00:00.00