ThatJeffSmith

What Databases Should You Back Up?

Insert bad British Joke Here.


Some of my earliest memories involve trips to the dentist when I was maybe 3 or 4 years old. To this day, my blood pressure rises whenever I go in for a simple cleaning. There’s a particular poster I can’t seem to get out of my head, like a bad 80’s song. The intent was to encourage us kiddies to floss our teeth. I remember thinking “Well, I don’t need ALL my teeth…” Hmmm, this doesn’t do much to dispel the stereotypes of being from West Virginia, but I digress!

I propose that there is a direct corollary here for the database world –

You Only Need to Backup the Databases You Want to Keep

You generally won’t get any arguments from the IT world about this. Where the confusion sets in is around the concept of what a ‘production’ database is. What happens in a lot of shops is that only the production databases have regular backup and maintenance plans.

What Does ‘Production’ Mean?

A system is usually considered ‘production’ if it’s used to support the business. This usually rules out databases used for testing and development. From yourdictionary.com

A computer system used to process an organization’s daily work. It implies a real-time operation and the most mission critical computer system in the enterprise.
Contrast with a system used only for development and testing or for ad hoc inquiries and analysis. See data warehouse.

I’ve bolded the most important terms. However, for some ‘customers’, the data warehouse and development instances might be considered ‘production.’ For example, if the data warehouse instance goes down, and the analysts can’t make forecasts or the supply chain folks can’t run their models, then that’s a production data warehouse. There aren’t any real-time operations going on, but it’s sure as heck mission critical!

Business, Professional, & Personal Pains

A few years ago, Quest paid to send me to sales training. The course was based on the Sandler Method. One of the techniques we were taught was to use the ‘pain funnel’ to determine the ‘level’ of pain being experienced by the prospect. If you could validate the problem affected them personally and professionally, then you would have a good shot of selling them your wares, as they would be properly motivated.

If a database goes down, and my business, my career, or I suffer as a result, I consider that ‘production.’

My Production Instances
I have as many 3 instances of Oracle running on my laptop via VMWare. These images are quite large, and would take me a LONG time to rebuild. They are also quite volatile in nature, based on the demos and labs I run on them. If I were to lose 1 or all 3 of them, my life would not be over, but it would surely suck for 3 or 4 days. I would personally suffer. I would professionally suffer. And my company would suffer as well (yes, I know, my ego IS quite healthy.)

RMAN Recover Database Command

How Sweet Are These Words?

Most people would not consider these databases as ‘production’, but I sure do! That’s why I have them backed up to an external disk. If they become corrupted, I’m only an hour or so way from being up and running again.

Do I backup these instances every day? No…and unfortunately I can’t claim to floss my teeth as often as I should. But I have been able to get away with it. For now.

Don’t Hide from the Dentist or DBA

The dentist doesn’t come around to your house and demand to see your teeth. Neither does the DBA with your databases. If you’ve spun up an instance of Oracle or SQL for a short-term project, and you want to be protected, then you need to consult with your production DBA team. It’s not fair to circumvent them when you build the database and then expect them to bail you out when your system crashes.