ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime.

Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime.

原创 Linux操作系统 作者:spider0283 时间:2011-08-23 11:24:23 0 删除 编辑

[ID 837308.1]

修改时间 19-APR-2011     类型 HOWTO     状态 PUBLISHED

 

In this Document
  Goal
  Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Goal

The present document explains in detail the exact steps to migrate ASM diskgroups from one SAN to another SAN without a downtime.

Solution

If your plans are replacing the current disks associated to your diskgroups with a new storage, this operation can be accomplished without any downtime, so you can follow the next steps

1) Backup all your databases and valid the backup (always required to protect your data).

2) Add the new path (new disks from the new storage) to your asm_disktring to be recognized by ASM:

Example:

SQL> alter system set asm_disktring = '/dev/emcpowerc*' , '/dev/emcpowerh*';

Where: '/dev/emcpowerc*' are the current disks.
Where: '/dev/emcpowerh*' are the new disks.

3) Confirm that the new disks are being detected by ASM:

SQL> select path from v$asm_disk;


4) Add the new disks to your desired diskgroup:

SQL> alter diskgroup add disk
’,
’,
’,
’,
.
.
.
’ rebalance power <#>; 


5) Then wait until the rebalance operation completes:

SQL> select * from v$asm_operation;
SQL> select * from gv$asm_operation;

6) Finally, remove the old disks:

SQL> alter diskgroup drop disk
,
,
,
,
.
.
.
  rebalance power <#>;

7) Then wait until the rebalance operation completes:

SQL> select * from v$asm_operation;
SQL> select * from gv$asm_operation;


8) Done, your ASM diskgroups and database have been migrated to the new storage.

Note: Alternatively, we can execute add disk & drop disk statements in one operation, in that way only one rebalance operation will be started as follow:

SQL> alter diskgroup
add disk '', .., ''
drop disk , , ..,
rebalance power <#>;

This is more efficient than separated commands (add disk & drop disk statements).




显示相关信息 相关的


产品
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
ASM; STORAGE; V$ASM_DISK; V$ASM_OPERATION

返回页首返回页首

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38267/viewspace-705607/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    627839