Home » RDBMS Server » Backup & Recovery » Cloning a database from one m/c to another (Oracle, 10g,Windows)
Cloning a database from one m/c to another [message #280050] Mon, 12 November 2007 06:42 Go to next message
sobhapratap
Messages: 6
Registered: November 2007
Junior Member
Hi all ,

I am sobha, new to Oracle.

I need to clone a database from one machine to another.Oracle 10g is installed on both the machines(both are windows) and the database is already created on the target machine.

I have copied the DBF, CTL ,log files from source machine to target machine. Basically I have overwritten the earlier files on the target m/c.

If the DBF files path in both the machines is same, then I am able to access the m/c in target machine. But here the path is different in both machines, hence I couldnt access the database.

Pls advise.. It is very urgent for me.. I tried so many ways but none of them worked for me..


Thanks in advance,
Sobha
Re: Cloning a database from one m/c to another [message #280063 is a reply to message #280050] Mon, 12 November 2007 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Which Oracle Edition do you have? Entreprise (EE), Express (XE)...?
Have a look at RMAN to duplicate your database.

Regards
Michel
Re: Cloning a database from one m/c to another [message #280074 is a reply to message #280063] Mon, 12 November 2007 07:21 Go to previous messageGo to next message
sobhapratap
Messages: 6
Registered: November 2007
Junior Member
Hi ,
It is enterprise edition but freeware
Re: Cloning a database from one m/c to another [message #280082 is a reply to message #280074] Mon, 12 November 2007 07:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
So use RMAN.
It has a duplicate command and you can relocate your files.

Regards
Michel
Re: Cloning a database from one m/c to another [message #280084 is a reply to message #280082] Mon, 12 November 2007 07:40 Go to previous messageGo to next message
sobhapratap
Messages: 6
Registered: November 2007
Junior Member
Can u pls eloborate on this RMAN?
Re: Cloning a database from one m/c to another [message #280087 is a reply to message #280084] Mon, 12 November 2007 07:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Backup and Recovery Advanced User's Guide

Regards
Michel
Re: Cloning a database from one m/c to another [message #280272 is a reply to message #280087] Tue, 13 November 2007 00:49 Go to previous messageGo to next message
sobhapratap
Messages: 6
Registered: November 2007
Junior Member
Hi ,
instead of using RMAN, any other way is there by copying DBF files?

Thanks
Sobha
Re: Cloning a database from one m/c to another [message #280274 is a reply to message #280050] Tue, 13 November 2007 00:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>instead of using RMAN, any other way is there by copying DBF files?
yes, scp
Re: Cloning a database from one m/c to another [message #280297 is a reply to message #280274] Tue, 13 November 2007 02:09 Go to previous messageGo to next message
sobhapratap
Messages: 6
Registered: November 2007
Junior Member
What is it?
Re: Cloning a database from one m/c to another [message #280300 is a reply to message #280297] Tue, 13 November 2007 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
copy.

Regards
Michel
Re: Cloning a database from one m/c to another [message #280319 is a reply to message #280300] Tue, 13 November 2007 03:39 Go to previous messageGo to next message
sobhapratap
Messages: 6
Registered: November 2007
Junior Member
Yes...I have already copied DBF,CTL and log files..but I couldnt start the database after that...Anything else need to be done after copying them?
Re: Cloning a database from one m/c to another [message #280321 is a reply to message #280319] Tue, 13 November 2007 03:50 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You have to startup, mount execute an "alter database" on each file to rename them to the new location and then open the database.

Regards
Michel
Previous Topic: How to create tablespace from backup
Next Topic: Problems with Recovery
Goto Forum:
  


Current Time: Fri Nov 22 21:44:30 CST 2024