|
-
You can try out the following.
1) Shutdown the dev database and copy initDBNAME.ora, pwdDBNAME.ora, datafiles, control files, redo logfiles to the new machine.
2) Edit the initDBNAME.ora to change the control file location.
3) Create new service using ORADIM utility and mention the initDBNAME.ora path.
4) Startup mount and rename all datafiles and redologfiles.
5) Alter database open.
6) You need not change the db_name, just use the connect string ora_UAT to connect to this DB with SID as ora_dev and new machine ip/machinename as hostname.
7) Make changes in the listener.ora file to register the database manually.
HTH
Amar
"There is a difference between knowing the path and walking the path."
 
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
|
Reply With Quote