Home » RDBMS Server » Server Administration » move DB from one server to another server [merged]
move DB from one server to another server [merged] [message #343703] Wed, 27 August 2008 19:08 Go to next message
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?

Re: move DB from one server to another server [message #343707 is a reply to message #343703] Wed, 27 August 2008 20:13 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: move DB from one server to another server [message #343755 is a reply to message #343703] Thu, 28 August 2008 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Upgrade Guide

Regards
Michel
Re: move DB from one server to another server [message #343841 is a reply to message #343703] Thu, 28 August 2008 05:59 Go to previous messageGo to next message
dirish
Messages: 205
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.
Re: move DB from one server to another server [message #343901 is a reply to message #343755] Thu, 28 August 2008 07:28 Go to previous messageGo to next message
racman
Messages: 8
Registered: February 2008
Junior Member
Thanks everyone!

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

Thanks in advance.
moving from one server to another server [message #343906 is a reply to message #343703] Thu, 28 August 2008 07:39 Go to previous messageGo to next message
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.

Re: moving from one server to another server [message #343911 is a reply to message #343906] Thu, 28 August 2008 07:44 Go to previous messageGo to next message
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
Re: move DB from one server to another server [message #344160 is a reply to message #343901] Thu, 28 August 2008 23:48 Go to previous messageGo to next message
dirish
Messages: 205
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

Re: move DB from one server to another server [merged] [message #344241 is a reply to message #343703] Fri, 29 August 2008 03:16 Go to previous messageGo to next message
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
Re: move DB from one server to another server [merged] [message #344479 is a reply to message #344241] Sat, 30 August 2008 00:15 Go to previous messageGo to next message
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?
Re: move DB from one server to another server [merged] [message #344679 is a reply to message #344479] Sun, 31 August 2008 23:58 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Taj is correct,
Re: move DB from one server to another server [merged] [message #344683 is a reply to message #344679] Mon, 01 September 2008 00:35 Go to previous message
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.
Previous Topic: what will happen when archive log destination filled?
Next Topic: Privilege information
Goto Forum:
  


Current Time: Fri Dec 02 21:09:11 CST 2016

Total time taken to generate the page: 0.12929 seconds