What is the required state of the SAP HANA tenant database before it can be recovered?
AnswerA
ExplanationWhen performing a recovery of an SAP HANA tenant database using PowerProtect Data Manager, the database must be in an Offline (stopped) state.
Recovery Mechanism: The recovery process involves the PowerProtect Data Manager Backint agent overwriting existing data files and applying log backups to reach a specific point in time or a specific full backup.
Database Consistency: Because the underlying data files on the disk are being manipulated and replaced, the tenant database cannot be active. If the database were online, the files would be locked by the SAP HANA processes, and the data would be in a state of flux, leading to potential corruption.
Administrative Workflow: Typically, the administrator uses the SAP HANA Studio, SAP HANA Cockpit, or the hdbsql command-line tool to stop the specific tenant database while keeping the System database online to coordinate the recovery operation.