这篇文章的目的是实现asm磁盘组更换存储的解决方法,这种方法不用停机。
Information in this document applies to any platform.
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:
3) Confirm that the new disks are being detected by ASM:
4) Add the new disks to your desired diskgroup:
5) Then wait until the rebalance operation completes:
6) Finally, remove the old disks:
7) Then wait until the rebalance operation completes:
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:
This is more efficient than separated commands (add disk & drop disk statements).
Steps To Migrate ASM Diskgroups To Another SAN Without Downtime. [ID 837308.1] | |||||
| |||||
修改时间 15-JUN-2009 类型 HOWTO 状态 PUBLISHED |
In this Document
Goal
Solution
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7Information 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 steps1) 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.
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
‘’,
‘’,
‘’,
‘’,
.
.
.
‘’;
‘’,
‘’,
‘’,
‘’,
.
.
.
‘’;
5) Then wait until the rebalance operation completes:
SQL> select * from v$asm_operation;
SQL> select * from gv$asm_operation;
SQL> select * from gv$asm_operation;
6) Finally, remove the old disks:
SQL> alter diskgroup drop disk
,
,
,
,
.
.
.
;
,
,
,
,
.
.
.
;
7) Then wait until the rebalance operation completes:
SQL> select * from v$asm_operation;
SQL> select * from gv$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 ;
add disk '', .., ''
drop disk , , ..,
rebalance ;
This is more efficient than separated commands (add disk & drop disk statements).
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-692519/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-692519/