实战：Solaris系统下Oracle 12.2 在线扩容ASM磁盘组操作记录

徐sir（徐慧阳）

已于 2024-04-06 16:38:15 修改

阅读量697

点赞数 9

分类专栏： Oracle数据库记录文章标签：网络服务器 oracle

于 2024-04-06 14:16:17 首次发布

本文链接：https://blog.csdn.net/xxddxhyz/article/details/137427633

版权

Oracle数据库记录专栏收录该内容

39 篇文章 4 订阅

订阅专栏

这篇文章主要是为了记录一下操作，这个假期又要给这套RAC扩容磁盘。

我这套Solaris的小机我还不总操作这玩意，和LINUX有点小差别，整理记录一下，要不每次都是现翻。

存储端划LUN映射到主机

登录到3PAR存储控制台，创建新的VV

创建VV配置

按此配置创建2个卷

选中卷，右键选择Export（映射）

在下一个界面中，选好主机组（也就是我们要映射的RAC主机），实际映射了2个vv这里图有错误说明一下。

确认存储端VV的WWN

主机端格式化磁盘

映射存储之前查看LUN信息，以下操作在2个节点都执行校验一下

root@XDB1:~# format 
Searching for disks...done


AVAILABLE DISK SELECTIONS:
       0. c0t60002AC0000000000000003A00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003a00020a4c
       1. c0t60002AC0000000000000003B00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003b00020a4c
       2. c0t60002AC0000000000000003C00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003c00020a4c
       3. c0t60002AC0000000000000003D00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003d00020a4c
       4. c0t60002AC0000000000000003E00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003e00020a4c
       5. c0t60002AC0000000000000003F00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003f00020a4c
       6. c0t60002AC0000000000000004A00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004a00020a4c
       7. c0t60002AC0000000000000004B00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004b00020a4c
       8. c0t60002AC0000000000000004C00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004c00020a4c
       9. c0t60002AC0000000000000004D00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004d00020a4c
      10. c0t60002AC0000000000000004E00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004e00020a4c
      11. c0t60002AC0000000000000040A00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040a00020a4c
      12. c0t60002AC0000000000000040B00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040b00020a4c
      13. c0t60002AC0000000000000040C00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040c00020a4c
      14. c0t60002AC0000000000000040D00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040d00020a4c
      15. c0t60002AC0000000000000040E00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040e00020a4c
      16. c0t60002AC0000000000000048A00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048a00020a4c
      17. c0t60002AC0000000000000048B00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048b00020a4c
      18. c0t60002AC0000000000000048C00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048c00020a4c
      19. c0t60002AC0000000000000048D00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048d00020a4c
      20. c0t60002AC0000000000000048E00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048e00020a4c
      21. c0t60002AC0000000000000003200020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003200020a4c
      22. c0t60002AC0000000000000003300020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003300020a4c
      23. c0t60002AC0000000000000003400020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003400020a4c
      24. c0t60002AC0000000000000003500020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003500020a4c
      25. c0t60002AC0000000000000003600020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003600020a4c
      26. c0t60002AC0000000000000003700020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003700020a4c
      27. c0t60002AC0000000000000003800020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003800020a4c
      28. c0t60002AC0000000000000003900020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003900020a4c
      29. c0t60002AC0000000000000004000020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004000020a4c
      30. c0t60002AC0000000000000004100020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004100020a4c
      31. c0t60002AC0000000000000004200020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004200020a4c
      32. c0t60002AC0000000000000004300020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004300020a4c
      33. c0t60002AC0000000000000004400020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004400020a4c
      34. c0t60002AC0000000000000004500020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004500020a4c
      35. c0t60002AC0000000000000004900020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004900020a4c
      36. c0t60002AC0000000000000006700020893d0 <3PARdata-VV-3226-200.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000006700020893
      37. c0t60002AC0000000000000008800020893d0 <3PARdata-VV-3226-4.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000008800020893
      38. c1d0 <3PARdata-VV-3226-300.00GB>
          /virtual-devices@100/channel-devices@200/disk@0
      39. c1d1 <3PARdata-VV-3226-300.00GB>
          /virtual-devices@100/channel-devices@200/disk@1

增加映射后使用命令cfgadm -al扫描并查看配置

root@XDB1:~# cfgadm -al
Ap_Id                          Type         Receptacle   Occupant     Condition
c2                             fc-fabric    connected    configured   unknown
c2::100000144ffa3735           unknown      connected    unconfigured unknown
c2::100000144ffa5d2c           unknown      connected    unconfigured unknown
c2::20020002ac020893           disk         connected    configured   unknown
c2::20410002ac0209f4           disk         connected    configured   unknown
c2::20410002ac020a4c           disk         connected    configured   unknown
c2::20510002ac0209f4           disk         connected    configured   unknown
c2::20510002ac020a4c           disk         connected    configured   unknown
c2::21020002ac020893           disk         connected    configured   unknown
c2::21420002ac0209f4           disk         connected    configured   unknown
c2::21420002ac020a4c           disk         connected    configured   unknown
c2::21520002ac0209f4           disk         connected    configured   unknown
c2::21520002ac020a4c           disk         connected    configured   unknown
c3                             fc-fabric    connected    configured   unknown
c3::100000144ffb4fa0           unknown      connected    unconfigured unknown
c3::20010002ac020893           disk         connected    configured   unknown
c3::20420002ac0209f4           disk         connected    configured   unknown
c3::20420002ac020a4c           disk         connected    configured   unknown
c3::20520002ac0209f4           disk         connected    configured   unknown
c3::20520002ac020a4c           disk         connected    configured   unknown
c3::21010002ac020893           disk         connected    configured   unknown
c3::21410002ac0209f4           disk         connected    configured   unknown
c3::21410002ac020a4c           disk         connected    configured   unknown
c3::21510002ac0209f4           disk         connected    configured   unknown
c3::21510002ac020a4c           disk         connected    configured   unknown
c4                             fc-fabric    connected    configured   unknown
c4::100000144ffa3735           unknown      connected    unconfigured unknown
c4::100000144ffacf8b           unknown      connected    unconfigured unknown
c4::20020002ac020893           disk         connected    configured   unknown
c4::20410002ac0209f4           disk         connected    configured   unknown
c4::20410002ac020a4c           disk         connected    configured   unknown
c4::20510002ac0209f4           disk         connected    configured   unknown
c4::20510002ac020a4c           disk         connected    configured   unknown
c4::21020002ac020893           disk         connected    configured   unknown
c4::21420002ac0209f4           disk         connected    configured   unknown
c4::21420002ac020a4c           disk         connected    configured   unknown
c4::21520002ac0209f4           disk         connected    configured   unknown
c4::21520002ac020a4c           disk         connected    configured   unknown
c5                             fc-fabric    connected    configured   unknown
c5::20020002ac020893           disk         connected    configured   unknown
c5::20410002ac0209f4           disk         connected    configured   unknown
c5::20410002ac020a4c           disk         connected    configured   unknown
c5::20510002ac0209f4           disk         connected    configured   unknown
c5::20510002ac020a4c           disk         connected    configured   unknown
c5::21020002ac020893           disk         connected    configured   unknown
c5::21420002ac0209f4           disk         connected    configured   unknown
c5::21420002ac020a4c           disk         connected    configured   unknown
c5::21520002ac0209f4           disk         connected    configured   unknown
c5::21520002ac020a4c           disk         connected    configured   unknown
c6                             fc-fabric    connected    configured   unknown
c6::100000144ff929d5           unknown      connected    unconfigured unknown
c6::100000144ff9c72b           unknown      connected    unconfigured unknown
c6::20010002ac020893           disk         connected    configured   unknown
c6::20420002ac0209f4           disk         connected    configured   unknown
c6::20420002ac020a4c           disk         connected    configured   unknown
c6::20520002ac0209f4           disk         connected    configured   unknown
c6::20520002ac020a4c           disk         connected    configured   unknown
c6::21010002ac020893           ESI          connected    configured   unusable
c6::21410002ac0209f4           disk         connected    configured   unknown
c6::21410002ac020a4c           disk         connected    configured   unknown
c6::21510002ac0209f4           disk         connected    configured   unknown
c6::21510002ac020a4c           disk         connected    configured   unknown
c7                             fc-fabric    connected    configured   unknown
c7::100000144ff929d5           unknown      connected    unconfigured unknown
c7::100000144ffb4fa0           unknown      connected    unconfigured unknown
c7::20010002ac020893           disk         connected    configured   unknown
c7::20420002ac0209f4           disk         connected    configured   unknown
c7::20420002ac020a4c           disk         connected    configured   unknown
c7::20520002ac0209f4           disk         connected    configured   unknown
c7::20520002ac020a4c           disk         connected    configured   unknown
c7::21010002ac020893           disk         connected    configured   unknown
c7::21410002ac0209f4           disk         connected    configured   unknown
c7::21410002ac020a4c           disk         connected    configured   unknown
c7::21510002ac0209f4           disk         connected    configured   unknown
c7::21510002ac020a4c           disk         connected    configured   unknown

之后再format查看磁盘

root@XDB1:~# format 
Searching for disks...done

c0t60002AC0000000000000048F00020A4Cd0: configured with capacity of 2048.00GB
c0t60002AC0000000000000049000020A4Cd0: configured with capacity of 2048.00GB


AVAILABLE DISK SELECTIONS:
       0. c0t60002AC0000000000000003A00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003a00020a4c
       1. c0t60002AC0000000000000003B00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003b00020a4c
       2. c0t60002AC0000000000000003C00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003c00020a4c
       3. c0t60002AC0000000000000003D00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003d00020a4c
       4. c0t60002AC0000000000000003E00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003e00020a4c
       5. c0t60002AC0000000000000003F00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003f00020a4c
       6. c0t60002AC0000000000000004A00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004a00020a4c
       7. c0t60002AC0000000000000004B00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004b00020a4c
       8. c0t60002AC0000000000000004C00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004c00020a4c
       9. c0t60002AC0000000000000004D00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004d00020a4c
      10. c0t60002AC0000000000000004E00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004e00020a4c
      11. c0t60002AC0000000000000040A00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040a00020a4c
      12. c0t60002AC0000000000000040B00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040b00020a4c
      13. c0t60002AC0000000000000040C00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040c00020a4c
      14. c0t60002AC0000000000000040D00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040d00020a4c
      15. c0t60002AC0000000000000040E00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040e00020a4c
      16. c0t60002AC0000000000000048A00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048a00020a4c
      17. c0t60002AC0000000000000048B00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048b00020a4c
      18. c0t60002AC0000000000000048C00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048c00020a4c
      19. c0t60002AC0000000000000048D00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048d00020a4c
      20. c0t60002AC0000000000000048E00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048e00020a4c
      21. c0t60002AC0000000000000048F00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048f00020a4c
      22. c0t60002AC0000000000000003200020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003200020a4c
      23. c0t60002AC0000000000000003300020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003300020a4c
      24. c0t60002AC0000000000000003400020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003400020a4c
      25. c0t60002AC0000000000000003500020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003500020a4c
      26. c0t60002AC0000000000000003600020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003600020a4c
      27. c0t60002AC0000000000000003700020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003700020a4c
      28. c0t60002AC0000000000000003800020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003800020a4c
      29. c0t60002AC0000000000000003900020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003900020a4c
      30. c0t60002AC0000000000000004000020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004000020a4c
      31. c0t60002AC0000000000000004100020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004100020a4c
      32. c0t60002AC0000000000000004200020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004200020a4c
      33. c0t60002AC0000000000000004300020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004300020a4c
      34. c0t60002AC0000000000000004400020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004400020a4c
      35. c0t60002AC0000000000000004500020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004500020a4c
      36. c0t60002AC0000000000000004900020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004900020a4c
      37. c0t60002AC0000000000000049000020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000049000020a4c
      38. c0t60002AC0000000000000006700020893d0 <3PARdata-VV-3226-200.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000006700020893
      39. c0t60002AC0000000000000008800020893d0 <3PARdata-VV-3226-4.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000008800020893
      40. c1d0 <3PARdata-VV-3226-300.00GB>
          /virtual-devices@100/channel-devices@200/disk@0
      41. c1d1 <3PARdata-VV-3226-300.00GB>
          /virtual-devices@100/channel-devices@200/disk@1
Specify disk (enter its number):

比对后可以看出新加的LUN为

37. c0t60002AC0000000000000049000020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000049000020a4c
21. c0t60002AC0000000000000048F00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048f00020a4c

校验一下磁盘的路径数量都是24个，正确。

root@XDB1:~# mpathadm list lu /dev/rdsk/c0t60002AC0000000000000048F00020A4Cd0s2
mpath-support:  libmpscsi_vhci.so
        /dev/rdsk/c0t60002AC0000000000000048F00020A4Cd0s2
                Total Path Count: 24
                Operational Path Count: 24
root@XDB1:~# mpathadm list lu /dev/rdsk/c0t60002AC0000000000000049000020A4Cd0s2
mpath-support:  libmpscsi_vhci.so
        /dev/rdsk/c0t60002AC0000000000000049000020A4Cd0s2
                Total Path Count: 24
                Operational Path Count: 24

对磁盘进行标记，以下操作只在1个节点操作即可，执行format -e对21和37号磁盘进行标记（一定看准备，别搞错了，xshell的话，可以用搜索功能把WWN高亮，避免误操作）

root@XDB1:~# format -e
Searching for disks...done

c0t60002AC0000000000000048F00020A4Cd0: configured with capacity of 2048.00GB
c0t60002AC0000000000000049000020A4Cd0: configured with capacity of 2048.00GB


AVAILABLE DISK SELECTIONS:
       0. c0t60002AC0000000000000003A00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003a00020a4c
       1. c0t60002AC0000000000000003B00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003b00020a4c
       2. c0t60002AC0000000000000003C00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003c00020a4c
       3. c0t60002AC0000000000000003D00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003d00020a4c
       4. c0t60002AC0000000000000003E00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003e00020a4c
       5. c0t60002AC0000000000000003F00020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003f00020a4c
       6. c0t60002AC0000000000000004A00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004a00020a4c
       7. c0t60002AC0000000000000004B00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004b00020a4c
       8. c0t60002AC0000000000000004C00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004c00020a4c
       9. c0t60002AC0000000000000004D00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004d00020a4c
      10. c0t60002AC0000000000000004E00020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004e00020a4c
      11. c0t60002AC0000000000000040A00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040a00020a4c
      12. c0t60002AC0000000000000040B00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040b00020a4c
      13. c0t60002AC0000000000000040C00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040c00020a4c
      14. c0t60002AC0000000000000040D00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040d00020a4c
      15. c0t60002AC0000000000000040E00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000040e00020a4c
      16. c0t60002AC0000000000000048A00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048a00020a4c
      17. c0t60002AC0000000000000048B00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048b00020a4c
      18. c0t60002AC0000000000000048C00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048c00020a4c
      19. c0t60002AC0000000000000048D00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048d00020a4c
      20. c0t60002AC0000000000000048E00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048e00020a4c
      21. c0t60002AC0000000000000048F00020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000048f00020a4c
      22. c0t60002AC0000000000000003200020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003200020a4c
      23. c0t60002AC0000000000000003300020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003300020a4c
      24. c0t60002AC0000000000000003400020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003400020a4c
      25. c0t60002AC0000000000000003500020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003500020a4c
      26. c0t60002AC0000000000000003600020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003600020a4c
      27. c0t60002AC0000000000000003700020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003700020a4c
      28. c0t60002AC0000000000000003800020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003800020a4c
      29. c0t60002AC0000000000000003900020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000003900020a4c
      30. c0t60002AC0000000000000004000020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004000020a4c
      31. c0t60002AC0000000000000004100020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004100020a4c
      32. c0t60002AC0000000000000004200020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004200020a4c
      33. c0t60002AC0000000000000004300020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004300020a4c
      34. c0t60002AC0000000000000004400020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004400020a4c
      35. c0t60002AC0000000000000004500020A4Cd0 <3PARdata-VV-3226-500.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004500020a4c
      36. c0t60002AC0000000000000004900020A4Cd0 <3PARdata-VV-3226-30.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000004900020a4c
      37. c0t60002AC0000000000000049000020A4Cd0 <3PARdata-VV-3226-2.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000049000020a4c
      38. c0t60002AC0000000000000006700020893d0 <3PARdata-VV-3226-200.00GB>
          /scsi_vhci/ssd@g60002ac0000000000000006700020893
      39. c0t60002AC0000000000000008800020893d0 <3PARdata-VV-3226-4.00TB>
          /scsi_vhci/ssd@g60002ac0000000000000008800020893
      40. c1d0 <3PARdata-VV-3226-300.00GB>
          /virtual-devices@100/channel-devices@200/disk@0
      41. c1d1 <3PARdata-VV-3226-300.00GB>
          /virtual-devices@100/channel-devices@200/disk@1
Specify disk (enter its number):  21
selecting c0t60002AC0000000000000048F00020A4Cd0
[disk formatted]
Disk not labeled.  Label it now? y
format> l
[0] SMI Label
[1] EFI Label
Specify Label type[1]: 1
Ready to label disk, continue? y

format> disk 37
selecting c0t60002AC0000000000000049000020A4Cd0
[disk formatted]
Disk not labeled.  Label it now? y
format> l
[0] SMI Label
[1] EFI Label
Specify Label type[1]: 1
Ready to label disk, continue? y
format>   quit

标记完磁盘后，默认的设备权限如下

root@XDB1:/devices/scsi_vhci# ls -l /devices/scsi_vhci/ssd@g60002ac0000000000000049000020a4c:a,raw
crw-r-----   1 root     sys      246, 304 Apr  6 10:47 /devices/scsi_vhci/ssd@g60002ac0000000000000049000020a4c:a,raw
root@XDB1:/devices/scsi_vhci# ls -l  /dev/rdsk/c0t60002AC0000000000000048F00020A4Cd0s0
lrwxrwxrwx   1 root     root          67 Apr  6 10:46 /dev/rdsk/c0t60002AC0000000000000048F00020A4Cd0s0 -> ../../devices/scsi_vhci/ssd@g60002ac0000000000000048f00020a4c:a,raw
root@XDB1:/devices/scsi_vhci# ls -l /devices/scsi_vhci/ssd@g60002ac0000000000000048f00020a4c:a,raw
crw-r-----   1 root     sys      246, 312 Apr  6 10:47 /devices/scsi_vhci/ssd@g60002ac0000000000000048f00020a4c:a,raw
root@XDB1:/devices/scsi_vhci# ls -l /dev/rdsk/c0t60002AC0000000000000049000020A4Cd0s0
lrwxrwxrwx   1 root     root          67 Apr  6 10:46 /dev/rdsk/c0t60002AC0000000000000049000020A4Cd0s0 -> ../../devices/scsi_vhci/ssd@g60002ac0000000000000049000020a4c:a,raw
root@XDB1:/devices/scsi_vhci# ls -l /devices/scsi_vhci/ssd@g60002ac0000000000000049000020a4c:a,raw
crw-r-----   1 root     sys      246, 304 Apr  6 10:47 /devices/scsi_vhci/ssd@g60002ac0000000000000049000020a4c:a,raw

还需要对应的裸设备赋予权限，这个操作需要2个节点都执行

chmod -R 660 /dev/rdsk/c0t60002AC0000000000000048F00020A4Cd0s0
chown -R grid:asmadmin /dev/rdsk/c0t60002AC0000000000000048F00020A4Cd0s0
chmod -R 660 /dev/rdsk/c0t60002AC0000000000000049000020A4Cd0s0
chown -R grid:asmadmin /dev/rdsk/c0t60002AC0000000000000049000020A4Cd0s0

修改权限后，再次校验，这个操作需要2个节点都执行，返回结果都如下所示，表示OK

root@XDB1:~# ls -l /devices/scsi_vhci/ssd@g60002ac0000000000000048f00020a4c:a,raw
crw-rw----   1 grid     asmadmin 246, 312 Apr  6 12:00 /devices/scsi_vhci/ssd@g60002ac0000000000000048f00020a4c:a,raw
root@XDB1:~# ls -l /devices/scsi_vhci/ssd@g60002ac0000000000000049000020a4c:a,raw
crw-rw----   1 grid     asmadmin 246, 304 Apr  6 12:00 /devices/scsi_vhci/ssd@g60002ac0000000000000049000020a4c:a,raw

ASM存储添加磁盘

作为一个爱用图形的，我这里就把图形输出到操作的主机上

主机运行Xmanager - Passive

在Solaris操作系统Grid用户下修改display变量，再执行asmca

export DISPLAY=XXX.XXX.XXX.XXX:0.0
asmca

添加两块状态为candidate的磁盘，注意这里图形界面默认就勾选了label disks using afd

与11G稍有不同，这里添加之后就会触发reblance，需要等待reblance完毕这个图形界面才会弹出成功，但是默认的reblance power 是1，于是我去后台修改一下，把reblance power 改为11。加快一下速度。

期中EST_MINUTES为预估完成时间，等待平衡完毕。

SQL>  select * from v$asm_operation;

GROUP_NUMBER OPERA PASS      STAT      POWER     ACTUAL      SOFAR   EST_WORK
------------ ----- --------- ---- ---------- ---------- ---------- ----------
  EST_RATE EST_MINUTES ERROR_CODE                                       CON_ID
---------- ----------- -------------------------------------------- ----------
           1 REBAL COMPACT   WAIT          1          1          0          0
         0           0                                                       0

           1 REBAL REBALANCE RUN           1          1       8740     839569
     19398          42                                                       0

           1 REBAL REBUILD   DONE          1          1          0          0
         0           0                                                       0

SQL> alter diskgroup DATA1 rebalance power 11;

Diskgroup altered.

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA PASS      STAT      POWER     ACTUAL      SOFAR   EST_WORK
------------ ----- --------- ---- ---------- ---------- ---------- ----------
  EST_RATE EST_MINUTES ERROR_CODE                                       CON_ID
---------- ----------- -------------------------------------------- ----------
           1 REBAL COMPACT   WAIT         11         11          0          0
         0           0                                                       0

           1 REBAL REBALANCE RUN          11         11       1874       1874
     22780           0                                                       0

           1 REBAL REBUILD   DONE         11         11          0          0
         0           0                                                       0

校验存储空间&&扩容表空间

asmcmd lsdg检查一下存储空间,DATA1磁盘组己经增加上4T可用空间

grid@XDB1:~$ asmcmd lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304  10239760    16416                0           16416              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304  23068540  4600668                0         4600668              0             N  DATA1/
MOUNTED  NORMAL  N         512             512   4096  4194304    184248    57440            30708           13366              0             Y  OCRVOTE/

接下来就是扩容表空间了。

这块就没有啥了，直接复制粘贴一堆执行。

alter tablespace xxx add datafile ‘+DATA1’ size 30G;
收工

也欢迎关注我的公众号【徐sir的IT之路】，一起学习！
————————————————————————————
公众号：徐sir的IT之路
CSDN ：https://blog.csdn.net/xxddxhyz?type=blog
墨天轮：https://www.modb.pro/u/3605
PGFANS：https://www.pgfans.cn/user/home?userId=5568
————————————————————————————