ASM Login and Check Space:
set the environment . oraenv +ASM1 shadb@sha01:~$ asmcmd -p ASMCMD [+] > ls SHAPROD_DATA01/ SHAPROD_RECO/ ASMCMD [+] > lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 4194304 29491200 13181264 614400 6283432 0 Y SHAPROD_DATA01/ MOUNTED NORMAL N 512 4096 4194304 32356352 24457704 874496 11791604 0 N SHAPROD_RECO/ SQL(+ASM1)>select name,total_mb,free_mb, (free_mb/total_mb)*100 "%Free" from v$asm_diskgroup; NAME TOTAL_MB FREE_MB %Free ------------------------------ ------------ ------------ ---------- SHASQL(+ASM1)>select name,total_mb,free_mb, (free_mb/total_mb)*100 "%Free" from v$asm_diskgroup; NAME TOTAL_MB FREE_MB %Free ------------------------------ ------------ ------------ ---------- SHAPROD_DATA01 29,491,200 13,181,264 44.6955838 SHAPROD_RECO 32,356,352 24,474,116 75.6392933 SQL(+ASM1)> select name,decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1) Redundancy, (total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Total_MB, (free_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Free_MB, ((free_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1))/(total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)))*100 "%Free" from v$asm_diskgroup; NAME REDUNDANCY TOTAL_MB FREE_MB %Free -------------- ----------- ------------- ---------- ------------ SHAPROD_DATA01 2 14,745,600 6,590,632 44.6955838 SHAPROD_RECO 2 16,178,176 12,237,058 75.6392933
Creating and Adding Disk in Diskgroup : (Making redundancy as External, because ASM will depend on OS redundancy like RAID, otherwise in case of Normal redundancy we must have two Disk available to make Failover Disk) CREATE DISKGROUP TESTDATA EXTERNAL REDUNDANCY DISK '/dev/mapper/disk1'; SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;
Adding multiple Disk to existing Diskgroup :
alter DISKGROUP TESTDATA add disk '/dev/mapper/disk2','/dev/mapper/OneTM_ODS_disk3','/dev/mapper/disk4';
11 thoughts on “ASM Basic”
Very helpful Sir…please keep the good work going..
cheap digoxin lanoxin 250 mg uk molnupiravir without prescription
acetazolamide canada isosorbide medication buy azathioprine online cheap
order priligy 60mg online avana 100mg cheap domperidone 10mg without prescription
pamelor sale pamelor 25mg ca buy paroxetine generic
requip 2mg brand trandate drug order labetalol 100mg pill
buy esomeprazole 20mg nexium drug order furosemide 40mg without prescription
deltasone 10mg oral buy isotretinoin 10mg sale brand amoxicillin 500mg
buy sildenafil 50mg sale fildena pills buy finasteride 5mg generic
zofran pills buy ondansetron 4mg without prescription brand bactrim
order generic accutane 20mg buy accutane 40mg pills oral azithromycin 250mg