Home » Other » General » Problem Backing Up Oracle (Oracle,10g, Win XP)
Problem Backing Up Oracle [message #443656] Tue, 16 February 2010 18:06 Go to next message
noob101
Messages: 2
Registered: February 2010
Junior Member
Hi there, I am new to this forum as well as Oracle.

I was currently running oracle 10g XE with APEX on a xp virtual pc machine. Unfortunately the virtual pc crashed and keeps cycling upon boot. I have tried troubleshooting but all attempts were futile.

However I am able to browse the directory of the virtual hdd via the winimage application. I have created a new xp virtual machine and want to know what file or folders do i have to copy to be able to get back my full database and application. Unfortunately i did not make recent backups.

Please any advice on moving foward would be greatly appreciated.
Re: Problem Backing Up Oracle [message #443724 is a reply to message #443656] Wed, 17 February 2010 02:04 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Install XE again (same version) in the same directory as you did before.
Shut down the database.
Then copy the following directories:
app\oracle\admin\XE
app\oracle\flash_recovery_area
oradata

This should do it. (I do it all the time locally)
Re: Problem Backing Up Oracle [message #444105 is a reply to message #443724] Thu, 18 February 2010 12:56 Go to previous messageGo to next message
noob101
Messages: 2
Registered: February 2010
Junior Member
Many Thanks! I tried it and was able to restore my app and database.
Re: Problem Backing Up Oracle [message #444176 is a reply to message #444105] Fri, 19 February 2010 02:05 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Cool, thanks for the feedback!
Previous Topic: Suggest Platform?
Next Topic: Oracle Licensing - Standard / Standard One, per processor not per core?
Goto Forum:
  


Current Time: Thu Mar 28 23:34:17 CDT 2024