i'm new to this DBA field, so i may sound childish when i ask this question. What is the daily work of a DBA? What is the daily routine work of an Oracle DBA? i hope many DBA gurus would share their experience. Thanks in advance
I think if you're doing the same thing every day, there's a big problem. Who wants to spend their life checking log files and running the same old scripts on the database? If you end up doing something more than three times, automate it. I think the last time I looked at an alert.log was three years ago. I automated the process so when something of interest pops up, I get an alert. I have a script that watches free space in the database and knows when and where to add a datafile should the need arise.
Your worth as a DBA increases when you can solve problems, not check items off a list.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.