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

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <dannorris@xxxxxxxxxxxxx>, <tim@xxxxxxxxx>
  • Date: Tue, 26 Jun 2007 09:46:01 -0400

I believe upgrading to 10g may very well be required to perform
cross-platform transportable tablespaces.   However, it would probably
be faster.   Is is not limited by ASM.   Your going to be upgrading
anyway with export/import, so manual upgrade is not necessarily an
ordeal.   Note: 316889.1


Joel Patterson 
Database Administrator 
904  727-2546 


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dan Norris
Sent: Monday, June 25, 2007 9:39 PM
To: tim@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; gulzar.arif@xxxxxxxxx
Subject: Re: migrating 9i/HP-UX DB to 10g/Solaris


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 :).


----- Original Message ----
From: Tim Gorman <tim@xxxxxxxxx>
To: dannorris@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; gulzar.arif@xxxxxxxxx
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.


----- Original Message ----
From: Arif Gulzar <gulzar.arif@xxxxxxxxx> <mailto:gulzar.arif@xxxxxxxxx>

To: oracle-l@xxxxxxxxxxxxx
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. 



Other related posts: