In this lesson, you will know why you may perform a database recovery. You will also see the tasks you need to be perform before starting the recovery process to resolve an error, in an SAP HANA database instance.
You have discovered that during the daily data import cycle on September 21, 2021 at 09:33:08 AM the wrong import file was used. This logical problem needs to be corrected by a database recovery one second before the import started.
When a database error has occurred, you can recover an SAP HANA database to a Point in Time just before the database error occurred. This will fix the problem, but maybe not the root cause. A best practice should be to first investigate the root cause before you start the database recovery.
Checks before a Recovery
See the following video for the checks before you start a recovery.
Perform a Database Recovery
See the following video to perform a database recovery.