move db to new server [message #56488] |
Thu, 03 April 2003 07:08 |
denise
Messages: 64 Registered: November 2000
|
Member |
|
|
hello
we have a 7 gig db and are purchasing a new server.
the new server will be created with the exact same
environment as the old server. NT4 Server OS
what is the fastest way to move db to new server
without having to do export/import(can take 3 days).
What about backup/restore?
thanks in advance
|
|
|
Re: move db to new server [message #56489 is a reply to message #56488] |
Thu, 03 April 2003 07:27 |
psmyth
Messages: 81 Registered: October 2002
|
Member |
|
|
if the new server is setup exactly the same way (same filesystems etc), you should be able to just shutdown the original db, copy across all the files onto the new server, keeping them in the same filesystem locations obviously, and start it up.
update your listener config with any new ip info etc, and make sure your db_links etc still work ok, but you shouldn't have any problems.
good luck!
|
|
|
|
|