Re: move database from sparc to linux
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sun, 20 Jun 2010 22:50:40 +0200
Message-ID: <887d9fF7ltU1_at_mid.individual.net>
On 20.06.2010 22:33, John Hurley wrote:
> tb:
>
>> i have to move a 10.2.0.3 database from solaris sparc to red hat
>> linux. I see 4 possibilities
>>
>> 1. exp/imp
>> 2. expdp/impdp
>> 3. Transportable Tablespaces
>> 4. Oracle Streams
>>
>> The first approach was expdp and was not succesful, because there are
>> 400000 database objects in a 100GByte database. When i'm using expdp
>> there, is no progress after one hour. I think exp will take between 30
>> and 35 hours. Any idea is welcome.
>
> I would expect ( with reasonable bandwidth between the systems ) that
> you could use a link and impdp and parallel and complete the process
> in 8 hours or less. Unless the IO characteristics of the new linux
> system really suck.
Date: Sun, 20 Jun 2010 22:50:40 +0200
Message-ID: <887d9fF7ltU1_at_mid.individual.net>
On 20.06.2010 22:33, John Hurley wrote:
> tb:
>
>> i have to move a 10.2.0.3 database from solaris sparc to red hat
>> linux. I see 4 possibilities
>>
>> 1. exp/imp
>> 2. expdp/impdp
>> 3. Transportable Tablespaces
>> 4. Oracle Streams
>>
>> The first approach was expdp and was not succesful, because there are
>> 400000 database objects in a 100GByte database. When i'm using expdp
>> there, is no progress after one hour. I think exp will take between 30
>> and 35 hours. Any idea is welcome.
>
> I would expect ( with reasonable bandwidth between the systems ) that
> you could use a link and impdp and parallel and complete the process
> in 8 hours or less. Unless the IO characteristics of the new linux
> system really suck.
That's what I'd attempt, too. I think there are also some constraints on this IIRC charsets must match. Otherwise you get error messages that are not really revealing.
Cheers
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sun Jun 20 2010 - 15:50:40 CDT