We have a Windows 2008 32-Bit Server which has a utility software application connecting to a Oracle 11.2 database. The user reported several issues related the application hanging/crashing with some windows/application related error messages. upon contact the vendor, they suggested to rebuild the server, since they "guess" that certain windows updates might not be compatible or might be causing the issue, hence the IT folks told me that they coppied a backup image from last month. Once they did that the user is getting ORA-00600, ORA-01215, ORA-12516 errors. bottom line, the backup image has not been copied properly. Upon asking , the It folks mentioned that they only restored the folders they thought are required. Oracle home is on F: drive , so they just copied folders related to Oracle (all on F: drive) and the application.
My question is what are the best practices when restoring an windows back up image for a Oracle database server? i am under the impression that restoring just the folders wont do it. even restoring the entire drive (F:) may have issues , correct? I am ready to cleanup and install Oracle and build the database with backup export file we have, but would like to know what is a best way to recover a Oracle database Server on a Windows Server from a backup image.
Appreciate any input on this.