B 5 The Complete Database Disaster Recovery Plan

B 5: The Complete Database Disaster Recovery Plan! David Eddy Senior Solution Consultant

What color are you? Source: http: //www. drj. com/articles/fall 06/1904 -03. html 2 ©

Agenda § Disaster Recovery (DR) Tools § Using the Tools § Building a New

DR Tools: The Basics § Not just recovery but… • Ensuring consistency • Ensuring

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 © 2008 Progress Software Corporation

What is your final destination? § 1. 76 § 2. 29 § 10, 867, 052 § § § 8 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] © 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 © 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 © 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 © 2008 Progress Software Corporation

Silver Tools Overview Additional Help! § Services • • 14 Progress GFS Your Application

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 © 2008 Progress Software Corporation

Gold Tools Overview 16 § B 2: What's New in 10. 1 RDBMS? §

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 © 2008 Progress Software Corporation

Using The Tools: What Are Your Challenges? § Where does your existing plan break

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!!! © 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 © 2008 Progress Software Corporation

Building a New Plan: What to Consider? What do these have in common? §

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 © 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 A I © 2008 Progress Software Corporation M E R

An Example Plan: Overview § Available on PSDN after the conference… § Perl scripting language used • Why did I use Perl? § Documentation included § Logging included 27 © 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 © 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 © 2008 Progress Software Corporation

Wrapping it all up… 30 © 2008 Progress Software Corporation

Wrap-up § Ensure your plan is complete § Ongoing maintenance and validation is critical

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 © 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 © 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 © 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 © 2008 Progress Software Corporation