{"id":1269,"date":"2015-08-19T12:06:02","date_gmt":"2015-08-19T10:06:02","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=1269"},"modified":"2015-08-19T12:06:02","modified_gmt":"2015-08-19T10:06:02","slug":"redundancia-de-los-votingdisk-en-asm","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/redundancia-de-los-votingdisk-en-asm\/","title":{"rendered":"Redundancia de los votingdisk en ASM"},"content":{"rendered":"<p>Hoy vamos a ver un a entrada sencilla sobre la redundancia en los voting disk.<br \/>\nSupongamos tenemos un RAC con  un votedisk en un grupo de ASM externo.<\/p>\n<pre>\r\n[grid@rac1 ~]$ crsctl query css votedisk\r\n##  STATE    File Universal Id                File Name Disk group\r\n--  -----    -----------------                --------- ---------\r\n 1. ONLINE   9711d76755664f81bfeac1daf04aefcf (\/dev\/oracleasm\/disks\/OCRVOTING) [OCRVOTING]\r\nLocated 1 voting disk(s).\r\n\r\n[grid@rac1 ~]$ ocrcheck\r\nStatus of Oracle Cluster Registry is as follows :\r\n\t Version                  :          3\r\n\t Total space (kbytes)     :     262120\r\n\t Used space (kbytes)      :       2692\r\n\t Available space (kbytes) :     259428\r\n\t ID                       :  241611837\r\n\t Device\/File Name         : +OCRVOTING\r\n                                    Device\/File integrity check succeeded\r\n                                    Device\/File not configured\r\n                                    Device\/File not configured\r\n                                    Device\/File not configured\r\n                                    Device\/File not configured\r\n\t Cluster registry integrity check succeeded\r\n         Logical corruption check bypassed due to non-privileged user\r\n<\/pre>\n<p>Nosotros tenemos un DISKGROUP de ASM con redundancia HIGH , y queremos llevar nuestro votingdisk a este disco .<\/p>\n<pre>\r\ncolumn name format a20;\r\ncolumn state format a20;\r\ncolumn type format a20;\r\nselect NAME,STATE,TYPE from v$asm_diskgroup;\r\n\r\nNAME\t\t     STATE\t\t  TYPE\r\n-------------------- -------------------- --------------------\r\nOCRVOTING\t     MOUNTED\t\t  EXTERN\r\nREDO\t\t     DISMOUNTED\r\nDATA\t\t     MOUNTED\t\t  HIGH\r\nACFS\t\t     DISMOUNTED\r\nOCRASM\t\t     MOUNTED\t\t  EXTERN\r\n<\/pre>\n<p>Ejecutamos el comando <b>crsctl replace votedisk +DATA<\/b> y recibiremos el siguiente error:<\/p>\n<pre>\r\n[grid@rac1 ~]$ crsctl replace votedisk +DATA\r\nFailed to create voting files on disk group DATA.\r\nChange to configuration failed, but was successfully rolled back.\r\nCRS-4000: Command Replace failed, or completed with errors.\r\n<\/pre>\n<h2>\u00bfComo podemos saber mas de este error?<\/h2>\n<p>Vamos a mirar el alert.log del asm <\/p>\n<pre>\r\ntail -900 \/u01\/app\/oracle\/diag\/asm\/+asm\/+ASM1\/trace\/alert_+ASM1.log\r\nTE: [crsctl.bin@rac1.pamplona.name (TNS V1-V3) 20094] opening OCR file\r\nWed Aug 19 11:39:20 2015\r\nNOTE: updated gpnp profile ASM diskstring: \/dev\/oracleasm\/disks\/*\r\nWed Aug 19 11:39:20 2015\r\nNOTE: Creating voting files in diskgroup DATA\r\nWed Aug 19 11:39:20 2015\r\nNOTE: Voting File refresh pending for group 3\/0xe73953ba (DATA)\r\nNOTE: Attempting voting file creation in diskgroup DATA\r\nNOTE: voting file allocation on grp 3 disk DATA_0000\r\nNOTE: voting file allocation on grp 3 disk DATA_0001\r\nNOTE: voting file allocation on grp 3 disk DATA_0002\r\nERROR: Voting file allocation failed for group DATA\r\nErrors in file \/u01\/app\/oracle\/diag\/asm\/+asm\/+ASM1\/trace\/+ASM1_ora_20102.trc:\r\n<\/pre>\n<p>Y que error tenemos en este fichero de traza?<\/p>\n<pre>\r\ncat \/u01\/app\/oracle\/diag\/asm\/+asm\/+ASM1\/trace\/+ASM1_ora_20102.trc\r\n..\r\n.\r\n\r\n*** 2015-08-19 11:39:24.754\r\nUpdating headers of disk \/dev\/oracleasm\/disks\/ASM03 with 96 128\r\nPST-new:0x7f6053f8fe60:0x9f1d9478:45:\r\n  \/dev\/oracleasm\/disks\/ASM03:67f2cd24882e4f46bfe07f85554e0d33:\r\nORA-15274: Not enough failgroups (5) to create voting files\r\n<\/pre>\n<p>Como podemos ver, el GRID ha visto que nuestro grupo de ASM no cuenta con 5 failgroups ( solamente cuenta con 3 discos), con lo que ha echado atr\u00e1s la operaci\u00f3n.<\/p>\n<h2> Que pasar\u00eda si quisiesemos llevarlo a otro external? <\/h2>\n<p>Si queremos llevarlo a otro external veremos que funciona correctamente.<\/p>\n<pre>\r\n[grid@rac1 ~]$ crsctl replace votedisk  +OCRASM\r\nSuccessful addition of voting disk 5f3f3404c2cd4f24bfa6ca5de9494bba.\r\nSuccessful deletion of voting disk 9711d76755664f81bfeac1daf04aefcf.\r\nSuccessfully replaced voting disk group with +OCRASM.\r\nCRS-4266: Voting file(s) successfully replaced\r\n<\/pre>\n<p>Y si quisi\u00e9ramos a\u00f1adir otra ASM con redundancia external?<\/p>\n<pre>\r\n[grid@rac1 ~]$ crsctl add css votedisk +OCRVOTING\r\nCRS-4671: This command is not supported for ASM diskgroups.\r\nCRS-4000: Command Add failed, or completed with errors.\r\n<\/pre>\n<p>Vemos como tampoco nos permite el poner el voting disk en 2 ASM DISKGROUPS<\/p>\n<h1> Conclusiones<\/h1>\n<p>Podemos beneficiarnos (y es aconsejable) de la redundancia del ASM para el voting disk, pero, hay que tener en cuenta que :<\/p>\n<ul>\n<li> No podemos mezclar voting disk en asm y no asm\n<li> Voting disk necesita unos determinados failugre groups en ASM\n<ul>\n<li> <b>External<\/b>: No ha dependencia ya que se gestiona externamente\n<li> <b> Normal<\/b>: Deberemos de tener un m\u00ednimo de 3 failgroups\n<li> <b> External<\/b>: deberemos de terner un m\u00ednimo de 5 failgroups\n<\/ul>\n<li> Si usamos ASM para los voting disk la redundancia la marca el ASM\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver un a entrada sencilla sobre la redundancia en los voting disk. Supongamos tenemos un RAC con un votedisk en un grupo de ASM externo. [grid@rac1 ~]$ crsctl query css votedisk ## STATE File Universal Id File &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/redundancia-de-los-votingdisk-en-asm\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,60,42,43,49],"tags":[229,230],"class_list":["post-1269","post","type-post","status-publish","format-standard","hentry","category-11g","category-12c","category-asm","category-grid","category-rac","tag-crscrl-add-css-voting-disk","tag-ora-15274"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=1269"}],"version-history":[{"count":11,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1269\/revisions"}],"predecessor-version":[{"id":1280,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1269\/revisions\/1280"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1269"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}