OraFAQ Forum: Server Utilities » Moving DB client to our server

Home » RDBMS Server » Server Utilities » Moving DB client to our server - Need Advice

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

Moving DB client to our server - Need Advice [message #126055]

Thu, 30 June 2005 12:55

vqd2697
Messages: 36
Registered: October 2004

Member

We currently have a couple schemas (about 1.5 TB of data) reside in client box. We need to move all schemas & data back to our server using T1 line connect from our box to client box. What is the best ways to do this?

1. Export/Import
2. Extracting Data
3 ????

Thanks in advance,

Vu

Report message to a moderator

Re: Moving DB client to our server - Need Advice [message #126058 is a reply to message #126055]

Thu, 30 June 2005 13:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>1. Export/Import

If you can afford the time

it would take to export 1.5 worth database( how much of it is actuall data?)
To import back
To recreate the indexes
to analyze again

you can go for it.

Export / import is a very serial process.
If the OS is same between both the ends,
cold-copy-clone would be an easy method.

If OS is different, export / import is the only way.

Report message to a moderator

Re: Moving DB client to our server - Need Advice [message #126065 is a reply to message #126055]

Thu, 30 June 2005 14:26

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

I'm not sure whether you are just trying to move the db from one server to another, or if you are trying to move the data out of a db on the client and into another db on the server.

If the former, then I like the suggestion of Mahesh to just shut it down, copy it, and start it back up. If the later, then transportable tablespaces might be an option.

An import of 1.5 TB....long long time.

Report message to a moderator

Re: Moving DB client to our server - Need Advice [message #126079 is a reply to message #126065]

Thu, 30 June 2005 17:45

vqd2697
Messages: 36
Registered: October 2004

Member

Many thanks, I guest the only option is exp/imp since it's different OS and static database....

Report message to a moderator

Previous Topic:	how to monitor an export
Next Topic:	Import Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:36:31 CST 2024