HANA Resilience Operations: Backups, Certificates and Recovery Readiness (Part 6)
Operate HANA resilience through verified backups, restore testing, certificate lifecycle and clear recovery objectives rather than assuming green monitoring equals recoverability.
Explanation
Production HANA operations require evidence that the database can be recovered, not just that backups are scheduled. Monitor data and log backup success, retention and destination capacity.
Restore testing is essential. A backup that has never been restored is an unproven recovery asset. Recovery objectives should define acceptable data loss and service-restoration time for the business.
Certificates also create availability risk. Expired database, client or integration certificates can stop connectivity even when the database itself is healthy. Track expiry and ownership centrally.
High availability and disaster recovery designs should be tested through controlled failover or recovery exercises according to landscape policy.
Recovery design should include dependency order outside the database as well: application servers, destinations, identity services, interfaces and batch schedules may need coordinated restoration. Keep recovery evidence from exercises, including actual recovery time and unresolved gaps, so resilience is measured against business objectives rather than infrastructure assumptions.
Real project scenario
Backups had been green for months, but a disaster-recovery exercise found the secondary environment missing one required encryption key. Regular restore testing caught the issue before a real incident.
Common mistakes
- Monitoring backup job only.
- Never testing restore.
- Ignoring certificate expiry.
- Having no recovery time objective.
- Treating HA and backup as interchangeable.
Best practices
- Test restore regularly.
- Monitor log backup continuity.
- Track certificate expiry.
- Document RPO/RTO.
- Rehearse failover and recovery.
Interview angle
Explain why backup success, restore proof, certificate lifecycle and HA/DR are separate resilience controls.
Practice this lesson
Quick check
1. Scenario — Backups had been green for months, but a disaster-recovery exercise found the secondary environment missing one required encryption key. For the lesson "HANA Resilience Operations: Backups, Certificates and Recovery Readiness", which response shows the strongest architecture and production judgment?
2. Which SAP HANA backup type captures only the changes made since the last FULL backup, and always depends on that full backup rather than on any other backup taken in between?
3. What is the function of a savepoint in SAP HANA?
Interview questions
1. You are the senior consultant/architect responsible for HANA Resilience Operations: Backups, Certificates and Recovery Readiness. The project situation is: Backups had been green for months, but a disaster-recovery exercise found the secondary environment missing one required encryption key. How would you assess the design, identify the highest-risk failure modes, and define the evidence required before approving it for production?
Answer it in your own words first, then compare.
2. You are the senior consultant/architect responsible for HANA Backup Strategy, Recovery Scenarios, and System Replication for High Availability. The project situation is: A financial services customer running S/4HANA on-premise required an RPO of under fifteen minutes and an RTO under one hour for their production database. How would you assess the design, identify the highest-risk failure modes, and define the evidence required before approving it for production?
Answer it in your own words first, then compare.
Reference-verified: the steps are checked against official SAP documentation and tutorials, and object and field names in the sample code are checked for consistency. The code has not been compiled or run on an SAP system by ERPClimb. Syntax marked release-dependent varies by SAP release, so check it in your own system.
More lessons in this topic
- Architecting HANA Landscapes: HA/DR, Multitenancy, and Lifecycle Governance (Part 4)
- Core HANA Administration Tools and Day-to-Day Configuration Tasks (Part 2)
- HANA Backup Strategy, Recovery Scenarios, and System Replication for High Availability (Part 5)
- HANA Memory Management and Workload Governance (Part 3)
- SAP HANA Administration Tutorial (Part 1)