What is Lun in Oracle ASM?

Logical Unit Number (LUN) A LUN is a disk presented to a computer system by a storage array. Oracle recommends that you use hardware RAID functionality to create LUNs. Storage hardware RAID 0+1 or RAID5, and other RAID configurations, can be provided to Oracle ASM as Oracle ASM disks.

How do I find the size of my ASM disk?

SQL:ASM>select name,total_mb,free_mb,state from v$asm_diskgroup; ASMCMD tool can also be used to find the free space. du -Displays the total disk space occupied by ASM files in the specified ASM directory and all its subdirectories, recursively.

How do I increase the size of my ASM Diskgroup?

Grow disk group through ASM: This command is run from the database node as sysasm: alter diskgroup DATA_DB03P resize all rebalance power 32; select * from gv$asm_operation; Once this completes, you are done!

How do I free up space on ASM?

ASMFD Thin_Provisioned Demo

  1. Create an ASM Disk Group using the ASM Filter Driver.
  2. Create a tablespace in this diskgroup and populate it with some random data.
  3. Check the space allocated at the database and array level.
  4. Drop the tablespace and run ASM rebalance.
  5. Check the space again.

How many disk groups are there in ASM?

two diskgroups
Thank you for your feedback! Oracle recommends just two diskgroups by default: A DATA diskgroup to hold all data, index, undo and temp files.

How do I add a LUN to ASM Diskgroup?

  1. Create ASM disk. Get the Lun name from storage team. Lun Name – /dev/sda1.
  2. Check the ASM Disks, Check the newly added disk, $sudo oracleasm listdisks.
  3. Create the ASM Diskgroup. $sqlplus / as sysasm.
  4. Check the rebalance status. $sqlplus / as sysasm.
  5. Check the newly added disk in ASM Diskgroup.

Where is my ASM disk path?

In Linux, ASMLib provides the wrapper for managing the ASM disks. To identify the underlying physical device that the ASM disk point to, you can use the oracleasm querydisk command. The querydisk option will list the major and minor numbers that can be used to match the physical device.

What is rebalance power in ASM?

Whenever there is a disk added/removed/resized, ASM starts to rebalance the data on the disks in the disk group. The power with which it does the rebalancing is the rebalancing power. The rebalance power defaults to the value of the ASM_POWER_LIMIT initialization parameter (default value = 1).

How do I add a disk to Asmca Diskgroup?

Click on Add Disks.

  1. It will open a new window.
  2. Here no need to select Disk name & redundancy for disk group, as we have already specified it at the time of disk group creation. select the eligible disk, change Disk discovery path if required & click ok.
  3. Click on OK.
  4. FRA diskgroup now with a space of 300GB.

How do I check my ASM disk utilization?

ASM Disk group size Check

  1. select name, total_mb, free_mb, usable_file_mb,
  2. round(((total_mb-nvl(free_mb,0))/total_mb)*100,0) percent_used.
  3. from V$ASM_DISKGROUP_STAT;
  4. SELECT G.NAME,
  5. sum(b. total_mb) total_mb,
  6. sum((b. total_mb – b. free_mb)) used_mb,
  7. sum(B. FREE_MB) free_mb,
  8. decode(sum(b. total_mb),0,0,(ROUND((1- (sum(b.

What is Usable_file_mb in ASM?

USABLE_FILE_MB :- Indicates how much space is available in an ASM disk group considering the redundancy level of the disk group. Its calculated as :- USABLE_FILE_MB=(FREE_MB – REQUIRED_MIRROR_FREE_MB ) / 2 –> For Normal Redundancy.