Home » RDBMS Server » Server Administration » Server to Server
Server to Server [message #117513] Wed, 27 April 2005 12:11 Go to next message
khan@oracle
Messages: 1
Registered: April 2005
Junior Member
hi everybody ,
I want help in following matter.

I have an Oracle database on Windows Server , I want to tranfer the whole database to another Server.Please give me the steps to follow this transfer . Looking forward for ur kind reply.

thnks in advance

Report message to a moderator

Re: Server to Server [message #117552 is a reply to message #117513] Thu, 28 April 2005 02:48 Go to previous messageGo to next message
deepa_balu
Messages: 74
Registered: March 2005
Member
Hi,

If ur destination server is going to be the same windows server then u can do cloning of the database.

Follow this link for doing this.
http://www.samoratech.com/TopicOfInterest/swCloneDB.htm


But if u destination server is going to be some unix box or someother operating system other than windows then u can do a full databaseexport of ur source and then import into the destination Database

Report message to a moderator

Re: Server to Server [message #118908 is a reply to message #117513] Mon, 09 May 2005 11:10 Go to previous messageGo to next message
srini33768
Messages: 3
Registered: May 2005
Location: Dublin
Junior Member
Hi,

Why we need to export the entire database its too long to do instead you create db on destination & copy all the .db file along with redo and ctrl files change the relavent paths and startup the database.

Thanks.

Report message to a moderator

Re: Server to Server [message #118919 is a reply to message #118908] Mon, 09 May 2005 12:41 Go to previous messageGo to next message
Anonymous
Hi,

Well you cant simply copy the DB related files across the platform and start the DB. To do so you have to use the logical backup i.e. export/import.

Moreover if you are using 10g then you can use RMAN to convert the dbf files from one certified platform to another and you can use transportable tablespace feature to port data from one platform to another.

For info refer Oracle Doc.

Daljit Singh Cool

Report message to a moderator

Re: Server to Server [message #119176 is a reply to message #118919] Wed, 11 May 2005 00:57 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi all,

I want to know, is it possible to migrate database from UNIX to NT using simply copy files(not export/Import).

I know one instance, We were using 8i on IRIX box. We were supposed to migrate from IRIX to NT. The very next day the Database on IRIX Creashed and we could not start the DB on IRIX by any chance. So Our DBA copied the Datafiles, LOG Files from IRIX to NT and recovered the database using option ...UNTIL CANCEL.

So, I want to know from whether UNIX to NT migration of dtabase is possible using datafile copy(Clone)?

Thanks
Brayan.

Report message to a moderator

Previous Topic: Pb From Dedicated to Shared in Oracle9i R2
Next Topic: Partitioning in oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 04:14:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.