Backing Up and Recovering SAP HANA Data › Database Recovery

Database Recovery

SAP HANA database has the capability to restore data in case of data loss.

You can perform database recovery from SAP HANA Studio:

Follow these steps:

1. Right click on the instance and choose Recover from the context menu of the database.

   

2. Enter the credentials of the SAP HANA operating system user <SID>adm.

   Note: To perform a recovery, the SAP HANA database will shut down.

Supported Recovery Methods

The following methods are supported by SAP HANA for recovery of system:

1. Recover the database to its most recent state.

   To recover a database to its most recent state, recovery uses:

   1. The latest specified data backup
   2. Subsequent log backups
   3. Entries that are still available in the log area (if they were not destroyed by the failure)
2. Recover the database to the following point in time:

   To recover a database to the following point in time, recovery uses

   1. Data backup based on the specified time
   2. Subsequent log backups
   3. Entries that are still available in the log area (if they was not destroyed by the failure)
3. Recover Database to a Specific Data Backup.

   To Recover Database to a specific Data Backup, recovery uses

   1. Specified data backup, but no log backups.
   2. Entries that are still available in the log area (if they were not destroyed by the failure).