Oracle 常用指令 & SQL - ASM 篇 (ASM section)

ASM 相關指令

-- 查詢目前DISK狀態

set lines 999
col diskgroup for a15
col diskname for a15
col path for a30
col failgroup for a10
select group_number, 
       name, 
       failgroup, 
       header_status, 
       path, 
       total_mb, 
       free_mb, 
       mode_status 
from v$asm_disk 
order by group_number;

-- 查詢目前Diskgroup

set lines 999
col name format a10
select group_number, 
       name, 
       sector_size, 
       block_size, 
       allocation_unit_size Allocate_size, 
       state, 
       type, 
       total_mb, 
       free_mb, 
       required_mirror_free_mb Req_Mir_Free, 
       usable_file_mb, 
       offline_disks 
from v$asm_diskgroup;

-- 查詢Diskgroup與Disk關聯

set lines 999
col diskgroup for a15
col diskname for a15
col path for a30
select a.group_number DG_Number, 
       a.name DiskGroup,
       b.name DiskName, 
       b.total_mb, 
       (b.total_mb-b.free_mb) Used_MB, 
       b.free_mb,b.path,
       b.header_status, 
       b.mode_status
from v$asm_diskgroup a, v$asm_disk b
where a.group_number (+) = b.group_number
order by b.group_number,b.name;

-- 新增Diskgroup磁碟

alter diskgroup datadg add disk 'AFD:DATA02';
alter diskgroup datadg add site siteb failgroup fg2 disk 'AFD:DATA02' force;