DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Restoring an Oracle database from a Unix environment to Windows environment

  1. 12-15-2008, 03:03 PM #1
    Oracle_Nooby
    Oracle_Nooby is offline Junior Member
    Join Date
    Dec 2008
    Posts
    2

    Restoring an Oracle database from a Unix environment to Windows environment

    Hi,,
    I am new to all of this so sorry if it seems like a dumb question. Also I looked through the forum to see if anyone had asked a similar question...couldn't find a similar one so here goes..

    The organisation I work for has a 10g Oracle database situated on a unix box, we are building a reporting solution for it. However our (development and reporting live environment) is Windows based (We have a windows based version of O10g installed there).

    Will we have problems moving a backup of the live system from Unix environment to Windows environment and will we be able to apply the re-do logs in the normal fashion? (We plan on keeping an up to date version on our windows server so management can run their reports without hurting the transactional system)

    Is it impossible to do? Or just plain complicated and difficult? Or should it be a breeze?

    Thanks in advance for any replies
    Reply With Quote Reply With Quote
  2. 12-15-2008, 03:59 PM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking select platform_id, platform_name from v$database;

    Data Guard can support specific mixed Oracle Platform combinations, check out Metalink Note:413484.1.

    Maybe a logical standby would be more acceptable.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
  3. 12-16-2008, 02:24 PM #3
    Oracle_Nooby
    Oracle_Nooby is offline Junior Member
    Join Date
    Dec 2008
    Posts
    2
    LKBrwn_DBA, Thanks for the reply. All I can find about mixed platform support in data guard is from 11g onwards. Does you/anyone know if data guard in 10g supports mixed platform? I have looked but it is like searching through the proverbial haystack.
    Reply With Quote Reply With Quote
  4. 12-16-2008, 07:22 PM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no it doesnt
    Reply With Quote Reply With Quote
  5. 12-17-2008, 05:03 AM #5
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by Oracle_Nooby
    LKBrwn_DBA, Thanks for the reply. All I can find about mixed platform support in data guard is from 11g onwards. Does you/anyone know if data guard in 10g supports mixed platform? I have looked but it is like searching through the proverbial haystack.
    I think you may want to check again Metalink Note:413484.1 ... as pointed out by LKBrwn_DBA

    Metalink note is pretty clear about what is available in each Oracle version.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  6. 12-17-2008, 09:45 PM #6
    ebrian
    ebrian is offline Senior Member
    Join Date
    Apr 2006
    Posts
    377
    I can think of three options:

    1. Data Pump (or emp/imp)
    2. Transportable Tablespace(s)
    3. Streams
    Reply With Quote Reply With Quote
  7. 12-22-2008, 03:31 AM #7
    sql888
    sql888 is offline Junior Member
    Join Date
    Dec 2008
    Posts
    4
    if it's 10gR2, I did the opposite, copy the standby DB's data files from Windows to Linux, the create control file, startup upgrade, then invalidate and recompile all packages.

    If the version is different, it needs to run $ORACLE_HOME/rdbms/admin/catalog.sql & catproc.sql
    Reply With Quote Reply With Quote
  8. 12-22-2008, 08:42 AM #8
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by sql888
    if it's 10gR2, I did the opposite, copy the standby DB's data files from Windows to Linux, the create control file, startup upgrade, then invalidate and recompile all packages.

    If the version is different, it needs to run $ORACLE_HOME/rdbms/admin/catalog.sql & catproc.sql
    Jeff Hunter
    Reply With Quote Reply With Quote
  9. 12-22-2008, 10:15 AM #9
    aaryaan
    aaryaan is offline Junior Member
    Join Date
    Mar 2008
    Posts
    8
    Hi,
    Streams will be the best option if you are looking for almost real time data.

    Regards,
    Satheesh Babu S
    http://satheeshbabus.blogspot.com
    Reply With Quote Reply With Quote
  10. 12-22-2008, 07:02 PM #10
    ebrian
    ebrian is offline Senior Member
    Join Date
    Apr 2006
    Posts
    377
    Quote Originally Posted by sql888
    if it's 10gR2, I did the opposite, copy the standby DB's data files from Windows to Linux, the create control file, startup upgrade, then invalidate and recompile all packages.

    If the version is different, it needs to run $ORACLE_HOME/rdbms/admin/catalog.sql & catproc.sql
    So not only are you just moving datafiles around different platforms at will, but you are just running catalog.sql & catproc.sql to account for different versions ??
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width