Home » RDBMS Server » Backup & Recovery » Copy contents of oradata
Copy contents of oradata [message #223543] Fri, 09 March 2007 07:00 Go to next message
rojo72
Messages: 7
Registered: March 2007
Junior Member
I am trying to move a database from one server to another. They both are Server 2003 OS and running Oracle 10.2.0.3 but different hardware.

Will it work properly if I stop te database service and copy the contents of the following folder from one machine to the other?

:\oracle\product\10.2.0\oradata\
Re: Copy contents of oradata [message #223544 is a reply to message #223543] Fri, 09 March 2007 07:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it should work.
Search the forum for COLD COPY or COLD CLONE
Re: Copy contents of oradata [message #223547 is a reply to message #223543] Fri, 09 March 2007 07:20 Go to previous messageGo to next message
rojo72
Messages: 7
Registered: March 2007
Junior Member
If the target server's Oracle path is a different drive letter will it matter when I start it?

I guess what I am asking is: Is there anything else I will need to do after copying the Cold backup files?

The machine I am copying to has a database with the same name and similar contents.
Re: Copy contents of oradata [message #223550 is a reply to message #223547] Fri, 09 March 2007 07:24 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As said, Search the forum.
You need to take backup of controlfile in text format (backup controlfile to trace).
Edit the text file to reflect your current path.
Previous Topic: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Next Topic: backup
Goto Forum:
  


Current Time: Wed Dec 07 07:00:40 CST 2016

Total time taken to generate the page: 0.25841 seconds