Home » RDBMS Server » Server Utilities » Moving whole database to a new site (oracle 9)
Moving whole database to a new site [message #406997] Mon, 08 June 2009 02:27 Go to next message
summoner
Messages: 44
Registered: March 2009
Member
Dear all,

We are targeted to move our old DB to new system. There are not enough space on the old server and therefore we hope we can prevent from exporting db files

Are there any ways that can directly import the database to a new instance?

Thanks
Re: Moving whole database to a new site [message #407000 is a reply to message #406997] Mon, 08 June 2009 02:37 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
One solution that would work on UNIX would be to export to a pipe (FIFO), and run the import from that pipe simultaneously.

Another solution would be to mount a drive from the new server over the network, and export to that drive.
Re: Moving whole database to a new site [message #407007 is a reply to message #406997] Mon, 08 June 2009 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just copy the files into your new system.
You have not to export/import (assuming they have the same OS).

Regards
Michel
Re: Moving whole database to a new site [message #407022 is a reply to message #406997] Mon, 08 June 2009 03:32 Go to previous messageGo to next message
fairdaus
Messages: 14
Registered: May 2009
Location: KL
Junior Member
if your db not very big have connection between new server and old server you can direct export dmp file using network

example
old server=yyprodsvr
new server=xxprodsvr
old db name=test
new db name=new

1. test server connection using ping command
exp: ping <server_name> or ip address

/tmp [] > ping xxprodsvr
xxprodsvr is alive

2. add old tnsname at new server tnsnames.ora file

3. test connecting using tsnping instance name
exp:
/tmp [] > tnsping test

TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 08-JUN-2009 16:22:37

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
/z01/oracle/product/10.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxprodsvr)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test)))
OK (10 msec)


4. run exp in new server

exp system/abc123@test file=xxxx.dmp log=xxx.log full=yes

tq

[Updated on: Mon, 08 June 2009 04:04]

Report message to a moderator

Re: Moving whole database to a new site [message #407608 is a reply to message #407022] Wed, 10 June 2009 12:05 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
Just copy the files into your new system.
You have not to export/import (assuming they have the same OS).

Regards
Michel


Thanks
Previous Topic: sqlldr parallel jobs
Next Topic: SQL LOADER
Goto Forum:
  


Current Time: Mon Dec 05 14:49:59 CST 2016

Total time taken to generate the page: 0.08468 seconds