asm 磁盘组,更改磁盘大小

网友投稿 949 2022-05-28

参考:Doc ID 470209.1

asm 磁盘组,更改磁盘大小

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

1,建议备份数据库

2,关闭数据

3,dismount磁盘组

SQL> alter diskgroup dismount;

4,硬件层面disk/LUN  resize

5,mount磁盘组

SQL> alter diskgroup mount;

6,重新resize磁盘大小

SQL> ALTER DISKGROUP  RESIZE DISK  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;

数据库

版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。

上一篇:扩容裸盘(Linux)——裸盘未做分区
下一篇:你电脑的A盘和B盘去哪了
相关文章