Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime
這篇文章的目的是實現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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Steps to Recreate ASM Diskgroups (文件 ID 268481.1)ASM
- Steps to Re-Create ASM Diskgroups(重建asm 磁碟組步驟)ASM
- Resize diskgroup without downtime in Exadata [ID 1272569.1]
- 【RAC】asm_diskgroups 引數ASM
- 11gR2中的ASM_DISKGROUPS引數ASM
- How to move ASM database files from one diskgroup to anotherASMDatabase
- FC SAN 與 IP SAN
- 3 Steps to Perform SSH Login Without Password Using ssh-keygen & ssh-copy-idORM
- Exact Neighbours (Medium)
- 識別ip san與ib san
- Laravel 5 migrateLaravel
- cursor_sharing : exact , force , similarMILA
- create a database stepsDatabase
- First steps with Incus
- Yet Another Problem
- cursor_sharing = similar , exact 區別MILA
- Oracle Database High Availability Solutions for Unplanned DowntimeOracleDatabaseAI
- php artisan migrate 報錯PHP
- steps()的學習
- SSH steps of developingdev
- CSS 動畫的 stepsCSS動畫
- Quick steps to rebuild the CRSRebuild
- SCSS without和withCSS
- unixODBC without the GUIGUI
- Another Intro for CookiesCookie
- stylus , another css processorCSS
- Another article published by apiAPI
- pipe stderr into another process
- How to migrate data from Oracle to MSSQLSERVEROracleSQLServer
- Performance Without the Event LoopORMOOP
- scp without interative password
- Another Intro for HTTP CacheHTTP
- Yet Another Intro for SymbolSymbol
- Yet Another Permutation ConstructiveStruct
- How to get the exact duration of an audio file in js All In OneJS
- Redis migrate 資料遷移工具Redis
- dataguard switchover & failover steps (rac)AI
- 零當機時間遷移 ASM 磁碟組到另一個 SAN/磁碟陣列/DAS 的準確步驟ASM陣列