• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle database
  • Oracle Ebusiness Suite
  • Oracle weblogic
  • Oracle Performance Tuning
  • Oracle Hyperion
  • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
Home » Oracle » Oracle Database » ASM best practice to add disk

ASM best practice to add disk

November 30, 2017 by techgoeasy Leave a Comment

Here are ASM best practices to add disks which should be always used to manipulate the ASM disks

(1) First check the newly added disk is visible in ASM disks

select header_status,path from v$asm_disk where path= '<path>';

It should show the candidate

(2) Create a new temporary diskgroup using those disks

CREATE DISKGROUP TEST_DISK EXTERNAL REDUNDANCY DISK '<path>';

(3) Check if the diskgroup is created and mounted


SELECT STATE, NAME FROM V$ASM_DISKGROUP;

(4) If RAC, then manually mount it on the other ASM instance(s)

ALTER DISKGROUP TEST_DISK MOUNT;
SELECT STATE, NAME FROM V$ASM_DISKGROUP;

(5) If the previous steps had success and the TEST diskgroup can be successfully mounted (on each ASM instance), then drop the TEST_DISK diskgroup as follow

alter diskgroup test_disk dismount; (from all the ASM instances, except from one).
DROP DISKGROUP TEST; --(from the ASM instance, which the diskgroup is still mounted)

(6) Now again check the status of the disk

select header_status,path from v$asm_disk where path= '<path>';

It should show Former

(7) Then the candidate disk is ready to be added to the desired diskgroup:

ALTER DISKGROUP ADD DISK '<path>';

(8) Check the rebalance in ASM using

select * from v$asm_operation;

Related Articles

Top 46 Oracle ASM Interview Questions
How ASM Failure Groups and CSS provides high availability
15 Awesome Oracle ASM Queries every DBA must know
Oracle ASM (Automatic Storage Management )
Oracle ASM disks
Oracle ASM Diskgroups

Filed Under: Oracle, Oracle Database Tagged With: ASM best practice to add disk

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to create SQL Patch for sql tuning in Oracle
  • How to Configure Auto Login TDE Wallet
  • how to find if the sql is using the sql profile
  • What is Sequence in oracle
  • How to check temp tablespace in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us