OraFAQ Forum: Backup & Recovery » Recovery of database with backup of Oracle folder

Home » RDBMS Server » Backup & Recovery » Recovery of database with backup of Oracle folder (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recovery of database with backup of Oracle folder [message #462406]

Thu, 24 June 2010 02:40

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

Report message to a moderator

Re: Recovery of database with backup of Oracle folder [message #462413 is a reply to message #462406]

Thu, 24 June 2010 03:18

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Recovery of database with backup of Oracle folder [message #462416 is a reply to message #462413]

Thu, 24 June 2010 03:23

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

Report message to a moderator

Re: Recovery of database with backup of Oracle folder [message #462420 is a reply to message #462416]

Thu, 24 June 2010 03:39

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:21:30 CST 2024