transfer to a new server (need Help)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: transfer to a new server (need Help)

  1. #1
    Join Date
    Dec 2000
    Posts
    18

    Lightbulb

    Need help, my situation is this

    Company bought a new server to replace the old oracle server.

    question:

    any suggestion on how to transfer of the database from the old server to the new server? and is this possible?

    note: I tried before an import but 2 days after the import is not yet finished.

    thanks


  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Wow, I assume that this is a large db. You could tune the instance to speed up the import, but since it's already in progress, there's not much that can be done now. You could precreate the db on the new machine and transfer the cold backup from the old server.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Have a look at the old thread. My posting mention little breifing about cloning...

    How big is your database ?

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5225[/url]

  4. #4
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    A couple of options are listed below

    1. As metioned before - Use a cold backup of the original database on the new machine you will have to rename the datafiles unless the new server has the same filesystems setup.

    2. If both machines are networked create a new (empty) database on the new server and create a database link between the original and new databases. You can then use Create table as select command over the dblink.
    Be carefull with this....If you miss a table you'll get problems in your application

    3. Export/Import - You have already tried this without too much success...

    Try taking an export without the data (with rows=N) this will get the structure of the database over onto the new server. You can then move the database (inc rows) 1 schema at a time.

    If there are a couple of large tables (maybe the reason for the export taking so long) try a combination of export/import and dblink. Use the dblink for the few large tables and the export/import for all the others.

    Hope this is of some help

    Good luck

    Moff.

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