Oracle ASM磁盘组扩容(AIX7.1)

博主： Tehran
发布时间：2022 年 02 月 17 日
293 次浏览
暂无评论
15888字数
分类： Oracle

Oracle ASM磁盘组扩容(AIX7.1)
环境：

DB:Oracle RAC+DG 11.2.0.4.0

OS:AIX 7.1

操作：

扩容DG备库ASM磁盘组

一：查看磁盘属性

(1)存储工程师已经添加磁盘，8块100G数据盘，2块50G归档盘

(2)新加磁盘为/dev/rhdiskpower21到/dev/rhdiskpower30

[dpc-cjcdb-db01][/]#ls -l /dev/rhdiskpower*
......
crw-rw----    1 root     system       48, 21 Aug 27 19:31 /dev/rhdiskpower21
crw-rw----    1 root     system       48, 22 Aug 27 19:31 /dev/rhdiskpower22
crw-rw----    1 root     system       48, 23 Aug 27 19:31 /dev/rhdiskpower23
crw-rw----    1 root     system       48, 24 Aug 27 19:31 /dev/rhdiskpower24
crw-rw----    1 root     system       48, 25 Aug 27 19:31 /dev/rhdiskpower25
crw-rw----    1 root     system       48, 26 Aug 27 19:31 /dev/rhdiskpower26
crw-rw----    1 root     system       48, 27 Aug 27 19:31 /dev/rhdiskpower27
crw-rw----    1 root     system       48, 28 Aug 27 19:31 /dev/rhdiskpower28
crw-rw----    1 root     system       48, 29 Aug 27 19:31 /dev/rhdiskpower29
crw-rw----    1 root     system       48, 30 Aug 27 19:31 /dev/rhdiskpower30
......

二：修改新加磁盘属性(节点一和节点二)

[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower21
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower22
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower23
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower24
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower25
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower26
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower27
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower28
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower29
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower30
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower21
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower22
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower23
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower24
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower25
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower26
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower27
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower28
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower29
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower30

查看磁盘属性是否修改成功(节点一和节点二)

[dpc-cjcdb-db01][/]#ls -l /dev/rhdiskpower*
......
crw-rw----    1 grid     asmadmin     48, 21 Aug 27 19:31 /dev/rhdiskpower21
crw-rw----    1 grid     asmadmin     48, 22 Aug 27 19:31 /dev/rhdiskpower22
crw-rw----    1 grid     asmadmin     48, 23 Aug 27 19:31 /dev/rhdiskpower23
crw-rw----    1 grid     asmadmin     48, 24 Aug 27 19:31 /dev/rhdiskpower24
crw-rw----    1 grid     asmadmin     48, 25 Aug 27 19:31 /dev/rhdiskpower25
crw-rw----    1 grid     asmadmin     48, 26 Aug 27 19:31 /dev/rhdiskpower26
crw-rw----    1 grid     asmadmin     48, 27 Aug 27 19:31 /dev/rhdiskpower27
crw-rw----    1 grid     asmadmin     48, 28 Aug 27 19:31 /dev/rhdiskpower28
crw-rw----    1 grid     asmadmin     48, 29 Aug 27 19:31 /dev/rhdiskpower29
crw-rw----    1 grid     asmadmin     48, 30 Aug 27 19:31 /dev/rhdiskpower30
......

三：检查reserve_policy模式，reserve_policy是no_reserve

lsattr -El hdiskpower21 | grep reserve_policy
lsattr -El hdiskpower22 | grep reserve_policy
lsattr -El hdiskpower23 | grep reserve_policy
lsattr -El hdiskpower24 | grep reserve_policy
lsattr -El hdiskpower25 | grep reserve_policy
lsattr -El hdiskpower26 | grep reserve_policy
lsattr -El hdiskpower27 | grep reserve_policy
lsattr -El hdiskpower28 | grep reserve_policy
lsattr -El hdiskpower29 | grep reserve_policy
lsattr -El hdiskpower30 | grep reserve_policy
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower21 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower22 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower23 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower24 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower25 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower26 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower27 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower28 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower29 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower30 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower21 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower22 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower23 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower24 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower25 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower26 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower27 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower28 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower29 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower30 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True

如不是no_reserve，进行修改

###chdev -l hdiskpower21 -a reserve_policy=no_reserve
###chdev -l hdiskpower22 -a reserve_policy=no_reserve
###chdev -l hdiskpower23 -a reserve_policy=no_reserve
###chdev -l hdiskpower24 -a reserve_policy=no_reserve
###chdev -l hdiskpower25 -a reserve_policy=no_reserve
###chdev -l hdiskpower26 -a reserve_policy=no_reserve
###chdev -l hdiskpower27 -a reserve_policy=no_reserve
###chdev -l hdiskpower28 -a reserve_policy=no_reserve
###chdev -l hdiskpower29 -a reserve_policy=no_reserve
###chdev -l hdiskpower30 -a reserve_policy=no_reserve

四：检查现有磁盘组信息

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME                           STATE         TOTAL_MB    FREE_MB
------------ ------------------------------ ----------- ---------- ----------
           1 DUNHUA_DAPUCHAI_cjcdb_OCR                MOUNTED           6186       5260
           2 DUNHUA_DAPUCHAI_cjcdb_DATA               MOUNTED         819208      85512
           3 DUNHUA_DAPUCHAI_cjcdb_ARCH               MOUNTED         102400      45200

检查磁盘信息

SQL> set line 200
col path for a40
select group_number,mount_status,header_status,path,total_mb,free_mb from v$asm_disk;SQL> SQL> 
GROUP_NUMBER MOUNT_S HEADER_STATU PATH                                       TOTAL_MB    FREE_MB
------------ ------- ------------ ---------------------------------------- ---------- ----------
           0 CLOSED  CANDIDATE    /dev/rhdiskpower21                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower22                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower23                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower24                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower25                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower26                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower27                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower28                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower29                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower30                                0          0
           1 CACHED  MEMBER       /dev/rhdiskpower10                             2062       1753
           3 CACHED  MEMBER       /dev/rhdiskpower11                            51200      22591
           3 CACHED  MEMBER       /dev/rhdiskpower12                            51200      22609
           2 CACHED  MEMBER       /dev/rhdiskpower13                           102401      10685
           2 CACHED  MEMBER       /dev/rhdiskpower14                           102401      10693
           2 CACHED  MEMBER       /dev/rhdiskpower15                           102401      10693
           2 CACHED  MEMBER       /dev/rhdiskpower16                           102401      10687
           2 CACHED  MEMBER       /dev/rhdiskpower17                           102401      10683
           2 CACHED  MEMBER       /dev/rhdiskpower18                           102401      10690
           2 CACHED  MEMBER       /dev/rhdiskpower19                           102401      10688
           2 CACHED  MEMBER       /dev/rhdiskpower20                           102401      10693
           1 CACHED  MEMBER       /dev/rhdiskpower8                              2062       1753
           1 CACHED  MEMBER       /dev/rhdiskpower9                              2062       1754
23 rows selected.

五：asmca启动图形add disk(也可以使用命令行扩容)

su - grid
export DISPLAY=10.100.100.20:3.0 【xmanager端口号】
asmca

点击add disks
为DATA磁盘组新增磁盘。
为ARCH磁盘组新增磁盘。

六：检查再平衡进度，磁盘组空间

su - grid
sqlplus / as sysasm
select group_number,operation,state,power,actual,sofar,est_work,est_rate,est_minutes,error_code from v$asm_operation;
select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

查看总容量是否增加

su - grid
asmcmd
lsdg

查看磁盘信息

SQL> set line 200
col path for a40
select group_number,mount_status,header_status,path,total_mb,free_mb from v$asm_disk;SQL> SQL> 
GROUP_NUMBER MOUNT_S HEADER_STATU PATH                                       TOTAL_MB    FREE_MB
------------ ------- ------------ ---------------------------------------- ---------- ----------
           1 CACHED  MEMBER       /dev/rhdiskpower10                             2062       1753
           3 CACHED  MEMBER       /dev/rhdiskpower11                            51200      22591
           3 CACHED  MEMBER       /dev/rhdiskpower12                            51200      22609
           2 CACHED  MEMBER       /dev/rhdiskpower13                           102401      14766
           2 CACHED  MEMBER       /dev/rhdiskpower14                           102401      14773
           2 CACHED  MEMBER       /dev/rhdiskpower15                           102401      14773
           2 CACHED  MEMBER       /dev/rhdiskpower16                           102401      14768
           2 CACHED  MEMBER       /dev/rhdiskpower17                           102401      14764
           2 CACHED  MEMBER       /dev/rhdiskpower18                           102401      14769
           2 CACHED  MEMBER       /dev/rhdiskpower19                           102401      14769
           2 CACHED  MEMBER       /dev/rhdiskpower20                           102401      14774
           1 CACHED  MEMBER       /dev/rhdiskpower8                              2062       1753
           1 CACHED  MEMBER       /dev/rhdiskpower9                              2062       1754
           3 CACHED  MEMBER       /dev/rhdiskpower21                            51200      51198
           3 CACHED  MEMBER       /dev/rhdiskpower22                            51200      51198
           2 CACHED  MEMBER       /dev/rhdiskpower23                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower24                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower25                           102401      98319
           2 CACHED  MEMBER       /dev/rhdiskpower26                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower27                           102401      98319
           2 CACHED  MEMBER       /dev/rhdiskpower28                           102401      98319
           2 CACHED  MEMBER       /dev/rhdiskpower29                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower30                           102401      98318
23 rows selected.

查看磁盘组信息

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME                           STATE         TOTAL_MB    FREE_MB
------------ ------------------------------ ----------- ---------- ----------
           1 DUNHUA_DAPUCHAI_cjcdb_OCR                MOUNTED           6186       5260
           2 DUNHUA_DAPUCHAI_cjcdb_DATA               MOUNTED        1638416     904704
           3 DUNHUA_DAPUCHAI_cjcdb_ARCH               MOUNTED         204800     147596

查看平衡度

默认power=1，单块盘数据平衡预计需要44分钟

SQL> set line 200   
SQL> select group_number,operation,state,power,actual,sofar,est_work,est_rate,est_minutes,error_code from v$asm_operation; 
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
           2 REBAL RUN           1          1      19750     366830       7730          44
           3 REBAL WAIT          1

查看告警日志

......
Tue Sep 01 18:00:11 2020
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0008 (8.3932265494) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0009 (9.3932265495) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0010 (10.3932265496) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0011 (11.3932265497) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0012 (12.3932265498) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0013 (13.3932265499) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0014 (14.3932265500) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0015 (15.3932265501) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
Tue Sep 01 18:01:21 2020
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_ARCH_0002 (2.3932265502) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_ARCH
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_ARCH_0003 (3.3932265503) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_ARCH
......

文章来源：chenoracle

最后修改：2022 年 02 月 17 日

如果觉得我的文章对你有用，请随意赞赏

发表评论取消回复
# 请输入真实的邮箱地址便于接收回复

评论 *

私密评论

名称 *

🎲

邮箱 *

地址

Oracle ASM磁盘组扩容(AIX7.1)

Tehran • 2022 年 02 月 17 日

<div class="tip share">请注意，本文编写于 798 天前，最后修改于 798 天前，其中某些信息可能已经过时。</div>

<p>Oracle ASM磁盘组扩容(AIX7.1)<br>环境：</p><p>DB:Oracle RAC+DG 11.2.0.4.0</p><p>OS:AIX 7.1</p><p>操作：</p><p>扩容DG备库ASM磁盘组</p><h3>一：查看磁盘属性</h3><p>(1)存储工程师已经添加磁盘，8块100G数据盘，2块50G归档盘</p><p>(2)新加磁盘为/dev/rhdiskpower21到/dev/rhdiskpower30</p><pre><code>[dpc-cjcdb-db01][/]#ls -l /dev/rhdiskpower*
......
crw-rw----    1 root     system       48, 21 Aug 27 19:31 /dev/rhdiskpower21
crw-rw----    1 root     system       48, 22 Aug 27 19:31 /dev/rhdiskpower22
crw-rw----    1 root     system       48, 23 Aug 27 19:31 /dev/rhdiskpower23
crw-rw----    1 root     system       48, 24 Aug 27 19:31 /dev/rhdiskpower24
crw-rw----    1 root     system       48, 25 Aug 27 19:31 /dev/rhdiskpower25
crw-rw----    1 root     system       48, 26 Aug 27 19:31 /dev/rhdiskpower26
crw-rw----    1 root     system       48, 27 Aug 27 19:31 /dev/rhdiskpower27
crw-rw----    1 root     system       48, 28 Aug 27 19:31 /dev/rhdiskpower28
crw-rw----    1 root     system       48, 29 Aug 27 19:31 /dev/rhdiskpower29
crw-rw----    1 root     system       48, 30 Aug 27 19:31 /dev/rhdiskpower30
......</code></pre><h3>二：修改新加磁盘属性(节点一和节点二)</h3><pre><code>[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower21
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower22
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower23
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower24
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower25
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower26
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower27
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower28
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower29
[dpc-cjcdb-db01][/]#chmod 660 /dev/rhdiskpower30
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower21
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower22
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower23
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower24
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower25
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower26
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower27
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower28
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower29
[dpc-cjcdb-db01][/]#chown grid:asmadmin /dev/rhdiskpower30</code></pre><p><strong>查看磁盘属性是否修改成功(节点一和节点二)</strong></p><pre><code>[dpc-cjcdb-db01][/]#ls -l /dev/rhdiskpower*
......
crw-rw----    1 grid     asmadmin     48, 21 Aug 27 19:31 /dev/rhdiskpower21
crw-rw----    1 grid     asmadmin     48, 22 Aug 27 19:31 /dev/rhdiskpower22
crw-rw----    1 grid     asmadmin     48, 23 Aug 27 19:31 /dev/rhdiskpower23
crw-rw----    1 grid     asmadmin     48, 24 Aug 27 19:31 /dev/rhdiskpower24
crw-rw----    1 grid     asmadmin     48, 25 Aug 27 19:31 /dev/rhdiskpower25
crw-rw----    1 grid     asmadmin     48, 26 Aug 27 19:31 /dev/rhdiskpower26
crw-rw----    1 grid     asmadmin     48, 27 Aug 27 19:31 /dev/rhdiskpower27
crw-rw----    1 grid     asmadmin     48, 28 Aug 27 19:31 /dev/rhdiskpower28
crw-rw----    1 grid     asmadmin     48, 29 Aug 27 19:31 /dev/rhdiskpower29
crw-rw----    1 grid     asmadmin     48, 30 Aug 27 19:31 /dev/rhdiskpower30
......</code></pre><h3>三：检查reserve_policy模式，reserve_policy是no_reserve</h3><pre><code>lsattr -El hdiskpower21 | grep reserve_policy
lsattr -El hdiskpower22 | grep reserve_policy
lsattr -El hdiskpower23 | grep reserve_policy
lsattr -El hdiskpower24 | grep reserve_policy
lsattr -El hdiskpower25 | grep reserve_policy
lsattr -El hdiskpower26 | grep reserve_policy
lsattr -El hdiskpower27 | grep reserve_policy
lsattr -El hdiskpower28 | grep reserve_policy
lsattr -El hdiskpower29 | grep reserve_policy
lsattr -El hdiskpower30 | grep reserve_policy
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower21 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower22 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower23 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower24 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower25 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower26 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower27 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower28 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower29 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db01][/]#lsattr -El hdiskpower30 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower21 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower22 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower23 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower24 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower25 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower26 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower27 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower28 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower29 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True
[dpc-cjcdb-db02][/]#lsattr -El hdiskpower30 | grep reserve_policy
reserve_policy no_reserve         Reserve Policy used to reserve device on open. True</code></pre><p><strong>如不是no_reserve，进行修改</strong></p><pre><code>###chdev -l hdiskpower21 -a reserve_policy=no_reserve
###chdev -l hdiskpower22 -a reserve_policy=no_reserve
###chdev -l hdiskpower23 -a reserve_policy=no_reserve
###chdev -l hdiskpower24 -a reserve_policy=no_reserve
###chdev -l hdiskpower25 -a reserve_policy=no_reserve
###chdev -l hdiskpower26 -a reserve_policy=no_reserve
###chdev -l hdiskpower27 -a reserve_policy=no_reserve
###chdev -l hdiskpower28 -a reserve_policy=no_reserve
###chdev -l hdiskpower29 -a reserve_policy=no_reserve
###chdev -l hdiskpower30 -a reserve_policy=no_reserve</code></pre><h3>四：检查现有磁盘组信息</h3><pre><code>SQL&gt; select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME                           STATE         TOTAL_MB    FREE_MB
------------ ------------------------------ ----------- ---------- ----------
           1 DUNHUA_DAPUCHAI_cjcdb_OCR                MOUNTED           6186       5260
           2 DUNHUA_DAPUCHAI_cjcdb_DATA               MOUNTED         819208      85512
           3 DUNHUA_DAPUCHAI_cjcdb_ARCH               MOUNTED         102400      45200</code></pre><p><strong>检查磁盘信息</strong></p><pre><code>SQL&gt; set line 200
col path for a40
select group_number,mount_status,header_status,path,total_mb,free_mb from v$asm_disk;SQL&gt; SQL&gt; 
GROUP_NUMBER MOUNT_S HEADER_STATU PATH                                       TOTAL_MB    FREE_MB
------------ ------- ------------ ---------------------------------------- ---------- ----------
           0 CLOSED  CANDIDATE    /dev/rhdiskpower21                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower22                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower23                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower24                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower25                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower26                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower27                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower28                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower29                                0          0
           0 CLOSED  CANDIDATE    /dev/rhdiskpower30                                0          0
           1 CACHED  MEMBER       /dev/rhdiskpower10                             2062       1753
           3 CACHED  MEMBER       /dev/rhdiskpower11                            51200      22591
           3 CACHED  MEMBER       /dev/rhdiskpower12                            51200      22609
           2 CACHED  MEMBER       /dev/rhdiskpower13                           102401      10685
           2 CACHED  MEMBER       /dev/rhdiskpower14                           102401      10693
           2 CACHED  MEMBER       /dev/rhdiskpower15                           102401      10693
           2 CACHED  MEMBER       /dev/rhdiskpower16                           102401      10687
           2 CACHED  MEMBER       /dev/rhdiskpower17                           102401      10683
           2 CACHED  MEMBER       /dev/rhdiskpower18                           102401      10690
           2 CACHED  MEMBER       /dev/rhdiskpower19                           102401      10688
           2 CACHED  MEMBER       /dev/rhdiskpower20                           102401      10693
           1 CACHED  MEMBER       /dev/rhdiskpower8                              2062       1753
           1 CACHED  MEMBER       /dev/rhdiskpower9                              2062       1754
23 rows selected.</code></pre><h3>五：asmca启动图形add disk(也可以使用命令行扩容)</h3><pre><code>su - grid
export DISPLAY=10.100.100.20:3.0 【xmanager端口号】
asmca</code></pre><p>点击add disks<br>为DATA磁盘组新增磁盘。<br>为ARCH磁盘组新增磁盘。</p><h3>六：检查再平衡进度，磁盘组空间</h3><pre><code>su - grid
sqlplus / as sysasm
select group_number,operation,state,power,actual,sofar,est_work,est_rate,est_minutes,error_code from v$asm_operation;
select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;</code></pre><p><strong>查看总容量是否增加</strong></p><pre><code>su - grid
asmcmd
lsdg</code></pre><p><strong>查看磁盘信息</strong></p><pre><code>SQL&gt; set line 200
col path for a40
select group_number,mount_status,header_status,path,total_mb,free_mb from v$asm_disk;SQL&gt; SQL&gt; 
GROUP_NUMBER MOUNT_S HEADER_STATU PATH                                       TOTAL_MB    FREE_MB
------------ ------- ------------ ---------------------------------------- ---------- ----------
           1 CACHED  MEMBER       /dev/rhdiskpower10                             2062       1753
           3 CACHED  MEMBER       /dev/rhdiskpower11                            51200      22591
           3 CACHED  MEMBER       /dev/rhdiskpower12                            51200      22609
           2 CACHED  MEMBER       /dev/rhdiskpower13                           102401      14766
           2 CACHED  MEMBER       /dev/rhdiskpower14                           102401      14773
           2 CACHED  MEMBER       /dev/rhdiskpower15                           102401      14773
           2 CACHED  MEMBER       /dev/rhdiskpower16                           102401      14768
           2 CACHED  MEMBER       /dev/rhdiskpower17                           102401      14764
           2 CACHED  MEMBER       /dev/rhdiskpower18                           102401      14769
           2 CACHED  MEMBER       /dev/rhdiskpower19                           102401      14769
           2 CACHED  MEMBER       /dev/rhdiskpower20                           102401      14774
           1 CACHED  MEMBER       /dev/rhdiskpower8                              2062       1753
           1 CACHED  MEMBER       /dev/rhdiskpower9                              2062       1754
           3 CACHED  MEMBER       /dev/rhdiskpower21                            51200      51198
           3 CACHED  MEMBER       /dev/rhdiskpower22                            51200      51198
           2 CACHED  MEMBER       /dev/rhdiskpower23                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower24                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower25                           102401      98319
           2 CACHED  MEMBER       /dev/rhdiskpower26                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower27                           102401      98319
           2 CACHED  MEMBER       /dev/rhdiskpower28                           102401      98319
           2 CACHED  MEMBER       /dev/rhdiskpower29                           102401      98318
           2 CACHED  MEMBER       /dev/rhdiskpower30                           102401      98318
23 rows selected.</code></pre><p><strong>查看磁盘组信息</strong></p><pre><code>SQL&gt; select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME                           STATE         TOTAL_MB    FREE_MB
------------ ------------------------------ ----------- ---------- ----------
           1 DUNHUA_DAPUCHAI_cjcdb_OCR                MOUNTED           6186       5260
           2 DUNHUA_DAPUCHAI_cjcdb_DATA               MOUNTED        1638416     904704
           3 DUNHUA_DAPUCHAI_cjcdb_ARCH               MOUNTED         204800     147596</code></pre><p><strong>查看平衡度</strong></p><p>默认power=1，单块盘数据平衡预计需要44分钟</p><pre><code>SQL&gt; set line 200   
SQL&gt; select group_number,operation,state,power,actual,sofar,est_work,est_rate,est_minutes,error_code from v$asm_operation; 
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
           2 REBAL RUN           1          1      19750     366830       7730          44
           3 REBAL WAIT          1</code></pre><p><strong>查看告警日志</strong></p><pre><code>......
Tue Sep 01 18:00:11 2020
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0008 (8.3932265494) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0009 (9.3932265495) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0010 (10.3932265496) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0011 (11.3932265497) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0012 (12.3932265498) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0013 (13.3932265499) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0014 (14.3932265500) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_DATA_0015 (15.3932265501) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_DATA
Tue Sep 01 18:01:21 2020
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_ARCH_0002 (2.3932265502) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_ARCH
SUCCESS: disk DUNHUA_DAPUCHAI_cjcdb_ARCH_0003 (3.3932265503) added to diskgroup DUNHUA_DAPUCHAI_cjcdb_ARCH
......</code></pre><p>文章来源：<a href="https://uuks.cn/go/aHR0cDovL2Jsb2cuaXRwdWIubmV0LzI5Nzg1ODA3L3ZpZXdzcGFjZS0yNzE3NDA5Lw" target="_blank" >chenoracle</a></p>

Oracle ASM磁盘组扩容(AIX7.1)

一：查看磁盘属性

二：修改新加磁盘属性(节点一和节点二)

三：检查reserve_policy模式，reserve_policy是no_reserve

四：检查现有磁盘组信息

五：asmca启动图形add disk(也可以使用命令行扩容)

六：检查再平衡进度，磁盘组空间

相关文章

发表评论取消回复
# 请输入真实的邮箱地址便于接收回复

handsome 换字体

Oracle 数据库常用安装包合集（包含基础版和最新补丁集202107）

超全 Linux 安装包合集(Centos Redhat Oracle Linux)

本站typecho 主题版本修改的东西(8.40版本和typecho开发版1.2)

影视资源站接口

oracle存储过程常用语法及其使用

群晖NAS docker 部署 frps 实现直连内网远程办公

SQL优化

Kettle 使用详解

Oracle精读67_某个用户被限制100个并发连接

Oracle ASM磁盘组扩容(AIX7.1)

一：查看磁盘属性

二：修改新加磁盘属性(节点一和节点二)

三：检查reserve_policy模式，reserve_policy是no_reserve

四：检查现有磁盘组信息

五：asmca启动图形add disk(也可以使用命令行扩容)

六：检查再平衡进度，磁盘组空间

相关文章

发表评论 取消回复 # 请输入真实的邮箱地址便于接收回复

Oracle ASM磁盘组扩容(AIX7.1)

发表评论取消回复
# 请输入真实的邮箱地址便于接收回复