Re: Moving Database from one server to another.

xan_at_iinet.net.au (Phil Kan) wrote:
>The company I work for has upgraded our database server from a single
>machine to a RAID box. I need to be able to move the database from one
>server to the other. Is there anything further involved than just
>exporting the entire database, transfering it to the new server and
>then importing?
>Some of the data will have to be changed, but thats another posts
>worth!

Phil:
You didn't say what kind of server you're talking about. Here at Ford most of our databases are on HP UX. All of our file systems are very close to Cary Millsap's OFA standard. We move databases from one server to another pretty easily. Even if you have to rename all the database, log and control files, its still goes pretty smoothly. I would try and copy the datafiles, if the two servers are the same type before I do a full EXPort/IMPort.
Hope this helps.

-- 
========================================================================
  Bob Manieri                           email : bmanieri_at_ford.com
  Database Administrator                voice : (610) 584-7085
  Ford Electronics, Lansdale, PA        pager : (609) 342-0314
========================================================================
You're an actor when they pay you to act.
      Gable is the best, because he gets the most.   Spencer Tracy