Home » RDBMS Server » Server Utilities » oracle database to another oracle test server (oracle 9i & wnsrv2003)
oracle database to another oracle test server [message #347244] Thu, 11 September 2008 03:04 Go to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
Hi
I have to install a test server for the testing
i have i win2003 server installed oracle 9i and a oracle database
now i installed a new server and oracle
but i dont know how to transfer datase
can you help me
can i do it with "imp" and "exp" command
if i can , write me these commands
wait for your answers
Re: oracle database to another oracle test server [message #347248 is a reply to message #347244] Thu, 11 September 2008 03:23 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
9i Export and Import documentation.

Although I'm not a DBA, I *think* that - if these two servers' databases are exactly the same - you could even do that by copying data, redo log and control files from one server to another. Please, don't trust me - you'd rather wait for someone who knows how to do that (besides export and import, which will do the job).
Re: oracle database to another oracle test server [message #347256 is a reply to message #347244] Thu, 11 September 2008 03:38 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

On Source Database
1. Take Cold backup of database
On Target Database
2. Restore that COLD backup and open your database.

If you can shutdown then you can use HOT backup method.

In hot backup you can use User Managed Method or RMAN.
You have one more option is "RMAN DUPLICATE".

If database is small then just use EXPORT/IMPORT.

Search on this forums for details of above options.

Re: oracle database to another oracle test server [message #347283 is a reply to message #347256] Thu, 11 September 2008 04:28 Go to previous messageGo to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
i cant search about your topic
i take a bckup with
imp system/manager file=..... full=y
when importing , i cant successfully restored
Re: oracle database to another oracle test server [message #347327 is a reply to message #347283] Thu, 11 September 2008 05:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can you show us what error message your getting during import operation.

Re: oracle database to another oracle test server [message #347342 is a reply to message #347327] Thu, 11 September 2008 05:54 Go to previous messageGo to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
ok
  • Attachment: log.log
    (Size: 10.20KB, Downloaded 335 times)
Re: oracle database to another oracle test server [message #347355 is a reply to message #347342] Thu, 11 September 2008 06:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-01119: error in creating database file 'D:\ORADB\IFS2004\IFSAPP_DATA.DBF'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

D Drive is exist in your file system? Fix the O/S problem then import will work.
Re: oracle database to another oracle test server [message #347363 is a reply to message #347355] Thu, 11 September 2008 06:34 Go to previous messageGo to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
sorry
disk quota was full
i cleaned now
and started import
when finished
will post its log file
thank you
Re: oracle database to another oracle test server [message #347371 is a reply to message #347363] Thu, 11 September 2008 07:11 Go to previous messageGo to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
When importing
somethings wrong
original tablespaces don't creating in new db
users01.dbf is continiously larging not other tablespaces
  • Attachment: log.log
    (Size: 338.59KB, Downloaded 171 times)

[Updated on: Thu, 11 September 2008 07:38]

Report message to a moderator

Re: oracle database to another oracle test server [message #347380 is a reply to message #347363] Thu, 11 September 2008 07:39 Go to previous messageGo to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
picture
  • Attachment: untitled.JPG
    (Size: 285.64KB, Downloaded 126 times)
Re: oracle database to another oracle test server [message #347600 is a reply to message #347380] Fri, 12 September 2008 05:27 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

import once again with STATISTICS=NONE parameter.
Previous Topic: database exp/imp...!!
Next Topic: import/export options
Goto Forum:
  


Current Time: Sun Dec 04 18:47:17 CST 2016

Total time taken to generate the page: 0.06052 seconds