测试目的：将ocr和votedisk从+OCR_VOTING 迁移至+OCR_VOTING_NEW上
具体步骤：
1.准备工作，在RAC 上创建一个+OCR_VOTING_NEW 磁盘组，这里利用asmca进行创建（也可以用命令）创建OCR_VOTING_NEW
这里在asm里就可以查看到（新建的OCR_VOTING_NEW 已经创建成功并且已经mount状态）
+ASM1:/home/grid@rac1>asmcmd -p ASMCMD [+] > lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 51200 47921 0 47921 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 20480 19563 0 19563 0 N FRA_ARC/ MOUNTED NORMAL N 512 4096 1048576 12288 11236 4096 3570 0 Y OCR_VOTING/ MOUNTED NORMAL N 512 4096 1048576 12288 11877 4096 3890 0 N OCR_VOTING_NEW/
2.替换OCR
+ASM1:/home/grid@rac1>ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 3084 Available space (kbytes) : 259036 ID : 759188825 Device/File Name : +OCR_VOTING 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 [root@rac1 bin]# /u01/app/11.2.0/grid_1/bin/ocrconfig -add +OCR_VOTING_NEW [root@rac1 bin]# /u01/app/11.2.0/grid_1/bin/ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 3084 Available space (kbytes) : 259036 ID : 759188825 Device/File Name : +OCR_VOTING Device/File integrity check succeeded Device/File Name : +OCR_VOTING_NEW Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded Logical corruption check succeeded
注意这里查看crs日志，我们发现OCR已经替换，
2017-03-06 09:02:22.160: [crsd(8988)]CRS-1007:The OCR/OCR mirror location was replaced by +OCR_VOTING_NEW.
查看ocr.loc
+ASM1:/home/grid@rac1>more /etc/oracle/ocr.loc #Device/file +OCR_VOTING getting replaced by device +OCR_VOTING_NEW ocrconfig_loc=+OCR_VOTING_NEW local_only=false +ASM1:/home/grid@rac1>
3.迁移OCR //如果在日志里已经查看OCR 已经替换成功，如上所示，这步可以不执行（执行也不会有影响）
[root@rac1 bin]# /u01/app/11.2.0/grid_1/bin/ocrconfig -replace +OCR_VOTING -replacement +OCR_VOTING_NEW PROT-29: The Oracle Cluster Registry location is already configured
4.迁移votdisk
+ASM1:/home/grid@rac1>crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 63f25efe70324f09bf4d4aec0127457b (/dev/asm-diskc) [OCR_VOTING] 2. ONLINE 3906ddbefe474fe2bfa8799b293a30e1 (/dev/asm-diskd) [OCR_VOTING] 3. ONLINE 94f1ff445b974f69bf4e81716289b9a4 (/dev/asm-diske) [OCR_VOTING] Located 3 voting disk(s). +ASM1:/home/grid@rac1>crsctl replace votedisk +OCR_VOTING_NEW Successful addition of voting disk 96680444ba324f25bf80413000858038. Successful addition of voting disk 1510c41101ec4fbebf1f94b50d054e5a. Successful addition of voting disk 889cb38a2f7f4feebffab52c8ad77ec5. Successful deletion of voting disk 63f25efe70324f09bf4d4aec0127457b. Successful deletion of voting disk 3906ddbefe474fe2bfa8799b293a30e1. Successful deletion of voting disk 94f1ff445b974f69bf4e81716289b9a4. Successfully replaced voting disk group with +OCR_VOTING_NEW. CRS-4266: Voting file(s) successfully replaced
查询votedisk 存放目录 +ASM1:/home/grid@rac1>crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 96680444ba324f25bf80413000858038 (/dev/asm-diskh) [OCR_VOTING_NEW] 2. ONLINE 1510c41101ec4fbebf1f94b50d054e5a (/dev/asm-diski) [OCR_VOTING_NEW] 3. ONLINE 889cb38a2f7f4feebffab52c8ad77ec5 (/dev/asm-diskj) [OCR_VOTING_NEW] Located 3 voting disk(s).
查询一下资源状态
+ASM1:/home/grid@rac1>crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.FRA_ARC.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.LISTENER.lsnr ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.OCR_VOTING.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.OCR_VOTING_NEW.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.asm ONLINE ONLINE rac1 Started ONLINE ONLINE rac2 Started ONLINE ONLINE rac3 Started ora.gsd OFFLINE OFFLINE rac1 OFFLINE OFFLINE rac2 OFFLINE OFFLINE rac3 ora.net1.network ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.ons ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac3 ora.cvu 1 ONLINE ONLINE rac3 ora.oc4j 1 ONLINE ONLINE rac3 ora.rac.db 1 ONLINE ONLINE rac1 Open 2 ONLINE ONLINE rac2 Open 3 ONLINE ONLINE rac3 Open ora.rac1.vip 1 ONLINE ONLINE rac1 ora.rac2.vip 1 ONLINE ONLINE rac2 ora.rac3.vip 1 ONLINE ONLINE rac3 ora.scan1.vip 1 ONLINE ONLINE rac3
登陆asm查看asmdisk信息 SQL> select group_number,name,state,type from v$asm_diskgroup; GROUP_NUMBER NAME STATE TYPE ------------ ------------------------------ ----------- ------ 1 DATA MOUNTED EXTERN 2 FRA_ARC MOUNTED EXTERN 3 OCR_VOTING MOUNTED NORMAL 4 OCR_VOTING_NEW MOUNTED NORMAL
SQL> select group_number,name,path from v$asm_disk; GROUP_NUMBER NAME ------------ ------------------------------ PATH -------------------------------------------------------------------------------- 0 /dev/asm-diskk 0 /dev/asm-diskl 4 OCR_VOTING_NEW_0001 /dev/asm-diski GROUP_NUMBER NAME ------------ ------------------------------ PATH -------------------------------------------------------------------------------- 4 OCR_VOTING_NEW_0002 /dev/asm-diskj 4 OCR_VOTING_NEW_0000 /dev/asm-diskh 1 DATA_0000 /dev/asm-diskf GROUP_NUMBER NAME ------------ ------------------------------ PATH -------------------------------------------------------------------------------- 2 FRA_ARC_0000 /dev/asm-diskg 3 OCR_VOTING_0001 /dev/asm-diskd 3 OCR_VOTING_0002 /dev/asm-diske GROUP_NUMBER NAME ------------ ------------------------------ PATH -------------------------------------------------------------------------------- 3 OCR_VOTING_0000 /dev/asm-diskc 10 rows selected.
5.重建ASM spfile
SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string +OCR_VOTING/rac-cluster/asmpar ameterfile/registry.253.937566 111 SQL> create pfile='/u01/app/11.2.0/grid_1/dbs/asmpfile.ora' from spfile; File created. SQL> create spfile='+OCR_VOTING_NEW' from pfile='/u01/app/11.2.0/grid_1/dbs/asmpfile.ora'; File created.
重启crs即可
[root@rac1 bin]# ./crsctl stop cluster -all CRS-2673: Attempting to stop 'ora.crsd' on 'rac1' CRS-2673: Attempting to stop 'ora.crsd' on 'rac3' CRS-2673: Attempting to stop 'ora.crsd' on 'rac2' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1' CRS-2673: Attempting to stop 'ora.OCR_VOTING.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.OCR_VOTING_NEW.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.rac.db' on 'rac1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac3' CRS-2673: Attempting to stop 'ora.OCR_VOTING.dg' on 'rac3' CRS-2673: Attempting to stop 'ora.OCR_VOTING_NEW.dg' on 'rac3' CRS-2673: Attempting to stop 'ora.rac.db' on 'rac3' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac3' CRS-2673: Attempting to stop 'ora.oc4j' on 'rac3' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac3' CRS-2673: Attempting to stop 'ora.cvu' on 'rac3' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.rac3.vip' on 'rac3' CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac3' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac2' CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1' CRS-2673: Attempting to stop 'ora.OCR_VOTING.dg' on 'rac2' CRS-2673: Attempting to stop 'ora.OCR_VOTING_NEW.dg' on 'rac2' CRS-2673: Attempting to stop 'ora.rac.db' on 'rac2' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2' CRS-2677: Stop of 'ora.cvu' on 'rac3' succeeded CRS-2677: Stop of 'ora.scan1.vip' on 'rac3' succeeded CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2' CRS-2677: Stop of 'ora.rac3.vip' on 'rac3' succeeded CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded CRS-2677: Stop of 'ora.rac.db' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.FRA_ARC.dg' on 'rac1' CRS-2677: Stop of 'ora.rac.db' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac3' CRS-2673: Attempting to stop 'ora.FRA_ARC.dg' on 'rac3' CRS-2677: Stop of 'ora.FRA_ARC.dg' on 'rac1' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded CRS-2677: Stop of 'ora.rac.db' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2' CRS-2673: Attempting to stop 'ora.FRA_ARC.dg' on 'rac2' CRS-2677: Stop of 'ora.OCR_VOTING.dg' on 'rac1' succeeded CRS-2677: Stop of 'ora.OCR_VOTING_NEW.dg' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.DATA.dg' on 'rac3' succeeded CRS-2677: Stop of 'ora.FRA_ARC.dg' on 'rac3' succeeded CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac1' CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1' CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed CRS-2677: Stop of 'ora.OCR_VOTING.dg' on 'rac3' succeeded CRS-2677: Stop of 'ora.OCR_VOTING_NEW.dg' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac3' CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded CRS-2677: Stop of 'ora.FRA_ARC.dg' on 'rac2' succeeded CRS-2677: Stop of 'ora.OCR_VOTING.dg' on 'rac2' succeeded CRS-2677: Stop of 'ora.OCR_VOTING_NEW.dg' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2677: Stop of 'ora.asm' on 'rac3' succeeded CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac2' CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2' CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1' CRS-2673: Attempting to stop 'ora.evmd' on 'rac1' CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2' CRS-2673: Attempting to stop 'ora.evmd' on 'rac2' CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded CRS-2677: Stop of 'ora.oc4j' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac3' CRS-2677: Stop of 'ora.ons' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac3' CRS-2677: Stop of 'ora.net1.network' on 'rac3' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac3' has completed CRS-2677: Stop of 'ora.crsd' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac3' CRS-2673: Attempting to stop 'ora.evmd' on 'rac3' CRS-2673: Attempting to stop 'ora.asm' on 'rac3' CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1' CRS-2677: Stop of 'ora.evmd' on 'rac3' succeeded CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac2' CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rac3' succeeded CRS-2677: Stop of 'ora.asm' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac3' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac3' CRS-2677: Stop of 'ora.cssd' on 'rac3' succeeded [root@rac1 bin]# ./crsctl start cluster -all CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1' CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2' CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac3' CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac1' CRS-2672: Attempting to start 'ora.diskmon' on 'rac1' CRS-2676: Start of 'ora.cssdmonitor' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac3' CRS-2672: Attempting to start 'ora.diskmon' on 'rac3' CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac2' CRS-2672: Attempting to start 'ora.diskmon' on 'rac2' CRS-2676: Start of 'ora.diskmon' on 'rac3' succeeded CRS-2676: Start of 'ora.diskmon' on 'rac2' succeeded CRS-2676: Start of 'ora.cssd' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'rac3' CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'rac1' CRS-2676: Start of 'ora.cssd' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'rac2' CRS-2676: Start of 'ora.ctssd' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rac3' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac3' CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rac1' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1' CRS-2676: Start of 'ora.ctssd' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rac2' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac2' CRS-2676: Start of 'ora.evmd' on 'rac3' succeeded CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded CRS-2676: Start of 'ora.evmd' on 'rac2' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac3' CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac1' CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac2' CRS-2676: Start of 'ora.asm' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac3' CRS-2676: Start of 'ora.asm' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac1' CRS-2676: Start of 'ora.asm' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac2' CRS-2676: Start of 'ora.crsd' on 'rac3' succeeded CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded CRS-2676: Start of 'ora.crsd' on 'rac2' succeeded [root@rac1 bin]# su - grid +ASM1:/home/grid@rac1>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 6 09:27:24 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string +OCR_VOTING_NEW/rac-cluster/as mparameterfile/registry.253.93 7905815
6.删除旧的OCR（+OCR_VOTING)
切换root用户
[root@rac1 bin]# ./ocrconfig -delete +OCR_VOTING
删除磁盘组+OCR_VOTING//这里要注意一下，先要在rac2和rac3 上先执行alter diskgroup OCR_VOTING dismount，然后再rac1上执行：
drop diskgroup OCR_VOTING including contents; 还有执行以上的命令要用sysasm 用户登陆，不然没权限执行，具体如下：
rac2：
SQL> alter diskgroup OCR_VOTING dismount; Diskgroup altered. SQL> select group_number,name,state,type from v$asm_diskgroup; GROUP_NUMBER NAME STATE TYPE ------------ ------------------------------ ----------- ------ 1 DATA MOUNTED EXTERN 2 FRA_ARC MOUNTED EXTERN 3 OCR_VOTING_NEW MOUNTED NORMAL 0 OCR_VOTING DISMOUNTED SQL> /
rac3上：
SQL> alter diskgroup OCR_VOTING dismount; Diskgroup altered. SQL> select group_number,name,state,type from v$asm_diskgroup; GROUP_NUMBER NAME STATE TYPE ------------ ------------------------------ ----------- ------ 1 DATA MOUNTED EXTERN 2 FRA_ARC MOUNTED EXTERN 3 OCR_VOTING_NEW MOUNTED NORMAL 0 OCR_VOTING DISMOUNTED SQL> /
rac1上：
SQL> select group_number,name,state,type from v$asm_diskgroup; GROUP_NUMBER NAME STATE TYPE ------------ ------------------------------ ----------- ------ 1 DATA MOUNTED EXTERN 2 FRA_ARC MOUNTED EXTERN 3 OCR_VOTING_NEW MOUNTED NORMAL 4 OCR_VOTING MOUNTED NORMAL
SQL> drop diskgroup OCR_VOTING including contents; Diskgroup dropped. SQL> select group_number,name,state,type from v$asm_diskgroup; GROUP_NUMBER NAME STATE TYPE ------------ ------------------------------ ----------- ------ 1 DATA MOUNTED EXTERN 2 FRA_ARC MOUNTED EXTERN 3 OCR_VOTING_NEW MOUNTED NORMAL 至此ocr 迁移（替换）已完成。这里在做每一步操作的时候建议都要看一下crs的日志。
