Home » RDBMS Server » Backup & Recovery » Recovery of database with backup of Oracle folder (Oracle 10g)
Recovery of database with backup of Oracle folder [message #462406] Thu, 24 June 2010 02:40 Go to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
My oracle database has currupted. I have the backup of the whole Oracle folder as I had taken the backup of the computer a week before.

So if I install a fresh Oracle database, how can I restore the old database files. Please help me on this with some steps.

Regards,
Mahi
Re: Recovery of database with backup of Oracle folder [message #462413 is a reply to message #462406] Thu, 24 June 2010 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you backed up the folder when database was down, the answer is yes (assuming the folder contains all database files).

Regards
Michel
Re: Recovery of database with backup of Oracle folder [message #462416 is a reply to message #462413] Thu, 24 June 2010 03:23 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi Michel,
The database was not down when I took the backup.

Please let me know if I can recover the database.

Regards,
Mahi
Re: Recovery of database with backup of Oracle folder [message #462420 is a reply to message #462416] Thu, 24 June 2010 03:39 Go to previous message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only if you are lucky...
Stop the database (if it is shut down yet).
Save the folder.
Restore the previous folder.
Restart the database.
Post the errors if any and last part of alert.log.

Regards
Michel
Previous Topic: ORA-06553: PLS-553: character set name is not recognized
Next Topic: RMAN-01005 : SYNTAX ERROR
Goto Forum:
  


Current Time: Wed Jul 30 23:34:38 CDT 2014

Total time taken to generate the page: 0.08563 seconds