Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> 答复: Migrate Oracle WIN32 bit to LINUX 64 bit.

答复: Migrate Oracle WIN32 bit to LINUX 64 bit.

From: jametong <jametong_at_gmail.com>
Date: Fri, 3 Aug 2007 01:44:16 +0800
Message-ID: <46b21835.18bd720a.6152.24c7@mx.google.com>

 

You can us materialized views on prebuilt table or us triggers to sync database .

then you can have only 5 minutes or so time to switch to the new database.

I use this method to migrate from Dell 6850 (Linux x86) to IBM P570 (Aix 64bit) with only 30 seconds downtime.

---Well IBM zSeries and Linux x86/x64_86 are different platforms. You can use transportable tablespaces with, possibly, conversion using RMAN if they have different endian.

this needs both database to be 10g. Oracle9i didn't support migration from different platforms.

Jametong  

DBA Team. B2B. 阿里巴巴中国


Phone   : 0571-85022088-12372
Fax     : 0571-85022958
Mobile  : 135-8803-9828
Mail    : jame.tongjw_at_alibaba-inc.com
          jametong_at_gmail.com
Msn     : kt_tongjiawang_at_hotmail.com
Yahoo   : jametong

Alitalk : jametong
Skype : jametong

-----邮件原件-----
发件人: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 代 表 Alex Gorbachev
发送时间: 2007年8月2日 22:00
收件人: Sandra Becker
抄送: jkstill_at_gmail.com; oracle-l_at_freelists.org 主题: Re: Migrate Oracle WIN32 bit to LINUX 64 bit.

Well IBM zSeries and Linux x86/x64_86 are different platforms. You can use transportable tablespaces with, possibly, conversion using RMAN if they have different endian.

In this thread we were talking about Linux x86 vs Linux x64_86 which are the same platform but different "bitness".

So your "technical specialist" is right - you can use old fashioned export/import, data pump export/import or over the network, or transportable tablespaces with either export/import or data pump.

On 8/2/07, Sandra Becker <sbecker6925_at_gmail.com> wrote:
> What about using a backup of 64-bit Oracle 10.2.0.2, RHEL4 on a Dell
> server to Oracle 10.2.0.2, RHEL4 on an IBM Series z9 zVM? Will that work as
well?
> An IBM "technical specialist" (salesman saying he knows what to do)
> says we have to use data pump and trasportable tablespaces. I haven't
> had a chance yet to read much on data pump so it might be preferable
> anyway. Just curious what options are available to me. I haven't
> been able to find anything really useful on Metalink yet either.
>
> Sandy
>
>

--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com BAAG party -
www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 02 2007 - 12:44:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US