Comment on page
Age-based HANA Backup Automation
The primary objective of regularly taking backups is to ensure the creation of duplicate copies of data that can be easily recovered in case of database failure, unforeseen events, or security breaches. These failures can occur due to a variety of reasons, including system crashes, hardware or software malfunctions, data corruption, or incidents caused by human error.
By preserving backup copies, organizations can ensure the ability to restore data and recover their databases to a previous state before a database failure occurs. Regular backups play a crucial role in protecting against data loss and maintaining business continuity.
On the other hand, database backup automation can help to streamline and simplify your backup process. By automating the backups, organizations can achieve consistent and reliable backups without relying on human intervention, thereby reducing the risk of human error and oversight.
Automated backups serve as a critical component of a comprehensive disaster recovery plan, contributing to Disaster Recovery Preparedness. In the event of data loss or system failure, having up-to-date and automated backups enables organizations to restore their databases in accordance with their Recovery Time Objective (RTO) and Recovery Point Objective (RPO), enabling them to quickly resume operations.
IT-Conductor allows users to automate backup processes, which can be instrumental in meeting compliance requirements. By providing a systematic and auditable backup process, the automated backups generated by IT-Conductor can generate logs and reports that serve multiple purposes, including auditing and demonstrating compliance with data protection regulations.
- Add the database to IT-Conductor for monitoring, management, and automation.
- Create a database user with BACKUP ADMIN privilege.
- A Robot User should be created and associated with the application/DB/OS users with assigned roles/privileges to execute the local action on the system to be stopped/started.Figure 1: Start/Stop Process Definitions
IT-Conductor Backup automation tool offers flexible options for customization, allowing organizations to tailor the backup process to their specific needs. This includes defining backup schedules, threshold overrides, and custom recovery activities.
The backup is triggered each time the age of the last complete backup exceeds the specified time in the threshold override.
In the context of age-based HANA backups, a backup SQL script is a set of instructions that automates the process of creating backups based on the age of the data in a HANA database.
Figure 2: Backup SQL Script
- 1.Define the threshold override and specify the Age of the last complete backup after which a new backup will be triggered.
- 2.Select the recovery action and associate the SQL Script with the threshold override.
Figure 3: Thresholds and Recovery Configuration
Once the specified Age of the last complete backup elapses, the backup recovery activity is automatically triggered.
Figure 4: Age-based Backup Chart
When the backup automation initiates, alerts are generated to notify subscribed users.
Figure 5: Generated Alerts
Figure 6: Recovery Activities Launched for HANA Backup