Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to migrate to ASM?

Re: Best way to migrate to ASM?

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Wed, 14 Sep 2005 08:31:31 -0700
Message-ID: <KMmdnXdCKrbJ37XeRVn-rw@comcast.com>


mea0730 wrote:
> I'm planning to migrate from a single instance non-ASM database to a
> new 2 node RAC database using ASM. We are running Oracle 10.1.0.4
> Standard Edition on Solaris 9 on all servers. I'm looking for
> recommendations on the best way to do this. Should I look at using the
> datapump or RMAN? So far the only documentation I've been able to
> find on metalink are for doing "inplace" migration to ASM using
> RMAN (moving the current database to ASM on the same server). That
> won't work for me. I need to move to a new database on different
> servers. Does anyone have any guidance on the best way to do this?
>
> Thanks,
> Mike
>

10.2 has support for using transportable tablespaces to get data into ASM. Otherwise if you can't use RMAN (?) then you will need to use DataPump exp/imp Received on Wed Sep 14 2005 - 10:31:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US