OCR 개념, 관리

Oracle Clusterware Repository의 약자, RAC 상의 모든 Node들에 대한 Clusterware 구성 정보를 저장고 있는 저장소

장애 발생에 대비하여 기본적으로 자동 백업이 설정되어 있다.

 

무결성 확인 (루트 유저로 하면 에러남)

[root@node01 bin]# ./cluvfy comp ocr -n all -verbose

You must NOT be logged in as root (uid=0) when running ./cluvfy.

[root@node01 bin]# cluvfy comp ocr -n all -verbose

bash: cluvfy: command not found...

[root@node01 bin]# ./cluvfy comp ocr -n all -verbose

You must NOT be logged in as root (uid=0) when running ./cluvfy.

[root@node01 bin]# su grid

[grid@node01 bin]$ cluvfy comp ocr -n all -verbose

bash: cluvfy: command not found...

[grid@node01 bin]$ ./cluvfy comp ocr -n all -verbose

 

Verifying OCR Integrity ...WARNING (PRVG-6017)

 

Verification of OCR integrity was successful.

 

 

Warnings were encountered during execution of CVU verification request "OCR integrity".

 

Verifying OCR Integrity ...WARNING

PRVG-6017 : OCR backup is located in the same disk group "+OCR_VOTE" as OCR.

 

 

CVU operation performed:      OCR integrity

Date:                         Nov 24, 2020 2:29:15 AM

CVU home:                     /u01/app/12.2.0/grid/

User:                         grid

[grid@node01 bin]$

 

ocr 백업

[grid@node01 bin]$ ./ocrconfig -showbackup

node01     2020/11/18 21:13:30     +OCR_VOTE:/node-cluster/OCRBACKUP/backup00.ocr.258.1056834807     2197668489

node01     2020/11/18 17:13:27     +OCR_VOTE:/node-cluster/OCRBACKUP/backup01.ocr.263.1056820403     2197668489

node01     2020/11/18 13:13:23     +OCR_VOTE:/node-cluster/OCRBACKUP/backup02.ocr.262.1056806001     2197668489

node01     2020/11/18 05:13:15     +OCR_VOTE:/node-cluster/OCRBACKUP/day.ocr.259.     1056777197     2197668489

node01     2020/11/18 05:13:15     +OCR_VOTE:/node-cluster/OCRBACKUP/week.ocr.260.    1056777197     2197668489

PROT-25: Manual backups for the Oracle Cluster Registry are not available

 

[root@node01 bin]# ./ocrconfig -showbackup

node01     2020/11/18 21:13:30     +OCR_VOTE:/node-cluster/OCRBACKUP/backup00.ocr.258.1056834807     2197668489

node01     2020/11/18 17:13:27     +OCR_VOTE:/node-cluster/OCRBACKUP/backup01.ocr.263.1056820403     2197668489

node01     2020/11/18 13:13:23     +OCR_VOTE:/node-cluster/OCRBACKUP/backup02.ocr.262.1056806001     2197668489

node01     2020/11/18 05:13:15     +OCR_VOTE:/node-cluster/OCRBACKUP/day.ocr.259.1056777197     2197668489

node01     2020/11/18 05:13:15     +OCR_VOTE:/node-cluster/OCRBACKUP/week.ocr.260.1056777197     2197668489

node02     2020/11/24 02:36:16     +OCR_VOTE:/node-cluster/OCRBACKUP/backup_20201124_023616.ocr.261.1057286177     2197668489    

[root@node01 bin]#

 

매뉴얼 백업 실행 시 마스터 노드가 아닌 곳에서 백업이 실행됨. 백업 실행은 root만 가능