ALL POSTS

How to Collect Cluster Information Using TSQL

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

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 work was from 9 to 5. Since we were basically only 2 people , our action plan used to…

Online Retailers Have 3 Seconds to Make Mom Happy

Mother’s Day is coming up fast. May 12th 2013 is just around the corner, and if you have not already done so, make sure you go out and get mom a special gift as soon as possible. If you need a hand picking something great, take a look at this Mother’s Day gift guide by…

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 news and views from the world of Oracle, SQL Server, and MySQL.

My First 6 Months Working at 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, and 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 fulfilled 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 kept in the FRA and the other in an external disk, which from time to time gets deleted from this…

Page 40 of 258« First...102030...3839404142...506070...Last »