We know what is ASM in Oracle. Today we have look on diskgroups. In this article we have discussed the technical definition on ASM  diskgroup in first two paragraphs after that we have the steps which we use to add ASM diskgroup
The main components of ASM are diskgroups, each of which comprises of several physical disks that are controlled as a single unit. The physical disks are known as ASM disks, while the files that reside on the disks are known as ASM files. The locations and names for the files are controlled by ASM, but user-friendly aliases and directory structures can be defined for ease of reference.
 
Diskgroup is a terminology used for a logical structure which holds the database files. Each diskgroup consists of disks/raw devices where the files are actually stored. Any ASM file (and it’s redundant copy) is completely contained within a single diskgroup. A diskgroup might contain files belonging to several databases and a single database can use files from multiple diskgroups.

Adding a disk to an ASM diskgroup is really simple, just an alter command. But when if you are doing this in a production database, then before adding we have to make sure that the disk is healthy.

We will follow below steps to confirm that the disk is healthy.

1.First, create the disk using ASMLIB

NOTE – If this is Solaris or HP, then the 1st step is not required, as it doesn’t need ASMLIB.

2. Check the visibility of the disks at OS level🙁 as grid owner from all the nodes)

3. Use kfed to read the disks:(as grid owner from all the nodes)

If you are getting an error like kfbh.type: 0 ; 0x002: KFBTYP_INVALID, then you can ignore it safely.

4. Now create a diskgroup for testing purpose:

5. Create a tablespace on this diskgroup:

As tablespace created, we can confirm that the disk is healthy. We can clean the diskgroup.
6.Let’s drop the tablespace and the diskgroup:

Note:- If you try to drop the diskgroup, without dismounting the diskgroup from all instance, except one, then you will hit the error.

Now we have cleaned up diskgroup, after confirming that disk is perfectly healthy. So let’s proceed and add that disk to your required existing diskgroup.

7.Add the disk to existing diskgroup:

About The Author

Leave a Reply