Re: My RMAN script of full backup
Date: Sun, 29 Apr 2012 21:07:56 +0000 (UTC)
Message-ID: <pan.2012.04.29.21.07.56_at_gmail.com>
On Sun, 29 Apr 2012 23:45:38 +1000, Noons wrote:
> Well, you know how it goes: gotta replace all those "expensive dbas" who
> dare show professionalism and think about such eventualities!
Replacing an expensive DBA with a less expensive one is not a sacrilege, it's a rational business decision. Fortunately for both of us, large databases that support thousands of concurrent connections are exceptionally complex beasts which do require a DBA with a great deal of knowledge. It's easy to manage a database when everything works as expected, but databases are very complex beasts and if everything looks right, you've overlooked something. When the main production database loses an instance in the middle of the night, say at 3:15 AM, you want to be really sure that the DBA on the other end of the phone line knows what to do and how to restore the service in the minimum time. That's not the time or place to start clicking on the OEM, which takes forever to load. My Xubuntu 12.04 virtual machine boots faster than I can connect to OEM 12c.
The legend of the database that doesn't need a DBA is just a legend. Status of technology is such that every serious production database needs one and it will stay so for some time. However, there will be a change in the future. RAM sizes are getting much bigger, SSD are getting much more common, and MVC frameworks like Hibernate, Zend or Django are becoming prevalent. Database algorithms will change, automatic tuning will slowly become prevalent, both in the database arena and in the OS arena. At that point, SQL tuning, which now comprises a large part of my job, will be done by a computer. When Skynet becomes self aware, the DBA 1.0 personnel will become obsolete and will be tehminated.
-- http://mgogala.byethost5.comReceived on Sun Apr 29 2012 - 16:07:56 CDT