FAQ
Greetings,


My plan is to migrate an Oracle 10.2.0.3 Win2003 32 bit to an Oracle
10.2.0.3 Linux 64bit RH 4.
Have any of you guys ever tried to use RMAN backup/restore function to
copy
the Win32 DB to Linux 64 bit DB?
What I need to be able to achieve is that the Win 32 DB be active while
I do the RMAN backup, than I restore the DB using RMAN on Linux.

TIA

Yuval.

This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you, oracle-l_at_freelists.org, are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.

Search Discussions

  • Alex Gorbachev at Aug 1, 2007 at 4:18 pm
    Metalink has the answers.
    See Note 430278.1 Can you restore RMAN backups taken on 32-bit Oracle
    with 64-bit Oracle? and then 62290.1 Changing between 32-bit and
    64-bit Word Sizes.
    On 8/1/07, Arnon, Yuval wrote:
    My plan is to migrate an Oracle 10.2.0.3 Win2003 32 bit to an Oracle
    10.2.0.3 Linux 64bit RH 4.
    Have any of you guys ever tried to use RMAN backup/restore function to
    copy
    the Win32 DB to Linux 64 bit DB?
    What I need to be able to achieve is that the Win 32 DB be active while
    I do the RMAN backup, than I restore the DB using RMAN on Linux.
    --
    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
  • Binh Pham at Aug 1, 2007 at 4:49 pm
    Another organization in our company wants to purchase NetIQ to replace
    Tivoli.

    Anyone has any experience with both of these products (NetIQ and Oracle Grid
    Control?

    Can you give me some pro's and con's between them?

    Thanks in advance.
  • Sweetser, Joe at Aug 1, 2007 at 5:38 pm
    The product I am somewhat familiar with is AppManager. We used it at my
    last job but my opinions come with a major disclaimer: we only used it
    for monitoring. I'd imagine it might be able to some things (run
    scripts on a schedule and the like) but we had a NetIQ admin who
    configured and ran the product. That said, the integration with Oracle
    was pretty good but not perfect. I think if you are ONLY going to use
    it for Oracle, Grid Control is probably the better way to go. However,
    if you have a heterogeneous environment and are looking to monitor
    systems along with databases from multiple vendors, AppManager is
    probably the better choice (of course, I haven't messed around with GC
    plug-ins yet). I don't think AppManager knew anything about RMAN and
    backups. Again - not saying it couldn't be scripted but it wasn't there
    out of the box.

    -joe

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Binh Pham
    Sent: Wednesday, August 01, 2007 10:49 AM
    To: ag_at_oracloid.com; Yuval.Arnon_at_webloyalty.com
    Cc: oracle-l_at_freelists.org
    Subject: AppManager from NetIQ versus Oracle OEM Grid Control

    Another organization in our company wants to purchase NetIQ to replace
    Tivoli.

    Anyone has any experience with both of these products (NetIQ and Oracle
    Grid Control?

    Can you give me some pro's and con's between them?

    Thanks in advance.

    --
    http://www.freelists.org/webpage/oracle-l



    Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

    --
    http://www.freelists.org/webpage/oracle-l
  • Jared Still at Aug 1, 2007 at 5:40 pm
    On 8/1/07, Alex Gorbachev wrote:

    >
    Metalink has the answers.
    See Note 430278.1 Can you restore RMAN backups taken on 32-bit Oracle
    with 64-bit Oracle? and then 62290.1 Changing between 32-bit and
    64-bit Word Sizes.
    Thanks Alex.

    Those docs don't really give any details on getting th 64 bit backup
    restored to the 32 bit machine.

    I ran into this problem:
    http://www.freelists.org/archives/oracle-l/09-2006/msg00495.html

    If the database were shutdown cold and copied to the other server,
    this would be a non-issue.

    RMAN on 32 bit linux could not cope with the archive logs created
    on the 64 bit linux box. Maybe a bug, but I could find nothing to
    help at the time I was working on this.

    --
    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist

    --
    http://www.freelists.org/webpage/oracle-l
  • Sandra Becker at Aug 2, 2007 at 1:19 pm
    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 at Aug 2, 2007 at 2:00 pm
    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 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
  • Jametong at Aug 2, 2007 at 5:44 pm
    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 ´ú
    ±í 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 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
  • Jared Still at Aug 1, 2007 at 4:57 pm
    On 8/1/07, Arnon, Yuval wrote:

    >
    My plan is to migrate an Oracle 10.2.0.3 Win2003 32 bit to an Oracle
    10.2.0.3 Linux 64bit RH 4.
    Have any of you guys ever tried to use RMAN backup/restore function to
    copy
    the Win32 DB to Linux 64 bit DB?
    What I need to be able to achieve is that the Win 32 DB be active while
    I do the RMAN backup, than I restore the DB using RMAN on Linux.
    While the datafiles will work, the archivelog files ( and IIRC the
    controlfiles)
    are not in the same format between 32bit and 64bit databases.

    I've tried restoring a 64bit Linux database to 32bit server.
    The datafiles work, the controlfiles/archivelogs do not.

    see http://www.freelists.org/archives/oracle-l/09-2006/msg00361.html

    I moved a bunch of Win32 databases to 64bit Linux. It was all done
    via export/import.

    --
    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist

    --
    http://www.freelists.org/webpage/oracle-l
  • Alex Gorbachev at Aug 1, 2007 at 5:03 pm
    From Grid Control point of view you won't see any difference. The only
    difference might be how you configure you tape channels.

    The question is how well (or how buggy) RMAN integration with
    particular tape manager is working. I can't answer this one,
    unfortunately.
    On 8/1/07, Binh Pham wrote:
    Another organization in our company wants to purchase NetIQ to replace
    Tivoli.

    Anyone has any experience with both of these products (NetIQ and Oracle Grid
    Control?

    Can you give me some pro's and con's between them?

    Thanks in advance.
    --
    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
  • Tony van Esch at Aug 11, 2007 at 7:22 am
    Hi,

    You might look into the 'convert' command of rman.

    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta018.h
    tm#sthref346

    Regards, Tony van Esch

    -----Oorspronkelijk bericht-----
    Van: oracle-l-bounce_at_freelists.org
    Namens Arnon, Yuval
    Verzonden: woensdag 1 augustus 2007 16:34
    Aan: oracle-l_at_freelists.org
    Onderwerp: Migrate Oracle WIN32 bit to LINUX 64 bit.

    Greetings,


    My plan is to migrate an Oracle 10.2.0.3 Win2003 32 bit to an Oracle
    10.2.0.3 Linux 64bit RH 4.
    Have any of you guys ever tried to use RMAN backup/restore function to copy
    the Win32 DB to Linux 64 bit DB?
    What I need to be able to achieve is that the Win 32 DB be active while I do
    the RMAN backup, than I restore the DB using RMAN on Linux.

    TIA

    Yuval.

    This transmission may contain information that is privileged, confidential
    and exempt from disclosure under applicable law. If you,
    oracle-l_at_freelists.org, are not the intended recipient, you are hereby
    notified that any disclosure, copying, distribution, or use of the
    information contained herein (including any reliance thereon) is STRICTLY
    PROHIBITED. If you received this transmission in error, please immediately
    contact the sender and destroy the material in its entirety, whether in
    electronic or hard copy format.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 1, '07 at 2:33p
activeAug 11, '07 at 7:22a
posts11
users8
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase