FEATURED

ALL POSTS

How to collect cluster Information using TSQL

Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating inventory of servers. Logging into each server and collecting information is bit tedious when you have hundreds of server in your environment.  I have spent sometime and created a script that does this work…

The Importance of an Action Plan

When I started my work in IT, I used to be in a very small shop, and even though we had people in several places in the same state, everything used to be very centralized and from 9 to 5, and because we were basically only 2 people , our action plan used to be…

Log Buffer #318, A Carnival of the Vanities for DBAs

News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.

My first 6 months @ Pythian

“What have I gotten myself into” ran through my head during the first week of training at Pythian. The environment was great, the people were great, the work was great, but many doubts ran through my head as I ran from training meeting to training meeting – how am I going to retain all this…

Opening the Door without the Keys

This week my DBA team satisfied a request to restore 1 month old lost data.  A review of the RMAN backups showed that we indeed had a valid level 0 from the requested day which was 33 days ago.  However, upon recovery, the necessary archive logs to bring the database to a consistent point, were…

The undocumented status “M” of an RMAN backup

It is not uncommon for Oracle to have something undocumented , and this is just another case of this ailment. We have a database in which we have two copies of the same backup, one we keep in the FRA, the other one in an external disk, which from time to time gets deleted from…

Page 1 of 21812345...102030...Last »