【RAC】替换OCR磁盘组的步骤(视频+文档)

2019-09-29 16:45:48 浏览数 (1)

今天小麦苗给大家分享的是替换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

注意:本文内容太多,公众号有字数限制,全文可点击文末的阅读原文,谢谢大家的理解。

0 人点赞