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:

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’

DR Tools: Lump ‘o’ Coal § You have nothing… § You don’t think you

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 §

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

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