How to get ASM disk information:
SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK order by PATH;
How to get ASM diskgroup Information :
SELECT NAME, TOTAL_MB/1024, USABLE_FILE_MB/1024, FREE_MB/1024 FROM V$ASM_DISKGROUP;
How to get ASM disk part of which Failgroup :
select name, GROUP_NUMBER, FAILGROUP from v$asm_disk order by group_number;
How to get Failgroup count of ASM disks :
select failgroup, count(*) from v$asm_disk group by failgroup;
How to add ASM disks with multiple failgroups/ two failgroups (Nvme/SAN mirroring):
alter diskgroup <diskgroup_name> add failgroup FG1 disk '/dev/oracleasm/disks/ASM_NVME_108' name DATA_NVME_108, '/dev/oracleasm/disks/ASM_NVME_207' name DATA_NVME_207, '/dev/oracleasm/disks/ASM_NVME_208' name DATA_NVME_208 failgroup FG2 disk '/dev/oracleasm/disks/ASM_SAN_012' name DATA_SAN_012, '/dev/oracleasm/disks/ASM_SAN_015' name DATA_SAN_015, '/dev/oracleasm/disks/ASM_SAN_016' name DATA_SAN_016 rebalance power 11;
Comments
Post a Comment