[Oracle] OCR VIGING DISK 재구성

1 OCR,VOTING 유실시 복구

RAC 운영중 여러가지 형태로 장애로 인한 RAC를 재구성 하는 일이 발생할 때 빠른

복구를 하기위해 OCR VIGING DISK 재구성으로 문제를 해결할 수있습니다.

CRS구성 파라메터
10G	$GRID_HOME/css_install/rootconfig
(11G, 12c)	/u01/app/18.0.0.0/grid/crs/install/crsconfig_params

 

2 절차

1) CSR정보 Deconfig (각각 노드별 root로 수행)
         GRID_HOME/crs/install/rootcrs.pl -deconfig -force –verbose

2) CRSCONFIG_PARMS 정보 수정 (Master Node에서 root로 수행)
 vi $GRID_HOME/crs/install/crsconfig_params  

ASM_DISKS=/dev/raw/raw1,/dev/raw/raw2,/dev/raw/raw3 

 

- 새로 사용할 ASM 구성용 RAW DEVICE Path

- REDUNDANCY가 NORMAL일 경우 3개이상, EXTERNAL일 경우 1개 이상 기입

- 기존 설정 값은 ASM_REDUNDANCY 참조

-  RAW DEVICE를 재사용 할 경우 DD를 이용해 RAW DEVICE초기화

 

3) GPNP정보 삭제 (각각 노드별 root로 수행) : crsconfig_params 보다 우선적으로 수행

   - $GRID_HOME/gpnp/profile/peer/profile.xml 파일삭제

   - $GRID_HOME/gpnp/{HOTNAME} 경로삭제

 

 

*GPnP(grid plug n play) : https://horullll.tistory.com/89

 

4) root.sh 수행 (각각 노드별 root로 수행)

  -  1번노드 CRS 재구성

  $GRID_HOME/root.sh

  -   2번노드 CRS 재구성

  $GRID_HOME/root.sh

 

5) Resource 등록 (각 노드별 수행 oracle유져)

 

-리스너 추가 (1번 또는 2번노드 한쪽에서만 수행)

srvctl add listener -l 리스너이름 -o 그리드홈

 

-ASM 등록 (1번 또는 2번노드 한쪽에서만 수행)

srvctl add asm -l 리스너이름

 

-디스크그룹 마운트 (1,2번 노드에서 모두 수행)

export ORACLE_HOME=/oracle/11.2.0/grid

export ORACLE_SID=+ASM1

 

sqlplus / as sysasm

 

alter diskgroup 디스크그룹명 mount;

 or ASMCA 를 이용해서 MOUNT

 

-DB등록 (1,2번 노드에서 모두 수행)

srvctl add database -d 디비이름 -o 오라클홈

 

-인스턴스등록(1,2번 노드에서 모두 수행)

srvctl add instance -d 디비이름 -i 인스턴스명 -n 노드명

srvctl add instance -d 디비이름 -i 인스턴스명 -n 노드명

 

3 . OCR & VOTING 및 서비스 확인

[RAC1]l-rac1:/home/oracle> ocrcheck Status of Oracle Cluster Registry is as follows :         Version                  :          3         Total space (kbytes)     :     262120         Used space (kbytes)      :       3076         Available space (kbytes) :     259044         ID                       :  293887148         Device/File Name         :  +OCR_VOTE                                     Device/File integrity check succeeded                                       Device/File not configured                                       Device/File not configured                                       Device/File not configured                                       Device/File not configured           Cluster registry integrity check succeeded                 Logical corruption check bypassed due to non-privileged user   [RAC1]l-rac1:/home/oracle> crsctl query css votedisk ##  STATE    File Universal Id                File Name Disk group --  -----    -----------------                --------- --------- 1. ONLINE   439a0e9cda384f3ebf35ab4f0ed060ac (/dev/raw/raw1) [OCR_VOTE] Located 1 voting disk(s).   [RAC1]l-rac1:/home/oracle> crsctl stat res -t -init -------------------------------------------------------------------------------- NAME           TARGET  STATE        SERVER                   STATE_DETAILS       -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm     1        ONLINE  ONLINE       l-rac1                   Started             ora.cluster_interconnect.haip    1        ONLINE  ONLINE       l-rac1                                       ora.crf     1        ONLINE  ONLINE       l-rac1                                       ora.crsd       1        ONLINE  ONLINE       l-rac1                                       ora.cssd       1        ONLINE  ONLINE       l-rac1                                       ora.cssdmonitor       1        ONLINE  ONLINE       l-rac1                                       ora.ctssd       1        ONLINE  ONLINE       l-rac1                   ACTIVE:0            ora.diskmon       1        OFFLINE OFFLINE                                                   ora.drivers.acfs       1        ONLINE  ONLINE       l-rac1                                        ora.evmd       1        ONLINE  ONLINE       l-rac1                                       ora.gipcd       1        ONLINE  ONLINE       l-rac1                                       ora.gpnpd       1        ONLINE  ONLINE       l-rac1                                        ora.mdnsd       1        ONLINE  ONLINE       l-rac1