asm 磁盘组,更改磁盘大小

举报
snowofsummer 发表于 2021/06/09 09:04:34 2021/06/09
【摘要】 参考:Doc ID 470209.1#The present document shows an example to resize the ASM disks on 10.2 version1,建议备份数据库2,关闭数据库3,dismount磁盘组SQL> alter diskgroup <diskgroup> dismount;4,硬件层面disk/LUN  resize5,mount磁...

参考:Doc ID 470209.1

#The present document shows an example to resize the ASM disks on 10.2 version

1,建议备份数据库

2,关闭数据库

3,dismount磁盘组

SQL> alter diskgroup <diskgroup> dismount;

4,硬件层面disk/LUN  resize

5,mount磁盘组

SQL> alter diskgroup <diskgroup> mount;

6,重新resize磁盘大小

SQL> ALTER DISKGROUP <diskgroup> RESIZE DISK <disk name> <size>M REBALANCE POWER <1-11>;
SQL> ALTER DISKGROUP DATA RESIZE DISK DISK_A1 SIZE 5000 M REBALANCE POWER 11;

命令参考:

Resizing Disks in Disk Groups
The RESIZE clause of ALTER DISKGROUP enables you to resize disks in a disk group.

When resizing disks in a disk group, all the disks must be of equal size.

If you do not specify a new size in the SIZE clause, then Oracle ASM uses the size of the disks as returned by the operating system. The new size is written to the Oracle ASM disk header and if the size is increasing, then the new space is immediately available for allocation. If the size is decreasing, rebalancing must relocate file extents beyond the new size limit to available space below the limit. If the rebalance operation can successfully relocate all extents, then the new size is made permanent, otherwise the rebalance fails.

The following example resizes all of the disks in the disk group data1. If the new size is greater than the capacity of a disk, then the statement fails.

Example 4-6 Resizing disks in disk groups

ALTER DISKGROUP data1 RESIZE ALL SIZE 100G;

【版权声明】本文为华为云社区用户原创内容,转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息, 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@huaweicloud.com
  • 点赞
  • 收藏
  • 关注作者

评论(0

0/1000
抱歉,系统识别当前为高风险访问,暂不支持该操作

全部回复

上滑加载中

设置昵称

在此一键设置昵称,即可参与社区互动!

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。