虚拟机模拟部署Extended Clusters(二)asm配置注意事项

  1. 云栖社区>
  2. 博客>
  3. 正文

虚拟机模拟部署Extended Clusters(二)asm配置注意事项

snowofsummer 2019-09-17 14:37:46 浏览3813
展开阅读全文

/dev/oracleasm/disks/DISK03 仲裁磁盘(QUORUM disk)

prod01磁盘(/dev/oracleasm/disks/VOTEDB01,/dev/oracleasm/disks/NODE01DATA01)

prod02磁盘(/dev/oracleasm/disks/VOT02,/dev/oracleasm/disks/NODE02DATA01)

注意设置磁盘组属性:11.2.0.0.0(COMPATIBILITY,DATABASE_COMPATIBILITY)

_asm_storagemaysplit 建议设置为TRUE

OCR ,VOTEDISK 分2个磁盘组存放

补丁信息:18317531

ocr 配置

[grid@prod01 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       3052
     Available space (kbytes) :     259068
     ID                       :  204222775
     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 bypassed due to non-privileged user

votedisk 信息

[grid@prod01 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   88080bfc44de4f54bfccdd8b0151aef6 (/dev/oracleasm/disks/DISK03) [CRS]
 2. ONLINE   a7e97bcb21484f29bf65b043e90f5db2 (/dev/oracleasm/disks/VOT02) [CRS]
 3. ONLINE   91d97d42bcfa4fd0bf1788a668986541 (/dev/oracleasm/disks/VOTEDB01) [CRS]
Located 3 voting disk(s).

asm 磁盘信息:

SQL>  col name for a39
SQL>  select a.ksppinm name, b.ksppstvl value, a.ksppdesc describe
  2     from x$ksppi a, x$ksppcv b
   where a.inst_id = userenv('Instance')
   and b.inst_id = userenv('Instance')
   and a.indx = b.indx
   and a.ksppinm like '\_asm_storagemaysplit%' escape '\'
  order by name;  3    4    5    6    7  

NAME                    VALUE     DESCRIBE
--------------------------------------- -------- ----------------------------------------------------------------------
_asm_storagemaysplit            TRUE     PST Split Possible

SQL> @c

DG_NAME     DG_STATE   TYPE       DSK_NO DSK_NAME    PATH                           MOUNT_S FAILGROUP        STATE
--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------
CRS        MOUNTED    NORMAL       2 CRS_0002    /dev/oracleasm/disks/DISK03               CACHED  ZCDISK        NORMAL
CRS        MOUNTED    NORMAL       5 CRS_0005    /dev/oracleasm/disks/VOTEDB02               CACHED  CRS_0001        NORMAL
CRS        MOUNTED    NORMAL       9 CRS_0009    /dev/oracleasm/disks/VOTEDB01               CACHED  CRS_0000        NORMAL
OCR        MOUNTED    NORMAL       0 OCR_0000    /dev/oracleasm/disks/NODE01DATA01           CACHED  OCR_0000        NORMAL
OCR        MOUNTED    NORMAL       1 OCR_0001    /dev/oracleasm/disks/NODE02DATA01           CACHED  OCR_0001        NORMAL


DISK_NUMBER NAME       PATH                          HEADER_STATUS         OS_MB   TOTAL_MB    FREE_MB REPAIR_TIMER V FAILGRO
----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------
      0 OCR_0000   /dev/oracleasm/disks/NODE01DATA01          MEMBER             5120    5120       3185        0 N REGULAR
      1 OCR_0001   /dev/oracleasm/disks/NODE02DATA01          MEMBER             5120    5120       3185        0 N REGULAR
      9 CRS_0009   /dev/oracleasm/disks/VOTEDB01              MEMBER             2048    2048       1584        0 Y REGULAR
      5 CRS_0005   /dev/oracleasm/disks/VOTEDB02              MEMBER             2048    2048       1648        0 Y REGULAR
      2 CRS_0002   /dev/oracleasm/disks/DISK03              MEMBER             5115    5115       5081        0 Y QUORUM


GROUP_NUMBER NAME    COMPATIBILITY                             DATABASE_COMPATIBILITY                      V
------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ -
       1 OCR    11.2.0.0.0                             11.2.0.0.0                           N
       2 CRS    11.2.0.0.0                             11.2.0.0.0                           Y

SQL>

网友评论

登录后评论
0/500
评论
snowofsummer
+ 关注