Home » RDBMS Server » Server Administration » Oracle Database Move to a new Server (Oracle10g, (10.2.0.1.0) , Windows2003 Server)
Oracle Database Move to a new Server [message #324678] Tue, 03 June 2008 12:22 Go to next message
tkline
Messages: 2
Registered: May 2008
Junior Member
Hi,

I have an Oracle Server installed with Oracle10g.
I want to move the Databases from Server1 to Server2

I thought it would be easy like SQL Server, but Oracle is
quite tricky.

Could you please give me a suggestion on how to move the
databases from Server1 to Server2. Are there any
Guidlines or Tuts how I can manage this?

What are you doing when you have to move oracle databases to a new Server?

Thanks in advance for you efforts

Greetings
Tom
Re: Oracle Database Move to a new Server [message #324681 is a reply to message #324678] Tue, 03 June 2008 12:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The easiest would be to do a shutdown and copy all the datafiles, controlfiles, redo logs, spfile, and the password file to the new server. The directory location would need to be the same on both nodes. Once these are in place you'll need to create a Windows Oracle service with oradim. Once the Windows Oracle service is created, you can start the database.

The above is assuming the same version of O/S and same version of database binaries.
Re: Oracle Database Move to a new Server [message #324683 is a reply to message #324678] Tue, 03 June 2008 12:36 Go to previous messageGo to next message
JackyShu
Messages: 25
Registered: May 2008
Junior Member
or use DBCA to create a database template.
Re: Oracle Database Move to a new Server [message #324687 is a reply to message #324681] Tue, 03 June 2008 12:55 Go to previous messageGo to next message
tkline
Messages: 2
Registered: May 2008
Junior Member
The only difference between Server1 and Server2 are the
Servernames and Server1 is Windows2003Server SP1 and Server2 is Windows2003Server R2. Does this still work?

[Updated on: Tue, 03 June 2008 12:59]

Report message to a moderator

Re: Oracle Database Move to a new Server [message #324718 is a reply to message #324687] Tue, 03 June 2008 15:22 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That should not pose any problems.

The only thing you may need to be concerned about is recreating DB Console with:

emca -config dbcontrol db -repos recreate
Previous Topic: Create database with ASM
Next Topic: Database or data Move
Goto Forum:
  


Current Time: Fri Dec 09 23:14:11 CST 2016

Total time taken to generate the page: 0.09111 seconds