Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Database backup procedures documentation

Posted on 2013-02-06
6
522 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
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.

808 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