Re: Moving 10gR2 db from one ASM diskgroup to another ASM diskgroup
- From: Don Seiler <don@xxxxxxxxx>
- To: daniel.fink@xxxxxxxxxxxxxx
- Date: Thu, 11 Mar 2010 13:17:59 -0600
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
