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

 
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@xxxxxxxxxxxxxxx
          jametong@xxxxxxxxx
Msn     : kt_tongjiawang@xxxxxxxxxxx
Yahoo   : jametong
Alitalk : jametong
Skype   : jametong
----------------------------- 

-----邮件原件-----
发件人: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 代
表 Alex Gorbachev
发送时间: 2007年8月2日 22:00
收件人: Sandra Becker
抄送: jkstill@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
主题: 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@xxxxxxxxx> 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


Other related posts: