[2025-05-29] RAC환경에서 ORACLE LOCAL REGISTRY(OLR) 실습 (12cR2)

kyoungoh.lee 2025. 7. 13. 00:19

2025. 7. 13. 00:19

오라클 로컬 레지스트리(OLR)에는 OHASD에서 요구하는 노드별 정보가 포함되어 있음
모든 노드는 고유한 전용 OLR 파일을 가지고 있음 (노드 간에 공유되지 않음, 노드간의 공유하는건 ASM영역에 있는 OCR파일임)
OCR 파일이 ASM 디스크 그룹에 존재하기 때문에 CRS를 시작하는 동안 클러스터 리소스 정보를 찾기 위해 OCR 파일에 액세스할 수 없음
이 시점에서는 ASM 인스턴스도 다운될 것이기 때문에 우선 로컬 파일 시스템 내에 있는 OLR파일로 기동시켜야함
결국 OLR 파일에 문제가 생기거나 유실되면 노드가 기동되지 않음

1. 테스트 환경 정보

OS : Oracle Linux Server 7.9 (Linux rdb01d 5.4.17-2102.201.3.el7uek.x86_64)
DB : Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
RAC1 : rdb01d(192.168.0.31) : DRDB1
RAC2 : rdb01d(192.168.0.32) : DRDB2

2. OLR 관련 명령어 실습

2-1. OLR 경로 확인

[+ASM1:grid@rdb01d][/home/grid]$ ls -l $GRID_HOME/cdata/*olr*
-rw-------. 1 root oinstall 503484416 May 29 20:03 /u01/app/12c/grid/cdata/rdb01d.olr
--> 해당 위치에 OLR 파일이 존재함

2-2. OLR 정보 확인

[root@rdb01d][/root]$ strings /u01/app/12c/grid/cdata/rdb01d.olr

--> strings 명령어로 해당 파일을 볼수 있음

2-3. OLR 백업 정보 확인

--RAC1
[DRDB1:oracle@rdb01d][/home/oracle]$ $GRID_HOME/bin/ocrconfig -local -showbackup
rdb01d     2025/05/09 22:07:20     /u01/app/12c/grid/cdata/rdb01d/autobackup_20250509_220720.olr     3975995681
rdb01d     2025/05/08 22:07:18     /u01/app/12c/grid/cdata/rdb01d/autobackup_20250508_220718.olr     3975995681
rdb01d     2025/03/18 07:15:39     /u01/app/12c/grid/cdata/rdb01d/backup_20250318_071539.olr     3975995681

--RAC2
[DRDB2:oracle@rdb02d][/home/oracle]$ $GRID_HOME/bin/ocrconfig -local -showbackup
rdb02d     2025/05/09 22:08:02     /u01/app/12c/grid/cdata/rdb02d/autobackup_20250509_220802.olr     3975995681
rdb02d     2025/05/08 22:08:00     /u01/app/12c/grid/cdata/rdb02d/autobackup_20250508_220800.olr     3975995681
rdb02d     2025/03/18 09:10:04     /u01/app/12c/grid/cdata/rdb02d/backup_20250318_091004.olr     3975995681

2-4. OLR 수동 백업 (root os user)

--RAC1
[root@rdb01d][/root]$ $GRID_HOME/bin/ocrconfig -local -manualbackup
rdb01d     2025/05/29 20:30:08     /u01/app/12c/grid/cdata/rdb01d/backup_20250529_203008.olr     3975995681
rdb01d     2025/03/18 07:15:39     /u01/app/12c/grid/cdata/rdb01d/backup_20250318_071539.olr     3975995681



--RAC2
[root@rdb02d][/root]$ $GRID_HOME/bin/ocrconfig -local -manualbackup
rdb02d     2025/05/29 20:30:23     /u01/app/12c/grid/cdata/rdb02d/backup_20250529_203023.olr     3975995681
rdb02d     2025/03/18 09:10:04     /u01/app/12c/grid/cdata/rdb02d/backup_20250318_091004.olr     3975995681

2-5. OLR 무결성 체크

--RAC1
[+ASM1:grid@rdb01d][/home/grid]$ cluvfy comp olr
Verifying OLR Integrity ...PASSED

Verification of OLR integrity was successful.

CVU operation performed:      OLR integrity
Date:                         May 29, 2025 8:30:57 PM
CVU home:                     /u01/app/12c/grid/
User:                         grid

--RAC2
[+ASM2:grid@rdb02d][/home/grid]$ cluvfy comp olr
Verifying OLR Integrity ...PASSED
Verification of OLR integrity was successful.

CVU operation performed:      OLR integrity
Date:                         May 29, 2025 8:38:11 PM
CVU home:                     /u01/app/12c/grid/
User:                         grid

2-6. OLR 상태 체크

--RAC1
[root@rdb01d][/root]$ $GRID_HOME/bin/ocrcheck -local
Status of Oracle Local Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     409568
         Used space (kbytes)      :       1120
         Available space (kbytes) :     408448
         ID                       :  998820114
         Device/File Name         : /u01/app/12c/grid/cdata/rdb01d.olr
                                    Device/File integrity check succeeded

         Local registry integrity check succeeded

         Logical corruption check succeeded


--RAC2
[root@rdb02d][/root]$ $GRID_HOME/bin/ocrcheck -local
Status of Oracle Local Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     409568
         Used space (kbytes)      :       1120
         Available space (kbytes) :     408448
         ID                       :  536423483
         Device/File Name         : /u01/app/12c/grid/cdata/rdb02d.olr
                                    Device/File integrity check succeeded

         Local registry integrity check succeeded

         Logical corruption check succeeded

2-7. OLR 정보를 텍스트로 출력

$GRID_HOME/bin/ocrdump -local -stdout

2-8. OLR 정보를 날린 후 복구해보기

[+ASM2:grid@rdb02d][/home/grid]$ cd $GRID_HOME/cdata
[+ASM2:grid@rdb02d][/u01/app/12c/grid/cdata]$ ls -l
total 1548
drwxrwxr-x. 2 grid oinstall         6 Mar 18 09:02 drdb
drwxr-xr-x. 2 grid oinstall         6 Mar 18 09:02 localhost
drwxr-xr-x. 2 grid oinstall      4096 May 29 20:30 rdb02d
-rw-------. 1 root oinstall 503484416 May 29 20:39 rdb02d.olr

[DRDB2:oracle@rdb02d][/home/oracle]$ $GRID_HOME/bin/ocrconfig -local -showbackup
rdb02d     2025/05/29 20:30:23     /u01/app/12c/grid/cdata/rdb02d/backup_20250529_203023.olr     3975995681
rdb02d     2025/05/09 22:08:02     /u01/app/12c/grid/cdata/rdb02d/autobackup_20250509_220802.olr     3975995681
rdb02d     2025/05/08 22:08:00     /u01/app/12c/grid/cdata/rdb02d/autobackup_20250508_220800.olr     3975995681
rdb02d     2025/03/18 09:10:04     /u01/app/12c/grid/cdata/rdb02d/backup_20250318_091004.olr     3975995681

--> 여기서 OLR 파일을 삭제함
[root@rdb02d][/root]$ rm -f /u01/app/12c/grid/cdata/rdb02d.olr

[root@rdb02d][/root]$ crsctl stop crs
[root@rdb02d][/u01/app/12c/grid/cdata]$ crsctl start crs
PROCL-26: Error while accessing the physical storage Operating System error [No such file or directory] [2]
CRS-4000: Command Start failed, or completed with errors.
--> OLR이 없어서 노드가 기동되지 않음

[root@rdb02d][/u01/app/12c/grid/cdata]$ touch rdb02d.olr
[root@rdb02d][/u01/app/12c/grid/cdata]$ ocrconfig -local -restore /u01/app/12c/grid/cdata/rdb02d/backup_20250529_203023.olr
[root@rdb02d][/u01/app/12c/grid/cdata]$ ls -l *olr
-rw-r--r--. 1 root root 503484416 May 29 21:07 rdb02d.olr

--crsctl stat res -t 로 확인
[root@rdb02d][/u01/app/12c/grid/cdata]$ csrt
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
ora.CRS.dg
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
ora.DATA1.dg
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
ora.FRA1.dg
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
ora.MGMT.dg
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
ora.net1.network
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
ora.ons
               ONLINE  ONLINE       rdb01d                   STABLE
               ONLINE  ONLINE       rdb02d                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rdb02d                   STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rdb01d                   STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rdb01d                   STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       rdb01d                   Started,STABLE
      2        ONLINE  ONLINE       rdb02d                   Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rdb01d                   STABLE
ora.drdb.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
ora.qosmserver
      1        ONLINE  ONLINE       rdb01d                   STABLE
ora.rdb01d.vip
      1        ONLINE  ONLINE       rdb01d                   STABLE
ora.rdb02d.vip
      1        ONLINE  ONLINE       rdb02d                   STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rdb02d                   STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rdb01d                   STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rdb01d                   STABLE
--------------------------------------------------------------------------------
--> 노드가 제대로 기동됨을 확인

'Oracle > RAC' 카테고리의 다른 글

[2025-05-31] RAC환경에서 Scan Name 변경 (12cR2) (0)	2025.07.18
[2025-05-29] Interconnect Private IP 정보 변경(네트워크 인터페이스명 변경) (12cR2) (0)	2025.07.13
[2025-05-26] RAC환경에서 스캔 리스너 포트 설정 변경 (12cR2 기준) (1)	2025.07.11
[2025-05-25] 2 Node RAC 환경에서 drop database (12cR2) (1)	2025.07.10
[2025-05-25] 2 Node RAC 환경에서 redo log 추가 및 제거 실습 (12cR2) (3)	2025.07.09

db-expert

[2025-05-29] RAC환경에서 ORACLE LOCAL REGISTRY(OLR) 실습 (12cR2)

1. 테스트 환경 정보

2. OLR 관련 명령어 실습

2-1. OLR 경로 확인

2-2. OLR 정보 확인

2-3. OLR 백업 정보 확인

2-4. OLR 수동 백업 (root os user)

2-5. OLR 무결성 체크

2-6. OLR 상태 체크

2-7. OLR 정보를 텍스트로 출력

2-8. OLR 정보를 날린 후 복구해보기

'Oracle > RAC' 카테고리의 다른 글

+ Recent posts

티스토리툴바