OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » restore database (oracle Db 11)

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

restore database [message #603982]

Sat, 21 December 2013 22:34

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

Hi
I have a copy Of folder ORADATA . How I can Restore This folder to a new DataBase ?

Report message to a moderator

Re: restore database [message #603983 is a reply to message #603982]

Sat, 21 December 2013 22:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

alijeyan wrote on Sat, 21 December 2013 20:34

Hi
I have a copy Of folder ORADATA . How I can Restore This folder to a new DataBase ?

It depends upon when the copy was made, how the copy was made & the completeness of content of this directory.
It suspect that what you now have is not sufficient to ever open any database.

post a full directory listing of the directory's content.

Report message to a moderator

Re: restore database [message #603984 is a reply to message #603983]

Sat, 21 December 2013 22:50

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

I Have a DataBase and My Hard drive crashed , I have a complete copy of Folder oradat with *.CTL files and *.LOG files and *.DBF and *.ORA .
I install a new windows and a new oracle dataBase and I want use that copy .....
thanks for help ......
Sorry for my English is poor !!!!

Report message to a moderator

Re: restore database [message #603985 is a reply to message #603984]

Sat, 21 December 2013 22:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If the database had been cleanly SHUTDOWN prior making the copy of the files, then you only need to STARTUP the database.

Report message to a moderator

Re: restore database [message #603988 is a reply to message #603982]

Sun, 22 December 2013 01:15

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

Senior Member
Account Moderator

You do not restore a database into another one, you just restore the database.
If you have all the database files, in the same places, you juts have to recreate the associated service using ORADIM (assuming from the names you gave you are on Windows).

Report message to a moderator

Previous Topic:	tablespace problem while import
Next Topic:	Block Corruption Simulation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 15 00:59:32 CDT 2026