{"id":7,"date":"2012-11-26T21:20:00","date_gmt":"2012-11-26T21:20:00","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=7"},"modified":"2026-02-07T14:43:39","modified_gmt":"2026-02-07T20:43:39","slug":"disk-array-migration-for-asm-databases","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2012\/7\/","title":{"rendered":"Disk Array Migration for ASM Databases"},"content":{"rendered":"
\n
\n
This blog identifies the DBA steps required to migrate databases from one disk array to another.<\/div>\n<\/div>\n
<\/div>\n
Identify the ASM diskgroups and their disk (LUN) sizes<\/div>\n
Login to the ASM instance and identify the LUNs allocated to server.<\/div>\n
<\/div>\n
\n
SQL> SET PAGES 999\nSQL> col name format a15<\/pre>\n
For 11g ASM:<\/span><\/p>\n<\/div>\n
\n
SQL> select d.group_number, g.name, d.os_mb\nfrom v$asm_disk d left outer join v$asm_diskgroup g\non (d.group_number = g.group_number)\norder by g.group_number, d.os_mb;<\/pre>\n
For 10g ASM:<\/span><\/p>\n<\/div>\n
\n
SQL> select d.group_number, g.name, d.total_mb\nfrom v$asm_disk d left outer join v$asm_diskgroup g\non (d.group_number = g.group_number)\norder by g.group_number, d.total_mb;<\/pre>\n
You may discard LUNs with group number 0, as they are not part of any diskgroup. Request Sysadmin team to provision the new LUNs to the server, same LUN size or total of multiple LUNs in the group is equal or more to what is allocated to the group.\u00a0<\/span><\/p>\n<\/div>\n
<\/div>\n
\u00a0To find out what is allocated and free in each diskgroup, you may use:<\/div>\n
<\/div>\n
\n
SQL> select name, total_mb, free_mb from v$asm_diskgroup;<\/pre>\n
Once LUNs are provisioned by Unix team, use OEM or SQL to add the LUNs to respective diskgroups [existing diskgroup]. NO outage required for this step. Remember to login to 11g ASM using the SYSASM privilege, for 10g login using SYSDBA privilege.<\/span><\/p>\n<\/div>\n
\n
SQL> ALTER DISKGROUP ADD DISK \u2018\/full_path_of_device\u2019;<\/pre>\n
To find out which LUNs are available to add, you may use SQL:<\/span><\/p>\n<\/div>\n
\n
SQL> col path format a40\nSQL> select path, os_mb from v$asm_disk where group_number = 0;<\/pre>\n<\/div>\n
{for 10g ASM, please substitute os_mb with total_mb}<\/div>\n
<\/div>\n
Then, go ahead and drop the old LUNs. No need to wait for the add operation to complete.<\/div>\n
<\/div>\n
\n
SQL> ALTER DISKGROUP DROP DISK name_of_old_LUN;<\/pre>\n
The name of the LUN can be found by querying the V$ASM_DISK…<\/span><\/p>\n<\/div>\n
\n
SQL> select path,name from v$asm_disk where group_number=3;<\/pre>\n
Keep the rebalance power low, so that the migration activity does not impact database performance.<\/p>\n<\/div>\n
<\/div>\n
You may check the progress of rebalance periodically using V$ASM_OPERATION, once no rows are in this view, you may advice SYSADMIN team to pull out the old LUNs from the server. V$ASM_OPERATION also shows the work so far completed and how long it will take to complete the work.<\/div>\n
<\/div>\n
<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
This blog identifies the DBA steps required to migrate databases from one disk array to another. Identify the ASM diskgroups and their disk (LUN) sizes Login to the ASM instance and identify the LUNs allocated to server. SQL> SET PAGES 999 SQL> col name format a15 For 11g ASM: SQL> select d.group_number, g.name, d.os_mb from … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2,133],"tags":[134],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-infrastructure-exadata","category-oracledb","tag-oracle-11g"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/7\/revisions"}],"predecessor-version":[{"id":2948,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/7\/revisions\/2948"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}