Oracle

June 9, 2011

DBA Mistakes

Filed under: Uncategorized — srivenu @ 10:14 am

Happened to read these 2 good articles on the net.

Handling Human Errors – Alex Gorbachev
The Seven Deadly Habits of a DBA…and how to cure them – Paul Vallée

(I thought “mistake” would be a more appropriate word compared to “error”)

Paul Vallée’s post is excellent. I could relate to everything he wrote. It could serve as a good reference point for DBA managers.

I would add “Comprehensive Automation and Scripting” to Alex Gorbachev’s list. (but have to consider disadvantages like long ramp up time for new comers)

I wonder if there are or had been any professional DBA managers who applied “Human Relations” or “Behavioral” techniques in the field and written about it. That would be quite an interesting study indeed.

Advertisements

High Availability

Filed under: Uncategorized — srivenu @ 9:35 am

Happened to read this good article on the net. As Jeremiah Wilton pointed at the start of that article, a careful analysis of database/system failures in our environments, would reveal a surprisingly consequential number of cases where these various HA technologies wouldnt have helped us much.

As DBA’s most of us would be aware of these limitations. But many a times, these HA implementation decisions are sold by us (DBA’s) to the managers, who might be ignorant of their limitations, but who are the final decision makers. Its our responsibility to clearly expound the virtues and limitations of the various HA technologies to the managers. But in reality things rarely happen that way. Many of us tend to strongly espouse the case of different HA technologies without equally highlighting/detailing these limitations. Whatever the motive we whould be guided by professional ethics in all such cases.

Create a free website or blog at WordPress.com.