Moving an Oracle database from one server to another
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.
all good, dont forget to change any clients with new IP
What don't you just clone it? duplicate target database to new_db;
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
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.
Click Here to Expand Forum to Full Width