Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have Oracle 10g Express. How can I make a copy of my database and application?

I don't want to make a back up, I want to move my DB and application to another PC.

share|improve this question

migrated from stackoverflow.com Mar 31 '13 at 6:26

This question came from our site for professional and enthusiast programmers.

    
the process will involve a 'backup' unless you have totally created your instance with a script. (doubtful) –  Randy Mar 30 '13 at 13:04

4 Answers 4

First Install XE to another PC.

Then clone your database: Backing Up and Restoring the Database

Then transfer clone to another PC and restore the clone there.

This post may help you also: How to clone Oracle Express 10g Edition?

share|improve this answer
3  
That link describes a backup (and restore) using RMAN which is probably not what the OP wants (or even understands). Using DataPump is much more approriate to copy the contents of database to a different server. –  a_horse_with_no_name Mar 30 '13 at 13:52

I haven't tried this but in theory you should be able to:

  1. Install the exact same version of the software on the other PC using the same installation options (same directory structure, etc).
  2. Shutdown the instance on the original PC.
  3. Copy all the files from the original PC to the same location on the other PC.
  4. Start the instance on the other PC.

This should work for the database instance, but you may have trouble with the bundled web apps and network settings. In this case, if it's an option, you could rename your other PC to have the same name as your original PC...

share|improve this answer

You need to take a dump of the source database using DataPump export.

Then on the target PC install Oracle XE, and use DataPump import to import the dump taken from your source PC.

For details on the DataPump utility, please see the manual: http://docs.oracle.com/cd/E11882_01/server.112/e22490/part_dp.htm

There are also various tutorials for this utility on the web, just search for "Oracle DataPump".

Using RMAN (the "backup and recovery" tool recommended by others) is not a suitable tool for this kind of requirement. Doing a file level copy as suggested as well, will most probably not work either.

share|improve this answer
1  
RMAN may not be easy to use for a beginner (particularly on XE), but it certainly is "a suitable tool for this kind of requirement" –  Jack Douglas Apr 2 '13 at 10:10

so what did guys is this: I took the back up from original DB deleted the ONLINELOG file from this bak up replaced the entire content of this back up with those on XE file on original source runned the restore manager and it went perfectly but could this make me any future errors since I messed with oracle files?

share|improve this answer
    
Please can you sign in on dba.se the same way you sign on to SO and get your accounts here merged, then you can edit the question or comment here. –  Jack Douglas Apr 2 '13 at 10:11
    
For additional assistance on that process, you can visit this page: dba.stackexchange.com/help/user-merge –  jcolebrand Apr 2 '13 at 17:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.