【RAC】替換OCR磁盤組的步驟（視頻+文檔）

2019 年 10 月 10 日
筆記

今天小麥苗給大家分享的是替換OCR磁盤組的步驟。

【RAC】替換OCR磁盤組的步驟（視頻+文檔）

視頻內容

替換OCR磁盤組的步驟

核心的幾條命令：

crsctl replace votedisk +newocr ocrconfig -add +newocr ocrconfig -delete +ocr more /etc/oracle/ocr.loc spget spcopy -u +CRSDG/xx/asmparameterfile/registry.xx +newocr/spfileASM.ora spset

http://blog.itpub.net/26736162/viewspace-2141215/

2. OCR卷組調整步驟

2.1. 添加新存儲

2.2. 多路徑綁定配置

2.3. ASMLib配置

2.4. 備份OCR

2.5. 新建OCR卷組

2.6. 替換VOTE

2.7. 替換OCR

2.8. 遷移ASM SPFILE

2.9. 確認老OCR磁盤組是否還有其他文件

2.10. 刪除老OCR卷組

2.11. 刪除磁盤

1. 添加新存儲

建立Normal冗餘級別的OCR卷組，需要至少3個LUN，每個LUN最少容量為1GB，需要在存儲端配置3個LUN至RAC集群中的各個節點。

2. 多路徑綁定配置

配置/etc/multipatch.conf，添加新磁盤的UUID，假設多路徑綁定之後的路徑為/dev/mapper/newocr1、/dev/mapper/newocr2、/dev/mapper/newocr3，並且重新加載Mutilpathd服務生效。

3. ASMLib配置或udev綁定

節點1操作如下：

將新加的3個LUN添加到ASMLIB中

# /usr/sbin/oracleasm createdisk OCRNEW1 /dev/mapper/newocr1

# /usr/sbin/oracleasm createdisk OCRNEW2 /dev/mapper/newocr2

# /usr/sbin/oracleasm createdisk OCRNEW3 /dev/mapper/newocr3

節點2：

掃描新加的3個LUN：

# /usr/sbin/oracleasm scandisks

# /usr/sbin/oracleasm listdisks

4. 備份OCR

–邏輯備份恢復

ocrconfig -export /oracle/app/11.2.0/grid/cdata/ZFTPCCDB-crs/export_asm.bak

–物理備份恢復

ocrconfig -manualbackup

ocrconfig -showbackup

ocrcheck

5. 新建OCR卷組

set line 9999

set pagesize 9999

col path format a60

SELECT a.group_number, disk_number,mount_status, a.name, path FROM v$asm_disk a order by a.disk_number;

set line 999

select name,state,free_mb,required_mirror_free_mb,usable_file_mb,a.group_number, disk_number,mount_status, path from v$asm_diskgroup a;

select a.group_number,name,TYPE,state,TOTAL_MB,free_mb from v$asm_diskgroup a;

select name,state,free_mb,required_mirror_free_mb,usable_file_mb,a.group_number from v$asm_diskgroup a;

節點1新建Normal冗餘級別的ASM卷組

sqlplus / as sysasm

create diskgroup newocr normal redundancy disk

'/dev/oracleasm/disks/neworc1',

'/dev/oracleasm/disks/neworc2',

'/dev/oracleasm/disks/neworc3'

attribute 'compatible.asm'='11.2','compatible.rdbms'='11.2';

節點1執行mount磁盤組：

ALTER DISKGROUP NEWOCR MOUNT;

crsctl stat res -t

1.6. 替換VOTE

在其中一個節點，root用戶下執行:

替換VOTE

crsctl replace votedisk +newocr

確認

crsctl query css votedisk

[root@node1 ~]# crsctl replace votedisk +OCR

Successful addition of voting disk 83fc22d0d6164fd2bfc2c48c9edcd64d.

Successful deletion of voting disk afbe52656e124f8ebff3f7236ed85e32.

Successfully replaced voting disk group with +OCR.

CRS-4266: Voting file(s) successfully replaced

[root@node1 ~]# crsctl query css votedisk

## STATE File Universal Id File Name Disk group

— —– —————– ——— ———

1. ONLINE 83fc22d0d6164fd2bfc2c48c9edcd64d (ORCL:OVDISK) [OCR]

Located 1 voting disk(s).

[root@node1 ~]#

7. 替換OCR

在grid或root用戶下執行：

Node1:

ocrconfig -add +newocr

ocrconfig -delete +ocr

more /etc/oracle/ocr.loc

[root@node1 ~]# ocrconfig -add +OCR

[root@node1 ~]# more /etc/oracle/ocr.loc

#Device/file getting replaced by device +OCR

ocrconfig_loc=+TEST

ocrmirrorconfig_loc=+OCR

local_only=false

[root@node1 ~]# ocrconfig -delete +TEST

[root@node1 ~]# more /etc/oracle/ocr.loc

#Device/file +TEST getting replaced by device +OCR

ocrconfig_loc=+OCR

local_only=false

[root@node1 ~]#

Node2不用執行以下命令：

ocrconfig -repair -add +newocr

ocrconfig -repair -delete +ocr

[root@node2 ~]# crsctl query css votedisk

## STATE File Universal Id File Name Disk group

— —– —————– ——— ———

1. ONLINE afbe52656e124f8ebff3f7236ed85e32 (/dev/asm-diskb) [TEST]

Located 1 voting disk(s).

[root@node2 ~]# crsctl query css votedisk

## STATE File Universal Id File Name Disk group

— —– —————– ——— ———

1. ONLINE 83fc22d0d6164fd2bfc2c48c9edcd64d (ORCL:OVDISK) [OCR]

Located 1 voting disk(s).

[root@node2 ~]# more /etc/oracle/ocr.loc

#Device/file +OVDISK getting replaced by device +TEST

ocrconfig_loc=+TEST

local_only=false

[root@node2 ~]# more /etc/oracle/ocr.loc

#Device/file getting replaced by device +OCR

ocrconfig_loc=+TEST

ocrmirrorconfig_loc=+OCR

local_only=false

[root@node2 ~]# more /etc/oracle/ocr.loc

#Device/file +TEST getting replaced by device +OCR

ocrconfig_loc=+OCR

local_only=false

[root@node2 ~]#

8. 遷移ASM SPFILE

在GRID用戶下任一節點執行

$ asmcmd

查看當前的ASMSPFILE

ASMCMD> spget

複製SPFILE至新卷組

ASMCMD> spcopy -u +CRSDG/xx/asmparameterfile/registry.xx +newocr/spfileASM.ora

查看新SPFILE絕對路徑

ASMCMD> ls -l +newocr/spfileASM.ora

+NEWOCR/XX/ASMPARAMETERFILE/REGISTRY.253.833623103

ASMCMD>spset +NEWOCR/XX/ASMPARAMETERFILE/REGISTRY.253.833623103

修改兩個節點grid用戶下$ORACLE_HOME/dbs/init.ora文件內容，可以不用修改：

SPFILE='+newocr/spfileASM.ora'

[grid@node1 ~]$ asmcmd

ASMCMD> spget

+TEST/node-cluster/ASMPARAMETERFILE/REGISTRY.253.936725677

ASMCMD> spcopy -u +TEST/node-cluster/ASMPARAMETERFILE/REGISTRY.253.936725677 +OCR/spfileASM.ora

ASMCMD> ls -l +ocr/spfileASM.ora

Type Redund Striped Time Sys Name

N spfileASM.ora => +OCR/node-cluster/ASMPARAMETERFILE/REGISTRY.253.936729105

ASMCMD> spset +OCR/node-cluster/ASMPARAMETERFILE/REGISTRY.253.936729105

ASMCMD> spget

+OCR/node-cluster/ASMPARAMETERFILE/REGISTRY.253.936729105

9. 確認老OCR磁盤組是否還有其他文件

10. 刪除老OCR卷組

重啟集群後：

節點2：

su – grid

sqlplus / as sysasm

alter diskgroup OCR dismount;

exit

節點1：

su – grid

sqlplus / as sysasm

drop diskgroup ocr;

drop diskgroup OVDISK INCLUDING CONTENTS;

drop diskgroup OVDISK FORCE INCLUDING CONTENTS;

11. 刪除磁盤

任一節點ROOT用戶下操作：

# /usr/sbin/oracleasm dropdisk OCR

刪除多路徑綁定配置，刪除配置/etc/multipatch.conf中原有OCR盤內容。

最後從存儲上刪除到2個節點的映射。

12.刪除crs記錄

crsctl delete res ora.OCR.dg

注意：本文內容太多，公眾號有字數限制，全文可點擊文末的閱讀原文，謝謝大家的理解。