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\

Report message to a moderator

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: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it should work.
Search the forum for COLD COPY or COLD CLONE

Report message to a moderator

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.

Report message to a moderator

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: 10707
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.

Report message to a moderator

Previous Topic: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Next Topic: backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 09:13:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.