• 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
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
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

  • sed delete line containing string
  • How to insert line after match using sed
  • How to see the OS timezone used when the database was started
  • How to add datafile to tablespace in Oracle
  • Oracle Database Recovery various cases and solution

Copyright © 2023 : TechGoEasy

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