Re: Moving 10gR2 db from one ASM diskgroup to another ASM diskgroup
- From: "Daniel Fink" <daniel.fink@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 Mar 2010 11:50:59 -0800
We got a George Carlin-esque "Well...I'm not sure about that" response from an
SA about that particular scenario.
We will be adding disks from a different SAN (SAN2) and then dropping disks
from the original SAN (SAN1). Do you see any problems with this?
Taking the database down is not a problem. It is a non-production system that
we have permission to down...but the team also want it back up as soon as
possible.
------- Original Message -------
On 3/11/2010 7:44 PM Don Seiler wrote:
Very wise indeed. Much better option than backing up as copy and switching.
You'll probably want to raise up the ASM rebalancing power ("this one
goes to 11") if there's nothing else on that particular system.
Don.
On Thu, Mar 11, 2010 at 1:40 PM, Dan Norris <dannorris@xxxxxxxxxxxxx> wrote:
I would add and remove in a single alter diskgroup statement. That way, you
only need one rebalance operation.
Dan
On Mar 11, 2010, at 1:35 PM, Niall Litchfield <niall.litchfield@xxxxxxxxx>
wrote:
Dan, by far the fastest way is to add the new disks onto the disk group,
rebalance, then remove the old disks and rebalance. No downtime.
On Mar 11, 2010 7:15 PM, "Daniel Fink" <daniel.fink@xxxxxxxxxxxxxx> wrote:
A colleague is trying to move a database from one ASM diskgroup on the
database server to another ASM diskgroup. They have added a new SAN and want
to move the database to it.
We are trying to determine the best way and fastest (tight deadline). Not a
lot of time for testing. The database is not production and we have an
export, but would rather not go through the process of totally recreating
it.
Does anyone have experience moving a db from one ASM diskgroup to another
diskgroup in the same instance?
Any experience with the following 10g command to accomplish this? (From Tim
Hall's site)
# Copy the database into the ASM disk group.
RMAN> BACKUP AS COPY DATABASE FORMAT '+disk_group';
# Switch all datafile to the new ASM location.
RMAN> SWITCH DATABASE TO COPY;
Any/All input greatly appreciated!
Regards,
Daniel
-------------------------------------------
Daniel Fink
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Lost Data? http://www.ora600.be/
--
//www.freelists.org/webpage/oracle-l
--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
-------------------------------------------
Daniel Fink
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Lost Data? http://www.ora600.be/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
