You can add and drop disk at the same time from 12.1 (possible 11.2.0.4 - can't
remember); Oracle is smart enough not to do 2 rebals and effectively does a
disk-to-disk copy. I've used this command for 2 SAN migrations in the last few
months.
Same net result as Tim's option:
ALTER DISKGROUP data
ADD DISK 'ORCL:disk101','ORCL:disk102'
DROP DISK 'disk001','disk002'
REBALANCE POWER n
/
Neil Chandler
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Tim Gorman <tim.evdbt@xxxxxxxxx>
Sent: 17 January 2017 14:57
To: oracle455@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: move from XIO to ZFS
Michael,
You can add the new disks to your diskgroups, drop the old disks, then
rebalance to perform the migration without downtime...
ALTER DISKGROUP data REBALANCE POWER 0; -- temporarily disable rebalancing
ALTER DISKGROUP data ADD DISK ... -- add disks from new SAN
ALTER DISKGROUP data DROP DISK ... -- remove disks from old SAN
ALTER DISKGROUP data REBALANCE POWER ... -- reenable rebalancing to make it
all happen
There are several posts describing the technique when googling "oracle asm
rebalance migration".
You can also use RMAN.
Hope this helps...
-Tim
On 1/17/17 07:29, Michael Calisi wrote:
Trying to remove a non-production database off my XIO drives. The database
is RAC One Node 12c running ASM on XIO drives. I need to move the database
to RAC One Node ASM 12c under ZFS.
Any suggestions best way to handle this move?
Michael