Is it possible to recover the oracle databases with just the main oracle folder and all the data in it in hand?
The laptop on which oracle server was installed, crashed. so now we have in hand the base oracle installation folder with the data. Is it possible to get the databases working?
No, there were no backups taken whatsoever.
I am a sql server guy so have no idea how oracle works. Any input would be helpfull.
Thanks a bunch.
As long as you are waiting for a true Oracle DBA to appear, and if you have some time to spare, you might try this:
- save Oracle database files to a safe place (another folder, DVD or similar); they should be in a folder like "C:\oracle\product\10.2.0\oradata\ora10g". Those are data files, redo log and control files.
Also, you might want to save INIT.ORA file (in order to substitute newly created one if necessary).
- create another Oracle database at the same place where the previous one existed (into the same folder).
- overwrite newly created database files with the saved ones
- restart the database
Now, this *might* work ... if it won't, come back and explain what happened. I guess we'll somehow find the solution.