What can be done to alleviate the load in terms of backup? We could all throw more technology at the problem, to try and solve the backup window issue. Some examples:
- Point-in-time copies/snapshots: Disk vendors provide point-in-time copy capability, which can be used to secure that data before streaming it down to tape from a mount server.
- De-duplication technology: This effectively reduces the amount of data you back up, with RPO benefits, cost and potential footprint savings.
Data retention periods are another area of concern. We work in a time where compliance is king, and must now retain more data for longer periods of time. It is key to keep track of how much data is being retained, especially where the likes of RMAN backups are concerned, as many of the major backup products do not manage RMAN backups within their own backup retention policies. In the case of RMAN backups, it is the DBA's responsibility (along with the backup administrator) to ensure the data is expired in a timely manner.
It is not uncommon to see database nodes with extremely high occupancy of data in comparison to the actual database size. I have witnessed cases where a 500GB database has an occupancy of 50TB. Situations like this need to be addressed, for if left unmanaged, such a case will require the purchase of additional media on a regular basis and then expansion of the tape library to cope with the inorganic growth. All of this comes at a cost and has to be justified.
Remember the diverse effect this will have on server backup windows, and the consumption of precious capacity and bandwidth within the backup infrastructure.
There are other scenarios similar to those mentioned above but the key is avoiding these issues. How do we achieve that?
This is not only the responsibility of backup administrators -- it is a job for everyone who has a stake in the environment. This includes service management, system administrators and application/database administrators.
The best way to achieve these goals is to clearly define backup policies with the business (SLAs). The SLA is then managed by both the storage team (at a technology level) and by service management, through strong processes and relationships with application owners.
These are the cornerstones for any efficient backup environment. With strong policies in place, your backup environment should become easier to manage and cost savings in terms of media, tape library costs and staff overtime costs can then be realised.
About the author: Spencer Huckstepp is a technical consultant at Glasshouse Technologies (UK), a global provider of IT infrastructure services, with 11 years IT industry experience, eight of which have been in the enterprise storage arena. His role includes involvement with various virtualisation, storage and backup strategy engagements.