Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Wed, 14 Sep 2005 10:31:31 -0500 Date: Wed, 14 Sep 2005 08:31:31 -0700 From: Mark Townsend User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Best way to migrate to ASM? References: <1126679127.176054.54100@g47g2000cwa.googlegroups.com> In-Reply-To: <1126679127.176054.54100@g47g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Lines: 18 NNTP-Posting-Host: 24.5.7.112 X-Trace: sv3-TL3WYZFJFjtLCK8UHKZIBZwYxYBHZh8gcM//OINRY1edKy6+ySOFmwmy+sZ24obwNU4/GLOSDgtnlNI!4wzeD0R/dNEwU0l4eRib4xe8eRm6PZqpnuePyT9FCtzr2R6ez1EXhksLm5jpesw7ZemrvTzU9VRl!QLQ= X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251499 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