Moving Production database to new machine
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Moving Production database to new machine

  1. #1
    Join Date
    Jan 2004
    Posts
    22

    Moving Production database to new machine

    We have one production oracle database ver 9.2.0.1.on solaris 8.We want to move it to new solaris machine.I have two questions first We want to move it to new machine whats the best possible way to go so that downtime is minimal or no downtime. Second question is we want to upgrade this database ver to 9.2.0.4 on new machine. Should we install 10g database on new machine and do import/export from older version of our database or should we install the same version 9.2.0.1 on new machine and apply upgrade patch on new machine. I want to minimse the time of transition for this process. Any Suugestions will be greatly appreciated

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    the upgrade is your downtime.

    If you are moving same to same (ie hardware, software etc) then create a standby db on the new server and then perform a switchover operation that will gracefully switch the db to the new server and zero data loss. Your downtime with a switchover should be inside of an hour if all goes well.

    Regards,

    Steve
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Use RMAN and Auxiliary Instance to duplicate, its the fastest and easiest... zip... zip... zooooom..........

    http://download-west.oracle.com/docs...pdb.htm#441628
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Good stuff!!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by adewri
    Use RMAN and Auxiliary Instance to duplicate, its the fastest and easiest... zip... zip... zooooom..........

    http://download-west.oracle.com/docs...pdb.htm#441628
    Yep, duplicate! Very fast and safe method.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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