Backing up and Restoring Oracle XE

At work we use Oracle as our production database and Oracle XE as our development database on our laptops/desktops. I recently received a new laptop and needed to move Oracle XE and all of the data from my old machine to my new machine. After some searching around I found a very simple method.

  1. Install a fresh copy of Oracle XE on the new machine.
  2. On the old machine run the “Backup Database” command which is located in the Windows Start Bar.
  3. Copy the following folders and files from the old machine to the new machine.
    • c:\oraclexe\app\oracle\flash_recovery_area\XE\AUTOBACKUP\*
    • c:\oraclexe\app\oracle\flash_recovery_area\XE\BACKUPSET\*
    • c:\oraclexe\app\oracle\product\10.2.0\server\database\SPFILE2INIT.ORA
  4. On the new machine run the “Restore Database” command which is located in the Windows Start Bar.

That is all there is to it. You should now have all of your schemas and data on your new machine.



Comments

  1. mac ramoran March 13th

    Comment Arrow

    Thank you soo much… it really work for me.. 100%


  2. Brian March 13th

    Comment Arrow

    You are welcome. Glad it helped.


  3. Eason Lu August 20th

    Comment Arrow

    I just want to say THANK YOU! i found so many different solutions but none of them works. This solution is fast and works for 11.2 as well! You rock!


  4. Brian August 21st

    Comment Arrow

    Thanks Eason. Glad it helped you.


  5. chen January 9th

    Comment Arrow

    but XE not perform point-in-time recovering. it just recover all.


  6. jeff B. October 26th

    Comment Arrow

    Superb! Million thanks bro..


Add Yours

  • Author Avatar

    YOU


Comment Arrow




About Author

Brian

Brian Abston is a Java Developer in Oklahoma who also loves technology.