Solved

Database backup procedures documentation

Posted on 2013-02-06
6
486 Views
Last Modified: 2013-02-21
Is there any general best practice on what to document around your database backup and restore procedures? To what extent and what information do you record in the documentation, or as a senior DBA, if you wanted to check your junior DBA's were effectively documentating backup/restore procedures for business critical databases, what would you expect them to document to ensure another admin could pick up the DBA for that database, and in the case of a restore would no exactly what to do.
0
Comment
Question by:pma111
  • 3
  • 2
6 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 38859271
As far as documentation, you may be required to document your backup strategy.  For example, types of backups, schedule, retentention, tape rotation, etc...

Many shops have a Standard Operating Procedure (SOP) for tasks that needs to be performed on a routine basis.  Recovery if typically one of them.

These should be routinely tested.  How often is typically written in policy somewhere.

I normally have a non-DBA test the SOPs with some supervision.

Database recovery typically isn't something you want to rely 100% on idiot-proof procedures.  It is pretty much impossible to write procedures that will work in every situation.  A non-DBA trying a recovery from a scripted document can easily cause more problems.  What may be a simple recovery can corrupt the entire database by not knowing what you are doing.

I typically have a line at the top of my procedures that the person reading this should contact Oracle Support first thing.
0
 
LVL 3

Author Comment

by:pma111
ID: 38859443
Can you give some examples of other things that fall into SOP's specific to server and database management/administration....
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38859492
Unfortunately, no.  Every organization is different and has different policies in place that need to be followed.

Some shops require a step-by-step SOP that must be followed to the letter for every procedure performed.

Some are a little more liberal on the level of detail.

Recovery SOPs are pretty difficult because there are so many things that can happen and each one likley has a unique set of steps that need performed.

At a high level it should give the reader the necessary information like how to contact Oracle Support.  How/Where to recover tape backups.  Where to look for errors to help diagnose what might have happened.

Mine has the big bold dislaimer at the top:  If you don't know what you are doing, don't do anything!  Contact Oracle Support!
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 3

Author Comment

by:pma111
ID: 38859600
I appreciate every organisation is different but I was just after a few ideas of what would routine procedures would typically require documented SOP's
0
 
LVL 23

Assisted Solution

by:David
David earned 250 total points
ID: 38859685
Perhaps in addition to the backup operational steps and jobs:

* Document the data audit trail -- once data passes the firewall, where does it go? How long is it required to be stored, and using what media? And my professional favorite, what steps to ensure it is expunged at the regulated time?  For example, the FAA used to require paper records of airplane manufacturing data up to ten years.
* In the event of conflicting legal requirements, what takes precedent?

HTH
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38860474
>>what would routine procedures would typically require documented SOP's

This question was on backups.  Disaster recovery is definitely a procedure that needs proper documentation and regular testing.

You should also have prcedures on upgrads and installs.

I also agree with the data retention and expungement.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now