前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >【RAC】替换OCR磁盘组的步骤(视频+文档)

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

作者头像
AiDBA宝典
发布2019-09-29 16:45:48
1.1K0
发布2019-09-29 16:45:48
举报
文章被收录于专栏:小麦苗的DB宝专栏

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

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

本文参与 腾讯云自媒体同步曝光计划,分享自微信公众号。
原始发表:2018-07-09,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 DB宝 微信公众号,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 替换OCR磁盘组的步骤
相关产品与服务
文字识别
文字识别(Optical Character Recognition,OCR)基于腾讯优图实验室的深度学习技术,将图片上的文字内容,智能识别成为可编辑的文本。OCR 支持身份证、名片等卡证类和票据类的印刷体识别,也支持运单等手写体识别,支持提供定制化服务,可以有效地代替人工录入信息。
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档