Planning your backups
This recipe is all about thinking ahead and planning. If you’re reading this recipe before you’ve decided to make a backup, well done!
The key thing to understand is that you should plan your recovery, not your backup. The type of backup you make influences the type of recovery that is possible, so you must give some thought to what you are trying to achieve beforehand.
If you want to plan your recovery, then you need to consider the different types of failure that can occur. What type of recovery do you wish to perform?
You need to consider the following main aspects:
- Full or partial database?
- Everything or just object definitions?
- Is Point-in-Time Recovery (PITR) going to be needed?
- What are the requirements for restore performance?
We need to look at the characteristics of the utilities to understand what our backup and recovery options are. It’s often beneficial to have multiple types...
