OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Its on Clonning...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Its on Clonning... [message #146603]

Fri, 11 November 2005 07:10

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

can we clone oracle database which is on linux on windows machine (i.e.clone database on windows)?

Regards
sunilkumar

[Updated on: Fri, 11 November 2005 07:20]

Report message to a moderator

Re: Its on Clonning... [message #146605 is a reply to message #146603]

Fri, 11 November 2005 07:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Which 'cloning' method are you talking about.
If you are talking about using RMAN/COLD Copy backup methods then NO. Those files are OS dependent.
Any transfer between different OS is facilitated only by
1. Sql means (materilized views/dblinks etc)
2. Export / import.

Report message to a moderator

Re: Its on Clonning... [message #146610 is a reply to message #146605]

Fri, 11 November 2005 07:43

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Suppose if i have database AONLINUX on linux and i want to make clone database of it with name AONWIN but AONWIN must be at window server it should not be at linux... Is it possible?

If yes then how ...

Thanks & Regargs
Always Friend Sunilkumar

Report message to a moderator

Re: Its on Clonning... [message #146611 is a reply to message #146610]

Fri, 11 November 2005 07:48

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

same response again.
If this a one time operation, with not-so-large database , export /import is the way.
Else
If 'synchronizing' the data is done frequently, and database is large,use materialized views.
CLONE is a complete duplicate done in OS/Database level.
Since the datafiles and RMAN backupsets are proprietory to the Operating system, you cannot use RMAN duplication or good old cold copy methods.

Report message to a moderator

Re: Its on Clonning... [message #146617 is a reply to message #146611]

Fri, 11 November 2005 09:00

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Thanks maheshji ,,, i got the answer.... in the case that i told u only export import is doen to clone ..

but if both the o/s are same then i can directly copy the datafile of database from one server to another for clone database ... no need for export import Smile

just we have to create pfile and controlfile and logfile

thanks
Always friend sunilkumar

Report message to a moderator

Previous Topic:	database shutdown
Next Topic:	connect database without password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:58:10 CST 2025