OraFAQ Forum: Server Administration » move DB from one server to another server [merged]

Home » RDBMS Server » Server Administration » move DB from one server to another server [merged]

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

move DB from one server to another server [merged] [message #343703]

Wed, 27 August 2008 19:08

racman
Messages: 8
Registered: February 2008

Junior Member

Hi!

I need to move a 8.1 Database from one server to another server within the same domain while upgrading to 10g.

Can any one verify, whether, what I am planning is correct?

Target Database:

Install software and create Database.
Use Datapump and import from source DB.

or

Upgrade the source DB to 10g and take the template of the same.
Just clone the Database of source to get the target.

which one should I do?

Report message to a moderator

Re: move DB from one server to another server [message #343707 is a reply to message #343703]

Wed, 27 August 2008 20:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You should NOT touch the 8i DB.
If it is left alone, you'll always have a fallback capability.

You can not use datapump, because it did not exist in 8i.

Report message to a moderator

Re: move DB from one server to another server [message #343755 is a reply to message #343703]

Thu, 28 August 2008 01:15

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Upgrade Guide

Regards
Michel

Report message to a moderator

Re: move DB from one server to another server [message #343841 is a reply to message #343703]

Thu, 28 August 2008 05:59

dirish
Messages: 232
Registered: November 2006

Senior Member

Hello,

NEVER touch your working DB.

What you have to do is look for the tablespaces and their size in the old server (dba_data_files).

Recreate the same tablespaces with greater sizes (or same, depending on free space) on the new server.

Do a full import.

Thats all.

Report message to a moderator

Re: move DB from one server to another server [message #343901 is a reply to message #343755]

Thu, 28 August 2008 07:28

racman
Messages: 8
Registered: February 2008

Junior Member

Thanks everyone!

Should I upgrade first and move to another server or viceversa.

Thanks in advance.

Report message to a moderator

moving from one server to another server [message #343906 is a reply to message #343703]

Thu, 28 August 2008 07:39

racman
Messages: 8
Registered: February 2008

Junior Member

I will have to move two databases from one windows server to another windows server within the same domain.

Are there any documentation with step by step procedure?

Appreciate all your help.

Report message to a moderator

Re: moving from one server to another server [message #343911 is a reply to message #343906]

Thu, 28 August 2008 07:44

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

There are lots of way to do it.
There are lots of site and reference if you search on net.

http://dbataj.blogspot.com/2007/03/shiftoracleserverfromonemachinetoanothe.html

Report message to a moderator

Re: move DB from one server to another server [message #344160 is a reply to message #343901]

Thu, 28 August 2008 23:48

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi man,

A working oracle environment is SACRED and must not be touched. So no need for any upgrade.

If your original DB was on 7 then you should have migrated it to oracle8 first then oracle10g. (please correct me if am mistaken)

Thank you,
Dirish

Report message to a moderator

Re: move DB from one server to another server [merged] [message #344241 is a reply to message #343703]

Fri, 29 August 2008 03:16

kkirakast
Messages: 2
Registered: August 2008
Location: austrilia

Junior Member

Hi
IF you have backup of the 8i databse then restore it on oracle 10g database and then start it up.
Regards
Kirakast

Report message to a moderator

Re: move DB from one server to another server [merged] [message #344479 is a reply to message #344241]

Sat, 30 August 2008 00:15

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

...IF you have backup of the 8i databse then restore it on oracle 10g database and then start it up....
And you think it is working?

Report message to a moderator

Re: move DB from one server to another server [merged] [message #344679 is a reply to message #344479]

Sun, 31 August 2008 23:58

dirish
Messages: 232
Registered: November 2006

Senior Member

Taj is correct,

Report message to a moderator

Re: move DB from one server to another server [merged] [message #344683 is a reply to message #344679]

Mon, 01 September 2008 00:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

No it is not working.

Oracle 8i database backup you can't restore and recover in oracle 10g database.

Report message to a moderator

Previous Topic:	what will happen when archive log destination filled?
Next Topic:	Privilege information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:54:14 CST 2024