What is RPO/RTO?
Time is money!
Your boss keeps talking about RPO (Recovery Point Objective) and RTO (Recovery Time Objective). Do you just nod your head like you know what he/she is talking about? Maybe that scenario just happened and you are searching the internet for what these terms mean. If so, welcome! No one likes to think about disasters, but they happen all too often. Planning for the worst and hoping for the best will keep your data safe and your job even safer. Let’s take some time and explore what RPO and RTO mean, why these things are important, and what you need to do next to be a hero DBA!
RTO (Recovery Time Objective)
Recovery Time Objective is the amount of time in which your company expects you to have the database fully restored after a disaster. That is, how much downtime is acceptable for disaster recovery or planned outages. Each company is different, and most reference RTO in terms of nines.
The nines measure for a company that measures 365 days a year, 24 hours a day as follows:
5 9’s – 99.999% (this translates to about 5 minutes of acceptable downtime per year)
4 9’s – 99.99% (this translates at about 52.5 minutes per year and is much easier to achieve)
3 9’s – 99.9% (this translates at about 8.75 hours per year)
2 9’s – 99% (translates to about 3.5 days a year)
To decide what RTO is best for your company, you need to take into consideration your data needs. Not all companies run on a 365/24 schedule. Some companies only measure downtime between 8am-6pm Monday through Friday, or only on the weekends. This will drastically change the translation of the 9’s. Another thing to think about is whether the measured downtown includes time for maintenance or patching, times when the database must be offline. If maintenance time is eliminated from consideration, meeting the higher 9’s is much easier.
If your company insists on an RTO of 5 Nines and does not take into consideration maintenance or patching, then you must speak with the persons in charge to discuss the RPO. It is possible to adhere to the strict 5 minutes of downtime, but the point at which you are able to recover, will definitely be restricted.
RPO (Recovery Point Objective)
Recovery Point Objective is the level of data or work that is acceptable to lose in the event of a disaster. Ideally, companies will want ZERO data or work loss. While that IS achievable, it will all depend on valid backups and the extent of damage the database suffered at the point of disaster.
An RPO of 15 minutes means that the data and work must be recoverable to a point within 15 minutes of the disaster, meaning that it is expected that only 15 minutes of work or data may be lost. Stop right here and think about your backup plans and recovery models. Restoring a database that is in simple recovery model should not take as long as a restoring one in full recovery model. It is important to remember (from previous blog posts), the recovery model dictates how much data you can recover. It is also important to remember, the ability to recover ANY data at all is fully dependent on having valid backups.
Run Book
Another term you might hear is “Run Book”. A Run Book is a physical or digital collection of information that is needed to restart the database in case of disaster. There are many items that should be included in the runbook. Some of the essential items one should consider having in the runbook are:
- Server level info, configuration, purpose, etc.
- List of all databases and applications using them
- List of agent jobs and proper response to a failure
- Disaster Recovery process with all contacts, RPO/RTO, etc. required to bring it back (based on level of issue)
- Security
- Backup schedules
When considering a run book, think about what someone would need if they were new to the company and the only person available to restart the database. What information would that person need? Making sure your run book is up to date on a regular basis is certainly a great idea!
Preparing for disaster
Keep in mind that if you prepare for the worst, you will be less likely to be caught off-guard with a manager breathing down your neck asking “WHEN WILL WE BE BACK UP AND RUNNING?!?!” Do you have any idea how long it will take to restore your database? If your answer is “no,” I would suggest doing a restore to see how long this takes. Further, I would suggest making it a habit to perform drills so that you and your team know what to do in the event of a disaster, and exactly how long it takes to get your company back up and running. Having a solid backup schedule, validating those backups, and keeping your company’s expectations in mind, you will be ready to handle any data disaster that may be thrown your way.
Touche. Solid arguments. Keep up the amazing work.
Why visitors still mmake use of too read news papers when in this technological
globe the whole thing is available on net?
Spot on wijth this write-up, I actually feel this web site needs much more attention. I’ll probably be back again to read through more, thank for the info!
Spot on with this write-up, I hohestly think this web site needs
a great deal more attention. I’ll pribably be returning tto read
through more, thanks for the information!
Spot on with this write-up, I honestly feel this site needs a great deal more attention. I’ll probably be back again to
read more, thanks for the advice!
Pretty! This was an incredibly wonderful article.Thank you ffor providing these details.
Woah! I’m really loving the template/theme of this website.
It’s simple, yet effective. A lot of times it’s tough to get that
“perfect balance” between superb usability and visual
appearance. I must say you have dlne a superb job with this.
In addition, the blog loads very quick for
me on Firefox. Superb Blog!
Hey very nice blog!
Its such as you learn my thoughts! You appear to understand
so much approximately this, such as you wrote the book in it
or something. I believe that you can do with some percent to fodce the message home a
bit, however other than that, this is wonderful blog.
A fantastic read. I will certainly be back.
I enjoy looking through an article that will make men and women think.
Also, many thanks for allowing me to comment!
I love looking through an aarticle that can make men and women think.
Also, many thanks for allowing me to comment!
Thanls for the gopd writeup. It if truth be tolld used to be a enjoyment account
it. Glance complex to far introduced agreeable from you!
By the way, how can we communicate?
Hi, Ido believe this is an excellent blog.
I stumbledupon it 😉 I may revisit once again since i have saved as a favorite it.
Money and freedom is the best way to change,
may you be rich and continue to guide other people.
Heya outstanding website! Does running a blog
similar to this take a great deal of work?
I have absolutesly no expertise in computer programming however
I had been hoping to start my own blog soon. Anyway, if
yoou have any suggestions or tips for new blog owners please share.
I understand this is off topic however I just needesd to ask.
Thanks!
Hello! This is kind of off topic but I need some advice from
an established blog. Is it very hard to set up your own blog?
I’m not very techincal but I can figure things out pretty fast.
I’m thinking about setting up my own but I’m not sure where to start.
Do you have any ideas or suggestions? Cheers
For latest news you have to visit web and on thee web I
found this web page as a most excellent web site for
most up-to-date updates.
What’s up, its good article on the topic of edia print, we all know media is a wonderful source
of information.
excellent ssues altogether, you just gained a new reader. Whhat would
you recommend in regards to your publish that you made some
days in the past? Any certain?
I’m really impressed with yoour writing skills and also with the layout
on your blog. Is this a paid theme or did you customize it yourself?
Either way keep up the nice quality writing, it’s rare to see a great blog like this one
nowadays.
I hawve read some good stuff here. Certainly value bookmarking for revisiting.
I surprise how a lot attempt you place to create any such fantastic
informative website.
What i do not understood is actually how you are now not really much more
smartly-favored than you might be right now. You’re
so intelligent. You understand therefore considerably in the case of this topic,
produced me in my opinion consider iit from a lot of numerous angles.
Its like men andd women are not interested unless it’s something to accompllish
with Lady gaga! Your individual stuffs outstanding.
Always maintain it up!
I visited many sites however the audio quality for audio sngs existing at this website is in fact excellent.
I enjoy looking through a powt that can maake
men and women think. Also, thanks for permitting me to comment!
I do not even understand how I enjded up right here, but I thought this publish
was oncee good. I don’t realize who you’re however certainly you’re going to
a well-known blogger when you aren’talready. Cheers!
Hi there aare using WordPress for your blog platform? I’m new to
the blog orld but I’m trying to get started aand create my own. Do you need anyy coding
knowledge to make your own blog? Any help would
bbe greatly appreciated!
Hi there! I know this is kinda off topic however I’d figured I’d ask.
Would you be interested in trading links or maybe guest authoring a blog article or vice-versa?
My site covers a lot of the same subjects as yours and I believce we could greatly benefit from ech other.
If you’re interested feel free to send me an email.
I look forward to hearing from you! Wonderful blog by the way!
I know this web page offers quality based posts andd extra data, is
there anny other website which presents these kinds of information in quality?
시급은 평균 5만~8만 원 이상이며, 손기술을 배우면 장기적인
커리어로 전환할 수도 있죠.
Keep this going please, great job!
Thanks for sharing your thoughts on solicitor uk. Regards