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

On Mar 11, 2010, at 2:05 PM, Niall Litchfield <niall.litchfield_at_gmail.com  > wrote:

> bigger cojones or more experience :)
>
> On Thu, Mar 11, 2010 at 7:40 PM, Dan Norris
> <dannorris_at_dannorris.com> 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_at_gmail.com
> > 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_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
>>>
>>>
>>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l