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.]