DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Move Database from Windows to Solaris

  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Question Move Database from Windows to Solaris

    We have a fairly large medical records database (Physical size 250gb) currently residing on a Windows 2000 server and will be moving off Windows to a new Solaris server. Oracle is currently at version 9.2.0.1.0 and we plan to move to the current patch level as soon as the vender gives us the word and before the move.

    We are looking for suggestions to make this migration since this is a high profile system and we have been told by the vender the move from Windows to Unix will take quite a long time.

    Currently the only known solution is to export--binary copy--import. We would like to know if we can make the new server a standby server, restore a backup copy of the database, then mount the database and apply archive logs from the Windows server to bring the new Solaris server up to current.

    If this will not work, does anyone have and ideas or suggestions that would help us with this move. Thank You.
    Last edited by tuftse; 03-10-2006 at 03:06 PM. Reason: Change title

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no you cant do the backup method

    exp / imp
    sqlplus copy
    ctas over dblinks

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    This thread gives you lots of input:

    http://www.dbasupport.com/forums/showthread.php?t=50630
    "What is past is PROLOGUE"

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