troubleshooting Question

restoring a Oracle database server from a back-up image.

Avatar of crishna1
crishna1Flag for United States of America asked on
Oracle DatabaseStorage SoftwareWindows Server 2008
1 Comment1 Solution620 ViewsLast Modified:
Experts,

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.
-regards
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros