{"id":1294,"date":"2021-01-06T11:13:09","date_gmt":"2021-01-06T03:13:09","guid":{"rendered":"http:\/\/www.821121.com\/?p=1294"},"modified":"2021-01-07T11:18:11","modified_gmt":"2021-01-07T03:18:11","slug":"oracle11g-rac%e6%95%b0%e6%8d%ae%e5%ba%93%e6%9b%b4%e6%8d%a2%e5%ad%98%e5%82%a8asm%e7%a3%81%e7%9b%98%ef%bc%88%e4%ba%8c%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1294","title":{"rendered":"Oracle11g RAC\u6570\u636e\u5e93\u66f4\u6362\u5b58\u50a8ASM\u78c1\u76d8\uff08\u4e8c\uff09"},"content":{"rendered":"

4.\u66ff\u6362OCR\u548cvoting\u6240\u8f7d\u7684OCR\u78c1\u76d8\uff08\u5373\u66ff\u6362\u8868\u51b3\u76d8\uff09<\/h1>\n

4.1 ocrcheck<\/h2>\n
[grid@rac1 ~]$ ocrcheck\nStatus of Oracle Cluster Registry is as follows :\n         Version                  :          3\n         Total space (kbytes)     :     262120\n         Used space (kbytes)      :       3248\n         Available space (kbytes) :     258872\n         ID                       :  484258700\n         Device\/File Name         :       +OCR\n                                    Device\/File integrity check succeeded\n\n                                    Device\/File not configured\n\n                                    Device\/File not configured\n\n                                    Device\/File not configured\n\n                                    Device\/File not configured\n\n         Cluster registry integrity check succeeded\n\n         Logical corruption check bypassed due to non-privileged user<\/code><\/pre>\n
4.2\u547d\u4ee4\u52a0\u78c1\u76d8\u7ec4\u4f1a\u51fa\u73b0\u7248\u672c\u8fc7\u4f4e\u9519\u8bef\uff0c\u8fd9\u91cc\u5148\u89e3\u51b3\u9519\u8bef\u3002<\/h2>\n
https:\/\/blog.csdn.net\/u012232730\/article\/details\/83821390   -->\u4e00\u4e9b\u5e94\u8be5\u4e3b\u8981\u7684\u70b9\n\n\u4f7f\u7528\u7684asm\u78c1\u76d8\u7ec4\u7684\u517c\u5bb9\u6027\u5c5e\u6027\u7684\u7248\u672c\u592a\u65e7\nSELECT group_number, name, compatibility, database_compatibility FROM v$asm_diskgroup;  \n\nSQL> set line 9999\nSQL> SELECT group_number, name, compatibility, database_compatibility FROM v$asm_diskgroup;\n\nGROUP_NUMBER NAME                           COMPATIBILITY                                                DATABASE_COMPATIBILITY\n------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------\n           1 ARCH                           11.2.0.0.0                                                   10.1.0.0.0\n           2 DATA                           11.2.0.0.0                                                   10.1.0.0.0\n           3 OCR                            11.2.0.0.0                                                   10.1.0.0.0\n           4 OCR_NEW                        10.1.0.0.0                                                   10.1.0.0.0\n           5 DATA_NEW                       10.1.0.0.0                                                   10.1.0.0.0\n           6 ARCH_NEW                       10.1.0.0.0                                                   10.1.0.0.0\n\n6 rows selected.\n\nALTER DISKGROUP OCR_NEW SET ATTRIBUTE 'compatible.asm' = '11.2';\nALTER DISKGROUP DATA_NEW SET ATTRIBUTE 'compatible.asm' = '11.2';\nALTER DISKGROUP ARCH_NEW SET ATTRIBUTE 'compatible.asm' = '11.2';\n\nALTER DISKGROUP OCR_NEW SET ATTRIBUTE 'compatible.rdbms' = '10.1' sid='*';<\/code><\/pre>\n
4.3 \u8fc1\u79fbOCR(root\u7528\u6237)<\/h2>\n
\/u01\/grid\/11.2.0.4\/bin\/ocrconfig -add +OCR_NEW\n\/u01\/grid\/11.2.0.4\/bin\/ocrcheck\n\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[root@rac1 ~]# \/u01\/grid\/11.2.0.4\/bin\/ocrconfig -add +OCR_NEW\n[root@rac1 ~]# \/u01\/grid\/11.2.0.4\/bin\/ocrcheck\nStatus of Oracle Cluster Registry is as follows :\n         Version                  :          3\n         Total space (kbytes)     :     262120\n         Used space (kbytes)      :       3248\n         Available space (kbytes) :     258872\n         ID                       :  484258700\n         Device\/File Name         :       +OCR\n                                    Device\/File integrity check succeeded\n         Device\/File Name         :   +OCR_NEW\n                                    Device\/File integrity check succeeded\n\n                                    Device\/File not configured\n\n                                    Device\/File not configured\n\n                                    Device\/File not configured\n\n         Cluster registry integrity check succeeded\n\n\u65e5\u5fd7\uff1a\n[crsd(56338)]CRS-1007:The OCR\/OCR mirror location was replaced by +OCR_NEW.\n\n\u67e5\u770b\/etc\/oracle\/ocr.loc\n[root@rac1 ~]# more \/etc\/oracle\/ocr.loc\n#Device\/file  getting replaced by device +OCR_NEW \nocrconfig_loc=+OCR\nocrmirrorconfig_loc=+OCR_NEW\nlocal_only=false\n\n\u5982\u679c\u4ee5\u4e0a\u6ca1\u6709\u6210\u529f\u5219\u6267\u884c\u4e0b\u9762\u7684\u547d\u4ee4\n\/\u5982\u679c\u5728\u65e5\u5fd7\u91cc\u5df2\u7ecf\u67e5\u770bOCR \u5df2\u7ecf\u66ff\u6362\u6210\u529f\uff0c\u5982\u4e0a\u6240\u793a\uff0c\u8fd9\u6b65\u53ef\u4ee5\u4e0d\u6267\u884c\uff08\u6267\u884c\u4e5f\u4e0d\u4f1a\u6709\u5f71\u54cd\uff09\n\/u01\/grid\/11.2.0.4\/bin\/ocrconfig -replace +OCR -replacement +OCR_NEW\nPROT-29: The Oracle Cluster Registry location is already configured\n<\/code><\/pre>\n
4.3 \u8fc1\u79fbvotdisk(grid\u7528\u6237)<\/h2>\n
crsctl query css votedisk(\u67e5\u770bvotedisk\u5b58\u653e\u76ee\u5f55)\ncrsctl replace votedisk +OCR_NEW\ncrsctl query css votedisk\n\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[grid@rac1 ~]$ cd \/u01\/grid\/11.2.0.4\/bin\/\n[grid@rac1 bin]$ crsctl query css votedisk\n##  STATE    File Universal Id                File Name Disk group\n--  -----    -----------------                --------- ---------\n 1. ONLINE   604ad7360acb4fa3bfbaabff736bf9d0 (\/dev\/mapper\/OCR) [OCR]\nLocated 1 voting disk(s).\n[grid@rac1 bin]$ crsctl replace votedisk +OCR_NEW\nSuccessful addition of voting disk b45597b96fe54f75bf101be4398937b0.\nSuccessful addition of voting disk 1a8f153cf7e64f80bf3f47ad71c52249.\nSuccessful addition of voting disk 7dd53ebc8bf74fbcbf19210e55797450.\nSuccessful deletion of voting disk 604ad7360acb4fa3bfbaabff736bf9d0.\nSuccessfully replaced voting disk group with +OCR_NEW.\nCRS-4266: Voting file(s) successfully replaced\n[grid@rac1 bin]$ crsctl query css votedisk\n##  STATE    File Universal Id                File Name Disk group\n--  -----    -----------------                --------- ---------\n 1. ONLINE   b45597b96fe54f75bf101be4398937b0 (\/dev\/mapper\/OCR_NEW1) [OCR_NEW]\n 2. ONLINE   1a8f153cf7e64f80bf3f47ad71c52249 (\/dev\/mapper\/OCR_NEW2) [OCR_NEW]\n 3. ONLINE   7dd53ebc8bf74fbcbf19210e55797450 (\/dev\/mapper\/OCR_NEW3) [OCR_NEW]\nLocated 3 voting disk(s).<\/code><\/pre>\n
4.4\u67e5\u8be2\u4e00\u4e0b\u8d44\u6e90\u72b6\u6001<\/h2>\n
crsctl stat res -t<\/code><\/pre>\n
4.5\u767b\u9646asm\u67e5\u770basmdisk\u4fe1\u606f<\/h2>\n
select group_number,name,state,type from v$asm_diskgroup;\nselect group_number,name,path from v$asm_disk;\n\n\u8fc7\u7a0b\uff1a\n\nSQL> set line 9999\nSQL> select group_number,name,path from v$asm_disk;\n\nGROUP_NUMBER NAME                           PATH\n------------ ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n           3 OCR_0000                       \/dev\/mapper\/OCR\n           2 DATA_0000                      \/dev\/mapper\/DATA\n           1 ARCH_0000                      \/dev\/mapper\/ARCH\n           6 ARCH_NEW                       \/dev\/mapper\/ARCH_NEW\n           4 OCR_NEW_FG3_VOL3               \/dev\/mapper\/OCR_NEW3\n           5 DATA_NEW                       \/dev\/mapper\/DATA_NEW\n           4 OCR_NEW_FG2_VOL2               \/dev\/mapper\/OCR_NEW2\n           4 OCR_NEW_FG1_VOL1               \/dev\/mapper\/OCR_NEW1\n\n8 rows selected.\n\nSQL> select group_number,name,state,type from v$asm_diskgroup;\n\nGROUP_NUMBER NAME                           STATE       TYPE\n------------ ------------------------------ ----------- ------\n           1 ARCH                           MOUNTED     EXTERN\n           2 DATA                           MOUNTED     EXTERN\n           3 OCR                            MOUNTED     EXTERN\n           4 OCR_NEW                        MOUNTED     NORMAL\n           5 DATA_NEW                       MOUNTED     EXTERN\n           6 ARCH_NEW                       MOUNTED     EXTERN\n\n6 rows selected.\n<\/code><\/pre>\n
4.6\u91cd\u5efaASM spfile<\/h2>\n
show parameter spfile;\ncreate pfile='\/u01\/grid\/11.2.0.4\/dbs\/asmpfile.ora' from spfile;\ncreate spfile='+OCR_NEW' from pfile='\/u01\/grid\/11.2.0.4\/dbs\/asmpfile.ora';<\/code><\/pre>\n
4.7\u91cd\u542fcrs,\u67e5\u770b\u73b0\u5728\u7684spfile<\/h2>\n
crsctl stop cluster -all\ncrsctl start cluster -all\nsqlplus \/ as sysasm\nshow parameter spfile<\/code><\/pre>\n
4.8\u5220\u9664\u65e7\u7684OCR\uff08+OCR) -->root\u7528\u6237(\u5254\u9664\u524d\u8981\u67e5\u770bOCR\u6709\u6ca1\u6709\u5176\u4ed6\u6570\u636e)<\/h2>\n
\/u01\/grid\/11.2.0.4\/bin\/ocrconfig -delete +OCR\n\/u01\/grid\/11.2.0.4\/bin\/ocrcheck\n\n\u5220\u9664\u78c1\u76d8\u7ec4+OCR_VOTING\/\/\u8fd9\u91cc\u8981\u6ce8\u610f\u4e00\u4e0b\uff0c\u5148\u8981\u5728\u6240\u6709\u8282\u70b92\u5148\u6267\u884calter diskgroup OCR dismount\uff0c\n\u7136\u540e\u5728\u8282\u70b91\u4e0a\u6267\u884c\uff1a\nselect group_number,name,state,type from v$asm_diskgroup;\ndrop diskgroup  OCR including contents; \n\ndrop diskgroup OCR force including contents;\uff08\u5f3a\u5236\u5220\u9664ASM\u78c1\u76d8\u7ec4\uff09-->\u7279\u6b8a\u60c5\u51b5\u65e0\u6cd5dismount\u4f7f\u7528\nalter diskgroup OCR dismount\ncrsctl delete resource ora.OCR.dg -f\ncrsctl stat res -t\n\u8fd8\u6709\u6267\u884c\u4ee5\u4e0a\u7684\u547d\u4ee4\u8981\u7528sysasm \u7528\u6237\u767b\u9646\uff0c\u4e0d\u7136\u6ca1\u6743\u9650\u6267\u884c\uff0c\n\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[grid@rac2 ~]$ sqlplus \/ as sysasm\n\nSQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 6 16:56:45 2021\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Real Application Clusters and Automatic Storage Management options\n\nSQL> alter diskgroup OCR dismount;\n\nDiskgroup altered.\n\nSQL> set line 9999\nSQL> select group_number,name,state,type from v$asm_diskgroup;\n\nGROUP_NUMBER NAME                           STATE       TYPE\n------------ ------------------------------ ----------- ------\n           1 ARCH_NEW                       MOUNTED     EXTERN\n           2 ARCH                           MOUNTED     EXTERN\n           3 DATA_NEW                       MOUNTED     EXTERN\n           4 DATA                           MOUNTED     EXTERN\n           5 OCR_NEW                        MOUNTED     NORMAL\n           0 OCR                            DISMOUNTED\n\n6 rows selected.\n\n[grid@rac1 ~]$ sqlplus \/ as sysasm\n\nSQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 6 16:57:38 2021\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Real Application Clusters and Automatic Storage Management options\n\nSQL> alter diskgroup OCR dismount\n  2  ;\n\nDiskgroup altered.\n\nSQL> select group_number,name,state,type from v$asm_diskgroup;\n\nGROUP_NUMBER NAME                           STATE       TYPE\n------------ ------------------------------ ----------- ------\n           1 ARCH_NEW                       MOUNTED     EXTERN\n           2 ARCH                           MOUNTED     EXTERN\n           3 DATA_NEW                       MOUNTED     EXTERN\n           4 DATA                           MOUNTED     EXTERN\n           5 OCR_NEW                        MOUNTED     NORMAL\n           0 OCR                            DISMOUNTED\n\n6 rows selected.\n\nSQL> drop diskgroup OCR including contents; \ndrop diskgroup OCR including contents\n*\nERROR at line 1:\nORA-15039: diskgroup not dropped\nORA-15001: diskgroup "OCR" does not exist or is not mounted\n\nSQL> alter diskgroup OCR mount;\n\nDiskgroup altered.\n\nSQL> drop diskgroup  OCR including contents;\n\nDiskgroup dropped.\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
4.\u66ff\u6362OCR\u548cvoting\u6240\u8f7d\u7684OCR\u78c1\u76d8\uff08\u5373\u66ff<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,37],"tags":[],"class_list":["post-1294","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1294"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1294\/revisions"}],"predecessor-version":[{"id":1295,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1294\/revisions\/1295"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1294"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}