ITPub博客

首页 > 数据库 > Oracle > 更换ocr和votingdisk磁盘组

更换ocr和votingdisk磁盘组

原创 Oracle 作者:raysuen 时间:2019-11-19 08:44:42 0 删除 编辑
#更换OCR
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2948
         Available space (kbytes) :     259172
         ID                       :  717216655
         Device/File Name         :       +OCR
                                    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 succeeded
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/ ocrconfig -add +OCR02
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2964
         Available space (kbytes) :     259156
         ID                       :  717216655
         Device/File Name         :       +OCR
                                    Device/File integrity check succeeded
         Device/File Name         :     +OCR02
                                    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
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/ ocrconfig -delete +OCR
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2964
         Available space (kbytes) :     259156
         ID                       :  717216655
         Device/File Name         :     +OCR02
                                    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 succeeded
#更换votingdisk
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
1. ONLINE   062be79c0d644f2ebf102c21b47b3f3b (/dev/sdb) [OCR]
Located 1 voting disk(s).
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/ crsctl replace votedisk +OCR02
Successful addition of voting disk 082d31c3fd1e4f5ebf0310f8cef501d8.
Successful deletion of voting disk 062be79c0d644f2ebf102c21b47b3f3b.
Successfully replaced voting disk group with +OCR02.
CRS-4266: Voting file(s) successfully replaced
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/crsctl query css votedisk     
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
1. ONLINE   082d31c3fd1e4f5ebf0310f8cef501d8 (/dev/sde) [OCR02]
Located 1 voting disk(s).
#迁移asm实例的spfile文件
SQL> conn / as sysdba
Connected.
SQL> show parameter pfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +OCR/raccluster/asmparameterfi
                                                 le/registry.253.1019126787
SQL> create pfile='/home/grid/initASM.ora' from spfile;
File created.
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/srvctl stop instance -d racdb -n ray32
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/srvctl stop instance -d racdb -n ray31
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/srvctl stop asm -o abort -f

SQL> startup pfile='/home/grid/initASM.ora';
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size                  2260728 bytes
Variable Size            1108320520 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> create spfile='+OCR02' from pfile='/home/grid/initASM.ora';
File created.
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/srvctl stop asm -o abort -f
[grid@ray31 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 18 15:57:40 2019
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
SQL> conn / as sysasm
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size                  2260728 bytes
Variable Size            1108320520 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +OCR02/raccluster/asmparameter
                                                 file/registry.253.1024674953
SQL>
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/crsctl stop cluster -all   
[root@ray31 ~]# /u01/app/gridhome/product/11.2.0/grid_1/bin/crsctl start cluster -all   
#删除磁盘组
#在其他节点执行
SQL> alter diskgroup ocr dismount;    
Diskgroup altered.
#其中一个节点执行删除磁盘组
SQL> drop diskgroup OCR including contents;
Diskgroup dropped. 


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28572479/viewspace-2664723/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 迁移ASM磁盘组
下一篇: 没有了~
请登录后发表评论 登录
全部评论
擅长oracle,Linux。精通shell,python。

注册时间:2016-08-23

  • 博文量
    124
  • 访问量
    126882