An operation support Oracle DBA
Oracle Database Administrator (Current Employee) – Washington, DC – January 18, 2017
My typical day at work varies on a daily bases, normally ranging from working on small projects, resolving database related problems like critical alert and failures to ensure database availability and performance.
To talk more on how my typical day at work looks like, each and every blessed day I clock in at work by 7:45am, the first thing I do is to
- Make sure that the listener is up as well as the instance.
- Check on my email if there are any tickets assigned to my group or to me respond to the by working on the related issue right, resolving the problem and closing the ticket.
The number of incident tickets assigned to me on a daily also influenced my daily activities; again as I said, everything varies on a daily base. Some days I have incident tickets assigned to me with database related issues like;
- Instance is down
- Listener is down (listener log file)
- Tablespace full warning
- Archiving log issues, possible causes include standby database issues, it could be full, could be data guard-transportation issues, could be flash recovery area may be full
- Flash recovery area issues(full or running out of space)
- Failed jobs (in case of some failed jobs, will have to restart it) like Backup failure (possible cause; script did not run wrong password or permission issues, agent is down, no or limited space.
- Data corruption like Ora 1555 snapshot too old possible cause; read consistency, undo retention too small ( have to extend the undo retention period using the Undo_retention Parameter by adding the retention period and guaranteeing it)