We are using Oracle 12.1.3 with ASM.
We recently received new DISKS to replace the old ones.
We currently have 7x250G Disks which we will move to newer 7x250G Disks .
.
It appears that the best method is to do the ADD and DROP in the same command, from the articles that I read, this will benefit the rebalancing (it should take less time than doing a ADD then DROP separately)
.
We will be moving about 1.5Tbyes (7x250G) of data.
We have a weekly maintenance window of 5 hours that we can bring down the DB for maintenance.
.
Since no one will be on the system for these 5 hours, we were going to shutdown the DB before the ADD + DROP, then restart the DB once it’s done. It seems that we can also leave the DB open during the transfer but as mentioned during that time no-one will be accessing the DB, so I do not see the benefits of leaving he DB open and I believe it has to be bounced to release the old disks.
.
Question 1) For our case, is the ADD and DROP in the same command the best solution?
Question 2) Is it safer to do the ADD first, then making sure the disks were added and then the DROP ?
Question 2) Since the DB will be shutdown, I assume we can use "REBALANCE POWER 10" as no one will compete for I/O
Question 3) Any other suggestions ?
Thanks