ASM Basic

Posted on Posted in Uncategorized

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';

 

321 thoughts on “ASM Basic

  1. Amazing stuff. Thanks a lot.
    [url=https://homeworkcourseworkhelps.com/]i always do my homework[/url] just do my homework com [url=https://helpmedomyxyzhomework.com/]why i didn t do my homework essay[/url] my classmates used me to do their homework

  2. Thank you. Excellent stuff.
    [url=https://hireawriterforanessay.com/]essay write[/url] who can write my essay [url=https://theessayswriters.com/]business essay writer[/url] a writer should revise an argumentative essay for ideas and

  3. Regards, I value this!
    [url=https://essaywritingservicehelp.com/]best essay service[/url] essay writing app [url=https://essaywritingservicebbc.com/]essay writing websites[/url] essay services

  4. Awesome material. With thanks!
    [url=https://phdthesisdissertation.com/]dissertation proofreading services[/url] writing a phd dissertation [url=https://writeadissertation.com/]dissertation proofreading services[/url] chicago illinois dissertation help

  5. Great content. Thanks a lot.
    [url=https://writinganessaycollegeservice.com/]argumentative essay writing[/url] best essay writing service 2016 [url=https://essayservicehelp.com/]college essay writing[/url] service to others essay

  6. Amazing advice. Cheers!
    [url=https://researchproposalforphd.com/]college term papers[/url] buy a research paper [url=https://writingresearchtermpaperservice.com/]buy term paper[/url] term paper

  7. With thanks. Numerous stuff.
    [url=https://essaywritingservicelinked.com/]essay review service[/url] college essay writing services [url=https://essaywritingservicetop.com/]essay writing websites[/url] writing a college essay

  8. Thank you! Terrific stuff!
    [url=https://essaypromaster.com/]professional paper writers[/url] paper writer online [url=https://paperwritingservicecheap.com/]write a paper for me[/url] research paper writer

  9. I am an investor of gate io, I have consulted a lot of information, I hope to upgrade my investment strategy with a new model. Your article creation ideas have given me a lot of inspiration, but I still have some doubts. I wonder if you can help me? Thanks.

  10. You have made the point!
    [url=https://essaypromaster.com/]how to write an analysis paper[/url] website that writes papers for you [url=https://paperwritingservicecheap.com/]paper writing service[/url] how to write a reflective paper

  11. Wonderful stuff. Regards.
    [url=https://phdthesisdissertation.com/]dissertation writing service[/url] writing dissertation [url=https://writeadissertation.com/]dissertation meaning[/url] dissertations

  12. I’m concerned about the quality of medication I’ll receive if I [url=https://metforminv.com/]buy Metformin online without a prescription[/url]. Any advice?

  13. Point effectively utilized.!
    [url=https://essayssolution.com/]help me write my essay[/url] writing essays for money [url=https://cheapessaywriteronlineservices.com/]write my paper for me[/url] write essay

  14. At the beginning, I was still puzzled. Since I read your article, I have been very impressed. It has provided a lot of innovative ideas for my thesis related to gate.io. Thank u. But I still have some doubts, can you help me? Thanks.

  15. You made the point!
    [url=https://topswritingservices.com/]essay writing service oxford[/url] top essay writing [url=https://essaywriting4you.com/]seo article writing service[/url] essay service reviews

  16. Want to improve your skills in a fun and supportive environment? Then come down to the Leeds United Foundation Skills Centres! Liverpool hosts Nottingham Forest at 10am ET Saturday, while Leeds is off to Fulham for the early game that day: 7:30am ET at Craven Cottage. Posted every Wednesday at 3AM UK time, stickied until the weekend Pre-Match Thread. Off-topic comments shall be removed. A happy Jürgen Klopp met with the media after Liverpool dominated Leeds United 6-1. The… Having led Leeds to vital victories over Norwich, Wolves, Watford and Brentford during the relegation run-in, Marsch kept the club up by the skin of their teeth, surviving at Burnley’s expense on a dramatic final day. Nevertheless, the computer from Footballwebpages.co.uk still thinks West Brom will finish top on 92 points come May, with Leeds second on 87 points.
    https://wikimili.com/en/James_Whitham
    Cash is the son of former professional footballer Stuart Cash. His brother Adam coaches football at school-level. Cash grew up in Iver working in a branch of the department store Daniel prior to joining the Nottingham Forest academy. The full-back quickly made a name for himself in claret and blue with his tough tackling and driving runs forward. Cash made 28 appearances in his first season at the club, all in the Premier League, as he established himself as the first choice right-back. Cash went up a level in 2021/22, scooping the club’s Supporters’ Player of the Year award after starting all 38 Premier League games. Cash is the son of former professional footballer Stuart Cash. His brother Adam coaches football at school-level. Cash grew up in Iver working in a branch of the department store Daniel prior to joining the Nottingham Forest academy.

  17. Terrific advice. Regards!
    [url=https://researchproposalforphd.com/]research paper services[/url] research paper writers [url=https://writingresearchtermpaperservice.com/]research paper writing service[/url] proposal writing

  18. Kudos. Plenty of info.
    [url=https://phdthesisdissertation.com/]dissertations online[/url] dissertation editing services [url=https://writeadissertation.com/]dissertation meaning[/url] dissertation assistance

  19. This is nicely expressed! .
    [url=https://topswritingservices.com/]essay writing service 3 hours[/url] best resume writing service 2019 [url=https://essaywriting4you.com/]scholarship essay writing service[/url] linkedin profile writing service

  20. Awesome material. Cheers!
    [url=https://homeworkcourseworkhelps.com/]online coursework[/url] hire someone to do my homework [url=https://helpmedomyxyzhomework.com/]reddit do my homework[/url] do my finance homework

  21. You said it adequately..
    [url=https://researchproposalforphd.com/]research proposal[/url] cheap research paper writing service [url=https://writingresearchtermpaperservice.com/]proposal introduction[/url] research paper proposal

  22. Perfectly voiced certainly. !
    [url=https://customthesiswritingservice.com/]writing a thesis statement[/url] thesis writing service [url=https://writingthesistops.com/]thesis creator[/url] thesis template

  23. Awesome data. Thanks.
    [url=https://dissertationwritingtops.com/]phd dissertation writing[/url] dissertation writing services reviews [url=https://helpwritingdissertation.com/]writing a dissertation[/url] buy dissertations

  24. I may need your help. I tried many ways but couldn’t solve it, but after reading your article, I think you have a way to help me. I’m looking forward for your reply. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *

6 + 1 =