Developing a Recovery Strategy
The frequency with which you backup is determined by your recovery strategy. Developing a recovery strategy entail expressing a Recovery Point Objective (RPO) and a Recovery Time Objective (RTO). These are decisions that may or may not be within the DBA’s control. A DBA must frequently ask questions and listen closely to grasp what is crucial about a database’s recovery objectives, as well as assisting a business in understanding the budgetary implications of decisions made in this area. The scope of this paper does not include determining such a strategy.
When it comes to backups, you have a lot of alternatives. Let’s focus on a handful of the most fundamental.
Online vs Offline
One of the most basic backup decisions is whether to backup the database whether it is online or offline. If you take an offline database backup, no one will be able to access the database while it is being backed up, thus you’ll need to disconnect all connections and deactivate the database first.
It’s crucial to think about if your database is even set up for online backups. Online backups are only possible in databases that use archive logging. You won’t be able to take an online backup if a database employs circular logging by default. Because the database is not recoverable or a backup pending condition is in existence, online backup is not permitted.
The following are types of backups that can be made:
- Full – backs up the full database
- Incremental – Changes since the last full backup are backed up incrementally (restore requires a full image and the incremental image)
- Delta – Changes since the last full, incremental, or delta backup are backed up as delta backups (restore requires a full image and all incremental and delta images since the full image)
Db2 Backup and recovery should be a priority for any company that has an investment in their data. Choosing the right solution can make all the difference when trying to recover your data in a timely manner.
If you’re looking for a reliable solution or want help choosing one, contact an All Blue Solutions expert today.