Oracle集群管理-ORADATA2添加ASM磁盘

执笔画情ora

已于 2023-06-28 11:07:41 修改

阅读量1.3k

点赞数

分类专栏： ORACLE数据库RAC管理文章标签：数据库 oracle

于 2023-06-28 10:38:09 首次发布

本文链接：https://blog.csdn.net/oradbm/article/details/131431790

版权

ORACLE数据库RAC管理专栏收录该内容

133 篇文章 5 订阅

订阅专栏

1 使用fdisk对磁盘进行分区，不做文件格式。
2 使用oracleasm createdisk创建ASM磁盘。
oracleasm createdisk DATA8 /dev/sdn1
3 使用oracleasm scandisks命令扫描磁盘，node1， node2 都要做。
4 查看磁盘状态

select a.GROUP_NUMBER,a.name,a.state,a.LABEL,a.PATH,b.NAME from v$asm_disk a,v$asm_diskgroup b where a.GROUP_NUMBER=b.GROUP_NUMBER(+

磁盘组编号磁盘名称磁盘状态别名磁盘路径粗盘组名称
0       NORMAL       /dev/oracleasm/disks/MGMT
0       NORMAL       /dev/oracleasm/disks/DATA8
1   ARCH_0000   NORMAL   ARCH   /dev/oracleasm/disks/ARCH   ARCH
2   DATA_0002   NORMAL   OCR3   /dev/oracleasm/disks/OCR3   DATA
2   DATA_0000   NORMAL   OCR1   /dev/oracleasm/disks/OCR1   DATA
2   DATA_0001   NORMAL   OCR2   /dev/oracleasm/disks/OCR2   DATA
3   OGG_0000   NORMAL   OGG   /dev/oracleasm/disks/OGG   OGG
4   ORADATA1_0002   NORMAL   DATA7   /dev/oracleasm/disks/DATA7   ORADATA1
4   ORADATA1_0001   NORMAL   DATA2   /dev/oracleasm/disks/DATA2   ORADATA1
4   ORADATA1_0000   NORMAL   DATA1   /dev/oracleasm/disks/DATA1   ORADATA1
5   ORADATA2_0001   NORMAL   DATA4   /dev/oracleasm/disks/DATA4   ORADATA2
5   ORADATA2_0000   NORMAL   DATA3   /dev/oracleasm/disks/DATA3   ORADATA2
6   ORADATA3_0001   NORMAL   DATA6   /dev/oracleasm/disks/DATA6   ORADATA3
6   ORADATA3_0000   NORMAL   DATA5   /dev/oracleasm/disks/DATA5   ORADATA3
7   REDO_0000   NORMAL   REDO   /dev/oracleasm/disks/REDO   REDO

5 添加磁盘
alter diskgroup oradata2 add disk '/dev/oracleasm/disks/DATA8' name ORADATA2_0002;
6 查看磁盘组状态
select name,state from v$asm_diskgroup;

7 查看重新平衡的状态

select * from v$asm_operation;

8 从新平衡的一些操作：

1 alter diskgroup dg rebalance;
2 alter diskgroup dg rebalance wait;