Re: Moving 10gR2 db from one ASM diskgroup to another ASM diskgroup

From: Don Seiler <don_at_seiler.us>
Date: Thu, 11 Mar 2010 13:17:59 -0600
Message-ID: <94e86aed1003111117h47ac4e82k1ab5af4102cf84b_at_mail.gmail.com>

That should work fine if the database is not open (ie just mounted). Otherwise you may have to add a RECOVER DATABASE step.

Also check for locations like FRA and log archive destinations, if they are also moving.

Don.

On Thu, Mar 11, 2010 at 1:14 PM, Daniel Fink <daniel.fink_at_optimaldba.com> 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/
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 11 2010 - 13:17:59 CST