OraFAQ Forum: Server Administration » Oracle Database Move to a new Server

Home » RDBMS Server » Server Administration » Oracle Database Move to a new Server (Oracle10g, (10.2.0.1.0) , Windows2003 Server)

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

Oracle Database Move to a new Server [message #324678]

Tue, 03 June 2008 12:22

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

Report message to a moderator

Re: Oracle Database Move to a new Server [message #324681 is a reply to message #324678]

Tue, 03 June 2008 12:29

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.

Report message to a moderator

Re: Oracle Database Move to a new Server [message #324683 is a reply to message #324678]

Tue, 03 June 2008 12:36

JackyShu
Messages: 25
Registered: May 2008

Junior Member

or use DBCA to create a database template.

Report message to a moderator

Re: Oracle Database Move to a new Server [message #324687 is a reply to message #324681]

Tue, 03 June 2008 12:55

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

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

Report message to a moderator

Previous Topic:	Create database with ASM
Next Topic:	Database or data Move

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 00:43:42 CST 2024