Skip to Content
avatar image
Former Member

HANA Snapshot no end time

Hi all,

I try to execute a point-in-time restore using snapshots. During the recovery I want to roll forward the database to a specific time - meaning combination of storage snapshots and log backups.

The snapshot is in state "successful" in M_BACKUP_CATALOG.

After attaching the storage (EBS volumes) from the snapshot, the state changes to "failed". The backup catalog is located on a different volume as /hana/data and /hana/log. That means, the catalog is not reset by the snapshot.

Is it possible to load the backup catalog back to the system DB?

Any advice, why the snapshot state changes to "failed" and the end time (SYS_END_TIME and UTC_END_TIME) is empty?

HANA version: with one single tenant.

Any help is appreciated.

Regards Arne

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 20, 2017 at 08:33 AM


    a combination of storage snapshot of HANA Log-Volumes and Point In Time-Recovery is not possible. See SAP-Note

    Which volumes of the SAP HANA database are affected by a storage snapshot?

    A storage snapshot has to consider the data volumes of all SAP HANA database services. The log area must not be included in a storage snapshot to be able to perform a database recovery including the point-in-time option. Thus, log backups and not yet backed up log segments can be recovered after a snapshot has been restored.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Markus,

      the snapshot of /hana/log is not executed with the intention of a point-in-time recovery. In the AWS context log and data are sharing the same disks. I was trying to use the log backups for the recovery with the snapshot of /hana/data and CLEAR LOG command.

      In the meantime I was able to solve the issue. The tenant DB must not start after attaching the snapshot and before executing the recover process. It is no issue to include the log area to the snapshot, if you use 'clear log' during the recovery and backup log files.