Oracle RAC OCR VOTE 迁移替换

来源:互联网 发布:用友软件官方网 编辑:程序博客网 时间:2024/05/22 12:14
测试环境:
OS:Centos 6.8
数据库:11.2.0.4
节点:RAC1,RAC2,RAC3

测试目的:将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    STATETYPE
------------ ------------------------------ ----------- ------
  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    STATETYPE
------------ ------------------------------ ----------- ------
  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     STATETYPE
------------ ------------------------------ ----------- ------
   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    STATETYPE
------------ ------------------------------ ----------- ------
  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    STATETYPE
------------ ------------------------------ ----------- ------
  1 DATA    MOUNTED EXTERN
  2 FRA_ARC    MOUNTED EXTERN
  3 OCR_VOTING_NEW   MOUNTED NORMAL


至此ocr 迁移(替换)已完成。这里在做每一步操作的时候建议都要看一下crs的日志。


1 0