> Documentation > Backup and Restore Agents > Databases > SAP > SAP HANA > SAP HANA Restores

Restoring the SAP HANA Catalog to a Point in Time

Beginning in Service Pack 12, you can restore the SAP HANA catalog to a point in time.

Important

Use this procedure in special circumstances, for example when there is database corruption.

Before You Begin

  1. Perform a full backup or perform an incremental backup.

  2. Verify that the restore environment has the same set of nodes and the instance SID name as the backup environment. In case of any configuration file modification in the backup environment, make the same modifications in the restore environment before starting the recovery process.

  3. Verify that the SAP HANA software version that is used for restore is of the same version or later than the software version used during backup.

Procedure

  1. From the CommCell Browser, expand Client Computers > pseudo-client > SAP HANA.

  2. Right-click the instance, point to All Tasks and then click Browse and Restore.

  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.

  4. From the Browse window, under SAP HANA, select the data to restore, and then click Recover All Selected.

    The Restore Options dialog box appears.

  5. Select the destination client and instance:

    1. Select the client that you want to restore to from the Destination Client list.

    2. Select the instance that you want to restore to from the Destination Instance list.

  6. Specify the time to restore the database to.

    1. Select Recover Database To.

    2. Select Point In Time, and then select the date and time.

      Note: If the time zone is different on the CommServe computer and client, in the Time Zone box, select the client computer time zone.

    3. To restore relative to the system date, select Relative to Sysdate, and then select the number of days relative to the system date.

  7. To verify that all the backups required for the recovery operation are available, select the Check Access check box.

  8. To initialize the log area, select the Initialize log area check box.

    For information on the initialize log area option, see SAP HANA Restore Options.

  9. Optional: Select the Use Delta Backups check box.

    For information on the delta backup option, see SAP HANA Restore Options.

  10. Specify the time to restore the SAP HANA catalog to. Click Advanced.

    The Advanced Restore Options dialog box appears.

    1. On the Catalog restore tab, make the following selections:

      1. Select the Restore from catalog time check box.

      2. To restore to a point in time, select Point In Time, and then select the date and time.

      3. To restore relative to the system date, select Relative to Sysdate, and then select the number of days relative to the system date.

    2. Click OK to close the Advanced Restore Options dialog box.

  11. Click OK to close the Restore Options dialog box and start the restore.

Loading...