oracle rac ASM存储空间不够了怎么扩容

oracle rac ASM存储空间不够了怎么扩容,第1张

(1)添加磁盘

(2)fdisk格式化。

(3)加载已更新的块设备分区表(在rac的两台机器上执行)(机器可以发现磁盘)

(4)授权。(使oracle用户和响应的组拥有权限)

(5)给磁盘组添加磁盘。(添加到asm磁盘组)

具体举例:

su - grid

sqlplus / as sysasm

alter diskgroup data add disk '/dev/mapper/data15p1'(你格式化后的磁盘)

(6)检查

su - grid

asmcmd

lsdg

Oracle RAC需要将reserve_lock(reserve_policy)设置成NO或no_reserve,目的是因为RAC 需要并发的共享盘,所以盘不能被一台机器锁住。

官方文档相关内容如下

To enable simultaneous access to a disk device from multiple nodes, you must set the appropriate Object Data Manager (ODM) attribute, depending on the type of reserve attribute used by your disks. The following section describes how to perform this task using hdisk logical names. Refer to your operating system documentation to find logical device names.

To determine the reserve setting your disks use, enter the following command, where n is the hdisk device number:

# lsattr -E -l hdiskn | grep reserve_

The response is either a reserve_lock setting, or a reserve_policy setting. If the attribute is reserve_lock, then ensure that the setting is reserve_lock = no. If the attribute is reserve_policy, then ensure that the setting is reserve_policy = no_reserve.

If necessary, change the setting with the chdev command using the following syntax, where n is the hdisk device number:

chdev -l hdiskn -a [ reserve_lock=no | reserve_policy=no_reserve ]

For example, to change a setting for the device hdisk4 from reserve_lock=yes to reserve_lock=no, enter the following command:

# chdev -l hdisk4 -a reserve_lock=no

To verify that the setting is correct on all disk devices, enter the following command:

# lsattr -El hdiskn | grep reserve


欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/bake/11799706.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-05-18
下一篇 2023-05-18

发表评论

登录后才能评论

评论列表(0条)

保存