Restoring databases after a primary storage failure with Data ONTAP operating in 7-Mode

Download PDF of this page

You can restore an SAP HANA database after a primary storage system running Data ONTAP operating in 7-Mode fails.

  1. In this case, the restore has to be executed directly on the secondary storage system by using the following command: snapvault restore --s snapshot_name -S backup_controller:backup_volumesource_controller:source_volume

    Perform this step for all volumes belonging to the SAP HANA database.

    hana1a>  snapvault restore -s Backup-ANA-SV_hourly_20140410103943 -S
    hana2b:/vol/backup_data_00001/mnt00001 hana1a:/vol/data_00001/mnt00001
    Restore will overwrite existing data in /vol/data_00001/mnt00001.
    Are you sure you want to continue? y
    Thu Apr 10 11:55:55 CEST [hana1a:vdisk.qtreePreserveComplete:info]: Qtree preserve is complete for /vol/data_00001/mnt00001.
    Transfer started.
    Monitor progress with 'snapvault status' or the snapmirror log.
    hana1a>  snapvault restore -s Backup-ANA-SV_hourly_20140410103943 -S
    hana2b:/vol/backup_data_00003/mnt00003 hana1a:/vol/data_00003/mnt00003
    Restore will overwrite existing data in /vol/data_00003/mnt00003.
    Are you sure you want to continue? y
    Thu Apr 10 11:58:18 CEST [hana1a:vdisk.qtreePreserveComplete:info]: Qtree preserve is complete for /vol/data_00003/mnt00003.
    Transfer started.
    Monitor progress with 'snapvault status' or the snapmirror log.
    hana1b>  snapvault restore -s Backup-ANA-SV_hourly_20140410103943 -S
    hana2b:/vol/backup_data_00002/mnt00002 hana1b:/vol/data_00002/mnt00002
    Restore will overwrite existing data in /vol/data_00002/mnt00002.
    Are you sure you want to continue? y
    Thu Apr 10 12:01:29 CEST [hana1b:vdisk.qtreePreserveComplete:info]: Qtree preserve is complete for /vol/data_00002/mnt00002.
    Transfer started.
    Monitor progress with 'snapvault status' or the snapmirror log.

    When the restore process is finished, you use SAP HANA to perform the recovery.