Restoring an Oracle database from a Unix environment to Windows environment
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. #1
    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

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    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

  3. #3
    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no it doesnt

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  6. #6
    Join Date
    Apr 2006
    Posts
    377
    I can think of three options:

    1. Data Pump (or emp/imp)
    2. Transportable Tablespace(s)
    3. Streams

  7. #7
    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

  8. #8
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    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

  10. #10
    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 ??

Posting Permissions

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



Click Here to Expand Forum to Full Width