A database restore might be necessary when the data area or the log area is damaged, to recover from a logical error or to copy the database. You can achieve this by using data and log backups that you previously performed.
Perform a restore operation immediately after your first full backup to understand the process.
The SAP HANA database is a combination of services that invoke backint. The SAP HANA software determines and controls the number of streams to use for the restore by looking at services that are on the SAP HANA database.
If you want to recover from an auxiliary copy, set the set the CV_restCopyPrec environmental variable in the SAP HANA BACKINT parameter file to the copy that you want to restore from and then perform the restore.
For information on required and optional parameters, see SAP HANA BACKINT Configuration Parameters.
You can perform the following types of restores from the CommCell Console:
-
Recover to the most recent state - This recovers the most recent backed up data and log files.
Note
You must stop the SAP HANA replication before you restore the most recent backed up data and log files. If you do not stop the SAP HANA replication, only the latest data will be restored and the latest log will not be restored.
-
Recover to a point-in-time - This recovers the backed up data up to the specified time.
-
Recover to a specific data backup - This recovers the backed up data of the specified backup.
You can also use a restore to:
-
Perform a database copy
-
Restore from a multi-node to single-node environment
Backup Verification
You can run a workflow that nvokes the SAP HANA hdbbackupdiag command to verify that the software can access the data backups and the log backups that are mandatory to complete a restore operation. For more information, see Verifying That SAP HANA Backups Are Available for a Restore Operation.