热门搜索
分布式
数据库一体机
云数据库
建设银行
保险核心
密集交易
登录
注册
Aix小机存储扩容
技术分享/
文章详情
/
Aix小机存储扩容
l
2024/06/21
967
2
0
操作系统版本 aix 7.2
数据库架构 oracle 11g RAC
一.备份
操作前做好备份，有条件可做好前一天的备份恢复
二.操作前规划
# lspv
hdisk0 00c27f10c3ab9680 rootvg active
hdisk1 00c27f1018b6cdd4 rootvg active
hdisk2 none None
hdisk3 none None
hdisk4 none None
hdisk5 none None
hdisk6 none None
hdisk7 none None
hdisk8 none None
hdisk7 是200GB创建+RLOG分区
hdisk8 是1TB增加到+DATA
三.修改磁盘属性
– 查看磁盘属性
lsattr -El hdisk7 | grep reserve
lsattr -El hdisk8 | grep reserve
– 修改磁盘属性
– node1
chdev -l hdisk7 -a reserve_policy=no_reserve
chdev -l hdisk8 -a reserve_policy=no_reserve
– node2
chdev -l hdisk7 -a reserve_policy=no_reserve
chdev -l hdisk8 -a reserve_policy=no_reserve
–磁盘属组及权限
– 查看权限
ls -l /dev/rhisk*
# ls -l /dev/rhdisk*
crw------- 2 root system 15, 0 May 29 17:23 /dev/rhdisk0
crw------- 1 root system 15, 1 Jan 04 2019 /dev/rhdisk1
crw-rw---- 1 grid asmadmin 15, 2 Jun 15 13:52 /dev/rhdisk2
crw-rw---- 1 grid asmadmin 15, 6 Jun 15 13:53 /dev/rhdisk3
crw-rw---- 1 grid asmadmin 15, 5 Jun 15 13:53 /dev/rhdisk4
crw-rw---- 1 grid asmadmin 15, 3 Jan 04 2019 /dev/rhdisk5
crw-rw---- 1 grid asmadmin 15, 4 May 29 19:20 /dev/rhdisk6
crw------- 1 root system 15, 7 Dec 16 2019 /dev/rhdisk7
crw------- 1 root system 15, 8 May 29 18:34 /dev/rhdisk8
两个节点分别执行
– 修改权限
chown grid:asmadmin /dev/rhdisk7
chown grid:asmadmin /dev/rhdisk8
chmod 660 /dev/rhdisk7
chmod 660 /dev/rhdisk8
# ls -l /dev/rhdisk*
crw------- 2 root system 15, 0 May 29 17:23 /dev/rhdisk0
crw------- 1 root system 15, 1 Jan 04 2019 /dev/rhdisk1
crw-rw---- 1 grid asmadmin 15, 2 Jun 15 13:52 /dev/rhdisk2
crw-rw---- 1 grid asmadmin 15, 6 Jun 15 13:53 /dev/rhdisk3
crw-rw---- 1 grid asmadmin 15, 5 Jun 15 13:56 /dev/rhdisk4
crw-rw---- 1 grid asmadmin 15, 3 Jan 04 2019 /dev/rhdisk5
crw-rw---- 1 grid asmadmin 15, 4 May 29 19:20 /dev/rhdisk6
crw-rw---- 1 grid asmadmin 15, 7 Dec 16 2019 /dev/rhdisk7
crw-rw---- 1 grid asmadmin 15, 8 May 29 18:34 /dev/rhdisk8
四.扩容，增加+RLOG分区
在RAC 在第一个节点增加磁盘
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 15 14:01:56 2024
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create diskgroup rlog external redundancy disk '/dev/rhdisk7';
Diskgroup created.
SQL> set lin 120 pagesize 3000
SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------------------------------------ ---------------------- ---------- ----------
1 ARCH MOUNTED 307200 214735
2 DATA MOUNTED 2097152 42146
3 OCRVOTE MOUNTED 6144 5744
4 RLOG MOUNTED 204800 204749
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 307200 215435 0 215435 0 N ARCH/
MOUNTED EXTERN N 512 4096 1048576 2097152 42146 0 42146 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 6144 5744 0 5744 0 Y OCRVOTE/
MOUNTED EXTERN N 512 4096 1048576 204800 204749 0 204749 0 N RLOG/
在RAC第二个节点执行
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 15 14:04:26 2024
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> set lin 120 pagesize 3000
SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------------------------------------ ---------------------- ---------- ----------
1 ARCH MOUNTED 307200 215435
2 DATA MOUNTED 2097152 42146
3 OCRVOTE MOUNTED 6144 5744
0 RLOG DISMOUNTED 0 0
状态未生效需要在第二个节点进行挂载
SQL> alter diskgroup rlog mount;
Diskgroup altered.
SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------------------------------------ ---------------------- ---------- ----------
1 ARCH MOUNTED 307200 215435
2 DATA MOUNTED 2097152 42146
3 OCRVOTE MOUNTED 6144 5744
4 RLOG MOUNTED 204800 204706
SQL> exit
$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 307200 215435 0 215435 0 N ARCH/
MOUNTED EXTERN N 512 4096 1048576 2097152 42146 0 42146 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 6144 5744 0 5744 0 Y OCRVOTE/
MOUNTED EXTERN N 512 4096 1048576 204800 204706 0 204706 0 N RLOG/
ASMCMD> exit
五.扩容+DATA
1.扩容asm会自动做rebalance，调整asm_power_limit值。在Oracle RAC环境中，ASM Rebalance操作通常不需要在每个节点上单独执行。在一个节点执行即可。
su - grid
sqlplus / as sysasm
SQL> show parameter asm
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
asm_diskgroups string
DATA, ARCH, RLOG
asm_diskstring string
/dev/asm*
asm_power_limit integer
1
SQL>alter system set asm_power_limit =10;
SQL> show parameter asm
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
asm_diskgroups string
DATA, ARCH, RLOG
asm_diskstring string
asm_power_limit integer
10
asm_preferred_read_failure_groups string
SQL> alter diskgroup DATA add disk '/dev/rhdisk8' rebalance power 10 wait ;
开启另外一个窗口，查看操作过程
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 15 19:52:06 2024
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> set lin 120 pagesize 3000
SQL> SELECT INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES FROM GV$ASM_OPERATION;
INST_ID OPERATION STATE POWER SOFAR EST_WORK EST_RATE EST_MINUTES
---------- ---------- -------- ---------- ---------- ---------- ---------- -----------
2 REBAL WAIT 10
1 REBAL RUN 10 59597 685166 25912 24
ASM rebalance实际分为三步 planning, extents relocation 和compacting. 时间主要花费在 extents relocation。GV$ASM_OPERATION给我们提供了EST_MINUTES 估算剩余时间，但并不是很准确。
六.检查日志
分别登陆两个节点检查grid用户和oracle用户下的alert日志。
评论
后发表回复
作者
文章
阅读量
获赞
扫一扫
联系客服
联系客服
鄂Copyright © 达梦国产化应用创新实验室
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1