-
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
-
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
email: ocp_9i@yahoo.com
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|