OPS4 The Complete Database Disaster Recovery Plan Brian
OPS-4: The Complete Database Disaster Recovery Plan! Brian Bowman Sr Solution Engineer
What color are you? Source: http: //www. drj. com/articles/fall 06/1904 -03. html 2 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Agenda § Disaster Recovery (DR) Tools § Using the Tools § Building a New Plan § An Example Plan § Wrap-up & Questions 3 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
DR Tools: The Basics § Not just recovery but… • Ensuring consistency • Ensuring availability • Ensuring reliability § Documentation critical 4 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
DR Tools Explained 4 Levels of Tools: 1. 2. 3. 4. 5 Lump ‘o’ Coal Bronze Medal Silver Medal Gold Medal OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
DR Tools: Lump ‘o’ Coal § You have nothing… § You don’t think you need a plan § You don’t want to get paid 6 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Lump ‘o’ Coal Tools Overview § http: //monster. com § http: //www. linkedin. com § http: //www. resumes. com § http: //jobsearch. about. com/od/curriculumvitae § /Curriculum_Vitae. htm http: //safari. oreilly. com/0028642759 (The Complete Idiot’s Guide™ to PC’s) 7 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
What is your final destination? § 1. 76 § 2. 29 § 10, 867, 052 § § § 8 OPS-4: The Complete Database Disaster Recovery Plan! 1. 76 – Avg. score between 1 st and 2 nd place 2. 29 – Salary difference between 1 st and 2 nd place $10, 867, 052 – Salary of #1 player last year © 2008 Progress Software Corporation
DR Tools: Bronze § Backups § Dbanalysis § Idx. Check § Db. Tool § RAID 10 9 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Bronze Tools Overview § All of these tools (except Raid 10) are § § 10 available to you… probkup [dbname] [filename] proutil [dbname] -C dbanalys > [filename] proutil [dbname] -C idxcheck all > [filename] dbtool [dbname] OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
DR Tools: Silver § All of the Above (Bronze) § After-Imaging § AI Management Utility § Database Maintenance • Update Statistics • Index Compaction § Database Monitoring 11 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Silver Tools Overview § After Imaging (AI) – A sequential log of changes to your database “Front End” A 1 DB A 2 “Back End” A 1. 1 A 1. 4 A 2. 2 A 2. 5 A 3 DB A 3. 3 Backup A 3. 6 § AI Management Utility • Allows the Database broker to do the “front end” work for you 12 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Silver Tools Overview Management & Monitoring § Tools to help prevent the disaster • • • Progress® Explorer Open. Edge® Management Pro. Top Pro. Monitor Miscellaneous – Scripts – Promon – Virtual System Tables (VST’s) 13 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Silver Tools Overview Additional Help! § Services • • 14 Progress GFS Your Application Partner DBAppraise – White Star Software Managed DBA Services – Brave. Point OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
DR Tools: Gold § § § All of the above (Bronze & Silver) Open. Edge Replication 3 rd party replication • Net. App • SRDF § § Failover Clusters Additional database parameters to add stability • Runtime consistency checking parameter (-Mem. Check, -Db. Check, -Table. Check, -Index. Check, -Area. Check) 15 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Gold Tools Overview § § § 16 OPS-3 - What's New in 10. 1 RDBMS? OPS-11 - After Imaging - New features, Greater Flexibility OPS-18 - Data Management and Platforms Roadmap OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Agenda § Disaster Recovery (DR) Tools § Using the Tools § Building a New Plan § An Example Plan § Wrap-up & Questions 17 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Using The Tools: What Do You Have Now? § Established? § Documented? § Tested? § Staff Training? § Who is in charge? • NOT the CEO… • “Greater human intervention == More failures” 18 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Using The Tools: What Are Your Challenges? § Where does your existing plan break down? § When did you last update it? 19 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Using The Tools: What is your number? § § § 20 Gartner estimates that only 35 percent of SMBs have a comprehensive disaster recovery plan in place. According to analyst firm IDC, about 70% of all successful attacks on computer networks were carried out by employees and insiders. Pink Square – You don’t have a plan and you wouldn’t test it if you had it!!! OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Agenda § Disaster Recovery (DR) Tools § Using the Tools § Building a New Plan § An Example Plan § Wrap-up & Questions 21 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Building a New Plan: What to Consider? § Business Requirements § Which tools do you want? § Documentation, documentation § Development • Database design (physical & logical) • Configuration design § Testing § Pre-production § Production 22 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Building a New Plan: What to Consider? What do these have in common? § Infinity § Your DB DR Plan § Your children’s need to borrow money… 23 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Maintaining The New Plan § Wash, rinse, repeat § Making sure the plan is complete • • Environmental Changes Documentation M&A Growth § Famous Customer Quote: “Nothing has changed – Honest!” 24 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Agenda § Disaster Recovery (DR) Tools § Using the Tools § Building a New Plan § An Example Plan § Wrap-up & Questions 25 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Under Development D § § § S C L A I M E R The examples presented herein are to be used as templates. They are one example of how to do DB DR planning. There are others. The author can, in no way, shape, or form, be held accountable for their execution capabilities. The documents referenced here may or may not contain proprietary code. This code is the sole responsibility of the executor, not the creator. Your mileage may vary. By continuing with this presentation you agree to adhere to the following concept: beta is for sissies; if it compiles then ship it; you start coding – I’ll figure out what we’re supposed to be creating. Products mentioned and used in the example templates are owned by their respective creators. Use of TLA’s are expected and encouraged. The views in this presentation represent those of the speaker and not necessarily those of Progress Software Corporation. No sandwiches were injured during this portion of the presentation. D 26 I I S C L OPS-4: The Complete Database Disaster Recovery Plan! A I M E R © 2008 Progress Software Corporation
An Example Plan: Overview § Available on PSDN after the conference… § Perl scripting language used • Why did I use Perl? § Documentation included § Logging included 27 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
An Example Plan: Documentation § Documentation • Internal script documentation • Process logging § Naming Conventions • • • 28 Start/Stop* - start/stop processes Run* - Initial run scripts Move* - scripts to move files around *. properties – property configuration files Sub* - subroutine library OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
An Example Plan: Script Overview § Start. AI, Start. Repl § Run. AI, Run. AIMgr, Run. Repl, § § 29 Run. Bkup, Run. Bkup. Validate, Run. Rest. Bkup Move. Bkup, Move. AI, Stop. Repl OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Wrapping it all up… 30 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Wrap-up § Ensure your plan is complete § Ongoing maintenance and validation is critical § 31 to a successful DB DR plan Documentation OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
So what do I do now? § If you are Bronze – on Monday you should: • Ask what the business requirements are for DR • Check your backup • Schedule and execute on tools provided • Schedule time to look at the dbanalysis!!! • Schedule testing your plan 32 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
So what do I do now? § If you are Silver – On Monday you should: • Do all of Bronze plus • Ask about business requirements again • Make sure you are monitoring and managing the correct resources! • Check your log files 33 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
So what do I do now? § IF you are Gold – On Monday you should: • Be able to sleep in… • Already know what the business requirements are • Ensure your plan is current… • Check for any additional holes in your plan 34 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
So what do I do now? § Finally - if you are a Lump ‘o’ Coal On Monday you should: • Come in Late • Update your CV • Make sure you Linked. In contacts are up to date… • Join your local PUG 35 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Other Sessions § OPS 21 – Open. Edge Management & § § 36 Replication Case Study OPS 13 – Building the Complete HA Application OPS 11 - After-Imaging: New features – greater flexibility OPS 1 – How Healthy is Your Database OPS 24 – Success with Open. Edge Replication OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
? Questions 37 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
Thank You 38 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
39 OPS-4: The Complete Database Disaster Recovery Plan! © 2008 Progress Software Corporation
- Slides: 39