Solved

Database backup procedures documentation

Posted on 2013-02-06
6
498 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
grouping on time windows 6 41
google drive and backup policy 2 38
PL/SQL Display based on value 4 17
Undelete of overwritten files 20 31
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

919 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