Re: migrating 9i/HP-UX DB to 10g/Solaris

From: Dan Norris <dannorris_at_dannorris.com>
Date: Mon, 25 Jun 2007 18:39:20 -0700 (PDT)
Message-ID: <432728.63520.qm@web35407.mail.mud.yahoo.com>

It's a 10g DB feature, not an ASM feature, so no, it doesn't require ASM. Regular filesystem files can be migrated just the same as ASM storage. In fact, for most people, migrating filesystem files is probably quite a bit easier :).

Dan

• Original Message ---- From: Tim Gorman <tim_at_evdbt.com> To: dannorris_at_dannorris.com Cc: oracle-l_at_freelists.org; gulzar.arif_at_gmail.com Sent: Monday, June 25, 2007 4:44:59 PM Subject: Re: migrating 9i/HP-UX DB to 10g/Solaris

Using transportable tablespaces across platforms (i.e. HP-UX to Solaris) is only possible with ASM, no? So, to follow your recommendation, wouldn't he also have to add a step to migrate from file-system to ASM after upgrading to Oracle10g? Not a trivial undertaking...

...2 more pesos....

Dan Norris wrote:      

  If
it is a small database, I'd probably use export 9i -> import 10g. If it's got any significant size, I'd consider upgrading to 10g on HPUX, then use transportable tablespaces to Solaris/10g.   

Just my 2 pesos.   

Dan   

---

Original Message ----

From: Arif Gulzar <gulzar.arif_at_gmail.com>

To: oracle-l_at_freelists.org

Sent: Monday, June 25, 2007 2:35:27 PM

Subject: migrating 9i/HP-UX DB to 10g/Solaris   

I have been assigned to do best option to migrating 9i/HP-UX DB to 10g/Solaris, any body can forward me the step by step instructions to accomplish this, in both cases if the DB size is small/big.            

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 25 2007 - 20:39:20 CDT