更換ocr和votingdisk磁碟組

raysuen發表於2019-11-19
#更換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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章