Transcript Disaster Recovery - Spatial Database Group

Disaster Recovery
Strategies and Options
Half of Small Companies Lack Disaster Recovery
Plan, Says Survey
http://readwrite.com/2011/01/12/half-of-smallcompanies-lack-disaster-recovery-plan
Not Being Prepared Means Potential
Loss
• Outrages causes financial loss: $25,000 per
•
•
day
Longer or frequent outages can cause
customer mistrust
For many small businesses, loss of data can
kill the company
Loss of
Customers
Loss of
Customer
leave
Data
Trust
Problem Proposed
• Symantec recently released the results of
its "2011 SMB Disaster Preparedness Survey"
• 50% of SMBs have no disaster recovery plan
o
Others implemented plan due to a loss of data or
outage
• 65% of them are vulnerable to natural
disasters.
Types of Failure
• Simple Failure (discussed in Chapter 22)
o
Does not affect disk
o
Changes in memory may be lost
• RAID/Disk Failure
o
Corrupted data due to partial writes
• Geographic Failure
o
Flood, Fire, Earthquake, etc.
Recovery Strategies
• Types of Backups
o
Full Database Backup (ex. Weekly)
o
Differential Backups (ex. Daily)
o
Transaction Logs (ex. Hourly)
Recovery Strategies (cont.)
• Storage of Backup
o
Same Disk
o
Separate Disk, Same System
o
Separate System, Different Location
o
On Tape, Remote Facility (e.g. Nuclear Shelter)
High Availability
• RAID
• Relication
o
Between two systems, or an entire cluster
• Redundant O.S.
o
Same transaction runs on both OSs
o
Automatic Failure Recovery
Recap
• Review what is an acceptable loss
• Find solutions that fit your budget
• Test your recovery solutions often
References
- Oracle Backup and Recovery Strategies:
http://docs.oracle.com/cd/B10500_01/server.920/a96519/strategy.htm
- DB2 Backup and Recovery Strategies:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.
udb.admin.doc%2Fdoc%2Fc0005945.htm
- SQL Server Disaster Recovery
http://databases.about.com/od/sqlserver/a/disaster_2.htm
- Disaster Recovery and Continuity Planning for the Database Administrator
http://www.datamation.com/netsys/article.php/11075_3765821_2/Disaster-Recoveryand-Continuity-Planning-for-the-Database-Administrator---Part-1.htm &
http://www.datamation.com/netsys/article.php/3767366/Disaster-Recovery-andContinuity-Planning-for-the-Database-Administrator---Part-2.htm
- Database Disaster Recovery: Planning for the Unpredictable
http://www.mwrutherford.com/portfolio/disasterrecovery/Disaster_Research.pdf
- Half of Small Companies Lack Disaster Recovery Plan, Says Survey
http://readwrite.com/2011/01/12/half-of-small-companies-lack-disaster-recovery-plan