15.OracleRAC19c ASM磁盘组维护常用命令

创建ASM磁盘组。
su - grid
sqlplus / as sysasm 
---create diskgroup data external/normal  redundancy disk '/dev/sdd';
---create diskgroup data normal  redundancy disk '/dev/sdd1','/dev/sdd2','/dev/sdd3';

1.创建磁盘组。

create diskgroup data external redundancy disk '/dev/mapper/data1','/dev/mapper/dat2' 
attribute 'au_size'='8M' ,'compatiable.asm'='19.0.0' 'compatible.rdbms'='19.0.0';

2.修改磁盘组的兼容性属性
ALTER DISKGROUP data SET ATTRIBUTE 'compatible.asm' = '19.0.0.0.0';
ALTER DISKGROUP data SET ATTRIBUTE 'compatible.rdbms' = '10.1.0.0.0';

3.检查asm磁盘组和asm属性信息

SELECT group_number, name, compatibility, database_compatibility FROM v$asm_diskgroup;
SELECT group_number, name, value FROM v$asm_attribute ORDER BY group_number, name;

--集群时间同步服务状态查看：
systemctl status chronyd

4.查看是否有数据库实例上连接asm实例。
select instance_name,db_name,status from v$asm_client;

5.记录balance操作

select operation,state,power,actual,sofar from v$asm_operation;

6ASMDISK 磁盘查看;
select path,state ,total_mb,free_mb from v$asm_disk;

7ASMDISKGROUP 磁盘组查看;
select name,state,type,total_mb,free_mb from v$asm_diskgroup;