Re: Database Migration and Upgrade across Servers ( from Solaris to HP)

From: jason arneil <jason.arneil_at_gmail.com>
Date: Thu, 31 Jul 2008 20:12:47 +0100
Message-ID: <fda4898f0807311212s7dbfd67eu581fd3fb4dcc12a4@mail.gmail.com>


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.

jason.

--
http://jarneil.wordpress.com


On Thu, Jul 31, 2008 at 6:37 PM, Bala <oratips_at_gmail.com> wrote:


> 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.
>>
>>
>>
>> Regards,
>>
>> Brandon
>>
>>
>>
>
>
>
> --
> Bala Rao
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 31 2008 - 14:12:47 CDT

Original text of this message