Two days ago we "found out" that our old, not taken care of, horribly neglected, Oracle DB server was extremely important to our business.
The only person who knew anything about this server was fired 2 years ago, so it's been running since without maintenance.
Being both relatively new in the office as well as in charge of the whole server infrastructure, I need to get to know this server, with zero Oracle experience.
My questions to you are:
- Backups: I've read up a lot about RMAN, Import/Export etc. but I'm having a hard time finding a good overview. What would I need to backup and how do I restore said data if the machine blows up?
- Maintenance: is there something about maintenance that I specifically need to know?
- Labbing: is it possible for me to download a copy of this and learn on my local linux machine?
If you think these tasks, for me without any experience, are to daunting, you're free to say so because we've been looking at hiring a consultant for this specific situation. Obviously I'd rather like to learn and solve it myself.
Any pointers to documentation, manuals etc. are very much appreciated!
[I'm not too sure if this is a DBA or ServerFault question actually, I believe it's a very thin line between the two but if you feel this thread is misplaced, feel free to move it.]
Best Answer
first think about what it costs if the database gets lost. For this there are several levels.
For all scenarios there are solutions. Normally I work for sites that won't allow the loss of any data. Most of the times they also want protection against unplanned downtime. This is the ultimate protection. As most things, it also has a price. Most protection has the highest cost. But if you need this, there will be a business case for it. That is why you should start with the question what dataloss costs your company. This will give you a budget.
For documentation start with DBA Essentials A very nice third party solution for DR can be found here dbvisit standby
Hiring support from a good dba can make a huge difference for your company. A good dba has your business in mind when he/she proposes solutions. Your question a asking a bit much. You need dba support. For an overview pick the Oracle concepts guide. Read it and use it to help you hire a good dba.