| Moving whole database to a new site [message #406997] |
Mon, 08 June 2009 02:27  |
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  |
ThomasG
Messages: 3211
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 #407022 is a reply to message #406997] |
Mon, 08 June 2009 03:32 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
