Home » RDBMS Server » Backup & Recovery » restore database (oracle Db 11)
restore database [message #603982] Sat, 21 December 2013 22:34 Go to next message
alijeyan
Messages: 173
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 ?
Re: restore database [message #603983 is a reply to message #603982] Sat, 21 December 2013 22:39 Go to previous messageGo to next message
BlackSwan
Messages: 22810
Registered: January 2009
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.
Re: restore database [message #603984 is a reply to message #603983] Sat, 21 December 2013 22:50 Go to previous messageGo to next message
alijeyan
Messages: 173
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 !!!!
Re: restore database [message #603985 is a reply to message #603984] Sat, 21 December 2013 22:57 Go to previous messageGo to next message
BlackSwan
Messages: 22810
Registered: January 2009
Senior Member
If the database had been cleanly SHUTDOWN prior making the copy of the files, then you only need to STARTUP the database.
Re: restore database [message #603988 is a reply to message #603982] Sun, 22 December 2013 01:15 Go to previous message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
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).


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


Current Time: Tue Sep 23 21:28:14 CDT 2014

Total time taken to generate the page: 0.07855 seconds