Re: Database Migration and Upgrade across Servers ( from Solaris to HP)
Date: Thu, 31 Jul 2008 20:12:47 +0100
A couple of years back I did a migration from 10.1 Solaris Sparc to 10.2 Linux.
Datapump did a cracking job of shifting around 100GB of data. I reckoned around 3x as fast at importing as the old exp/imp method.
Don't discount transportable tablespaces, particularly if you are not having to change endianness. I think transportable tablespaces are probably the fastest method of all for this type of migration.
-- http://jarneil.wordpress.com On Thu, Jul 31, 2008 at 6:37 PM, Bala <oratips_at_gmail.com> wrote:Received on Thu Jul 31 2008 - 14:12:47 CDT
> Thank you very much for your thoughts. There is flexibility schedule wise
> -- hardly any constraints -- I was thinking of datapump , but would revisit
> good ol' exp/imp...
> Thanks again!
> On 7/31/08, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>> My preference is to always use exp/imp unless there is a good reason not
>> to do so, e.g. uptime requirements. Export followed by import into a brand
>> new database gives you a nice clean data dictionary with that fresh new
>> 10.2.0.4 smell, plus you get a full defrag of all your segments as a
>> bonus (not that I'm a proponent of regular segment rebuilds) and can take
>> the opportunity to change your tablespace layout or configurations if
>> desired. There are at least a few serious bugs that can hit after in-place
>> upgrades (*not* if you use exp/imp) – check Metalink for details. The
>> ones I'm thinking about are specific to databases that were upgraded from 8i
>> to 10g, IIRC. Since you're on 10g, expdp/impdp could be worth considering
>> too, but from what little testing I've done with datapump, it was much
>> slower and more complicated than good 'ol exp/imp.
> Bala Rao