Moving an Oracle database from one server to another
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Moving an Oracle database from one server to another

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Moving an Oracle database from one server to another

    Hi all,

    The need has arisen to move one of our databases from one server and recreate onto another new server. The new server will have the same o/s Windows 2003 and run on the same Oracle version (10.2.1). Because of this i would have thought this would be the easiet way to move the database:

    1/ Shutdown the db/listener on the original box
    2/ Take a cold back of the db
    3/ Create the new service on new box
    4/ Restore the coldbackup to the new server
    5/ Startup mount with pfile if restore is to new directories and then rename in mount state OR if directories match the original server then a normal startup should do.
    6/ Create a listener on the new server
    7/ Check all connections
    8/ Take backup of new db

    Is there any steps i am missing or can do differently or is this the best way? Any advice will be greatly appreciated.

    Thanks,
    Chucks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    all good, dont forget to change any clients with new IP

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    Thanks Davey

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    What don't you just clone it? duplicate target database to new_db;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    he didn't say he was using rman
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

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