Restoring SAP HANA data

To restore SAP HANA data from the vSnap repository, define a job that restores data from either the newest backup or an earlier backup copy. You can choose to restore data to the original instance or to an alternative instance on a different machine, and specify recovery options, and save the job.

1. In the navigation panel, expand Manage Protection > Databases > SAP HANA and click Create job > Restore.
   The Restore wizard opens.
2. Optional: If you started the restore wizard from the Jobs and Operations page, click SAP HANA as the source type and click Next.
   Tips:

   • For a running summary of your selections in the wizard, click Preview Restore in the navigation panel in the wizard.
   • The wizard is opened in the default setup mode. To run the wizard in advanced setup mode, select Advanced Setup. With advanced setup mode, you can set more options for your restore job.
3. On the Select source page, click an SAP HANA instance to show the databases in that instance. Click the plus icon next to the database that you want to use as the source of the restore operation. You can select more than one database from the list.

   The selected sources are added to the restore list next to the database list. To remove an item from the list source, click the minus icon next to the item.

4. Click Next to continue.
5. In the Source snapshot page, choose the type of restore operation required.
   • On-Demand: Snapshot: creates a once-off restore operation from a database snapshot. The job is not set to recur.
   • On-Demand: Point-in-Time: creates a once-off restore operation to recover the database state that existed at a specific date and time. The job is not set to recur.
   • Recurring: creates a recurring job that runs on a schedule and repeats.
   Tip: For an On-Demand: Snapshot, you can select no recovery or to recover until the end of the backup. For an On-Demand: Point in Time restore job, you can select to recover until a specific point-in-time.
6. Complete the fields on the Source snapshot page and click Next to continue.
   The fields that are shown depend on the number of items that were selected on the Select source page and on the restore type. Some fields are also not shown until you select a related field.

   Fields that are shown for an on-demand snapshot, single resource restore

   Option	Description
   Date range	Specify a range of dates to show the available snapshots within that range.
   Backup storage type	All backups in the selected date range are listed in rows that show the time that the backup operation occurred and the service level agreement (SLA) policy for the backup. Select the row that contains the backup time and SLA policy that you want, and then take one of the following actions: Click the backup storage type that you want to restore from. The storage types that are shown depend on the types available in your environment and are shown in the following order: Backup Restores data that is backed up to a vSnap server. Replication Restores data that is replicated to a vSnap server. Object Storage Restores data that is copied to a cloud service or to a repository server. Archive Restores data that is copied to a cloud service archive or to a repository server archive (tape). Click anywhere on the row. The first backup type that is shown sequentially from the left of the row is selected by default. For example, if the storage types Backup, Replication, and Archive are shown, Backup is selected by default.
   Use alternate vSnap server for the restore job	If you are restoring data from a cloud service or a repository server, select this box to specify an alternative vSnap server, and then select a server from the Select alternate vSnap menu. When you restore data from a restore point that was copied to a cloud resource or repository server, a vSnap server is used as a gateway to complete the operation. By default, the vSnap server that is used to complete the restore operation is the same vSnap server that is used to complete the backup and copy operations. To reduce the load on the vSnap server, you can select an alternative vSnap server to serve as the gateway.

   Fields that are shown for an on-demand snapshot, multiple resources restore; or recurring restore. For point-in-time restore, only Site is available for Restore Location Type.

   Option	Description
   Restore Location Type	Select a type of location from which to restore data: Site The site to which snapshots were backed up. The site is defined in the System Configuration > Storage > Sites pane. Cloud service copy The cloud service to which snapshots were copied. The cloud service is defined in the System Configuration > Storage > Cloud storage pane. Repository server copy The repository server to which snapshots were copied. The repository server is defined in the System Configuration > Storage > Repository servers pane. Cloud service archive The cloud archive service to which snapshots were copied. The cloud service is defined in the System Configuration > Storage > Cloud storage pane. Repository server archive The repository server to which snapshots were copied to tape. The repository server is defined in the System Configuration > Storage > Repository servers pane.
   Select a location	If you are restoring data from a site, select one of the following restore locations: Primary The primary site from which to restore snapshots. Secondary The secondary site from which to restore snapshots. If you are restoring data from a cloud or repository server, select a server from the Select a location menu.
   Date selector	For on-demand restore operations, specify a range of dates to show the available snapshots within that range.
   Restore Point	For on-demand restore operations, select a snapshot from the list of available snapshots in the selected date range.
   Use alternate vSnap server for the restore job	If you are restoring data from a cloud service or a repository server, select this box to specify an alternative vSnap server, and then select a server from the Select alternate vSnap menu. When you restore data from a restore point that was copied to a cloud service or repository server, a vSnap server is used as a gateway to complete the operation. By default, the vSnap server that is used to complete the restore operation is the same vSnap server that is used to complete the backup and copy operations. To reduce the load on the vSnap server, you can select an alternative vSnap server to serve as the gateway.

7. Choose an appropriate restore method for the destination chosen for the restore operation. Click Next to continue.
   • Instant Access: In this mode, no further action is taken after IBM Spectrum Protect Plus mounts the volume from the vSnap repository. Use the data for custom recovery from the files in the mounted volume.
   • Production: In this mode, the SAP HANA application agent first copies the files from the vSnap repository volume to the target host, which is either an alternative location or the original instance. The copied data is then used to start the database.
   • Test: In this mode, the agent creates a new database by using the data files directly from the vSnap repository.
     Attention: When restoring to the original location, choosing test mode restore will replace any existing production SAP HANA database in the data area, which is defined by the configuration parameter basepath datavolumes, with symbolic links leading to the NFS mount of the vSnap volume.

   To restore data to the original instance, follow the instructions in Restoring to the original instance. To restore data to an alternative instance, follow the instructions in Restoring to an alternate instance.

8. Set the destination for the restore operation by choosing one of the following options. Click Next to continue.
   • Restore to original instance: this option restores data to the original server and original instance.
   • Restore to alternate instance: this option restores data to a different specified location, creating a copy of the data at that location.

   If you are restoring data to an alternative location, choose an instance in the Instance table before you click Next. The alternative instance must be on a different machine; unsuitable instances are not available for selection.

9. Optional: In the Job Options page, select the recovery, application, and advanced options for the restore operation you are defining.
   Tip: Recovery options are not available for instant access restore jobs.
   • No Recovery. This option skips any recovery after the restore operation. The database remains offline until you decide whether you want to run the recovery operation manually.
   • Recover until end of backup. This option recovers the selected database to its state at the time the backup was created.
   • Recover until specific point-in-time. This option includes all the backup data up to a specific point-in-time. This option is available only if you enabled log backups in your SAP HANA backup job definition. Configure a point-in-time recovery by a specific date and time, for example, Jan 1, 2019 12:18:00 AM. IBM Spectrum Protect Plus finds the restore points directly before and after the selected point-in-time. During the recovery process, the older data backup volume and the newer log backup volume are mounted. If the point-in-time is after the last backup, a temporary restore point is created. This recovery option is not available if you selected a specific restore point from the list. This option is available only when you are running an on-demand point-in-time restore job.
10. Optional: In the Job Options page, select the application options for the restore operation you are defining.
    Tip: Application options are not available for instant access restore jobs.
    • Overwrite existing databases: Choose this option to replace all databases of the destination SAP HANA instance during the restore recovery process. If this option is not selected, the restore job fails either when the destination SAP HANA instance and its databases are running or when database files exist in the data area which is defined by the configuration parameter basepath_datavolumes during the restore operation. This option is only available for production mode restore operations.
    • Maximum Parallel Streams per Database. You can choose to run the restore operation of data in parallel streams. This option is useful if you are restoring a large database.
11. Optional: In the Job Options page, select the advanced options for the restore operation you are defining.
    • Run cleanup immediately on job failure. This option enables the automatic cleanup of backup data as part of a restore if recovery fails. This option is selected by default. Do not clear this option unless instructed by IBM® Support for troubleshooting purposes.
    • Continue with restores of other selected databases even if one fails. This option continues the restore operation if one database in the instance fails to be restored successfully. The process continues for all other databases that are being restored. If this option is not selected, then the restore job stops when the recovery of a resource fails.
    • Mount point prefix. For instant access restore operations, specify the prefix for the path where the mount point is to be directed.
12. Optional: Choose script options in the Apply Scripts page, and click Next to continue.
    • Select Pre-Script to select an uploaded script, and an application or script server where the pre-script runs. To select an application server where the script runs, clear the Use Script Server check box. Go to the System Configuration > Script page to configure scripts and script servers.
    • Select Post-Script to select an uploaded script and an application or script server where the post-script runs. To select an application server where the script runs, clear the Use Script Server check box. Go to the System Configuration > Script page to configure scripts and script servers.
    • Select Continue job/task on script error to continue running the job when the script that is associated with the job fails. When this option is enabled and the prescript completes with a nonzero return code, the backup or restore job continues to run and the prescript task status returns COMPLETED. If a postscript completes with a nonzero return code, the postscript task status returns COMPLETED. When this option is not selected, the backup or restore job does not run, and the prescript or postscript task status returns with a FAILED status.
13. In the Schedule page, name the restore job and choose the frequency for the job to run. Schedule the start time, and click Next to continue.

    If the restore job you are specifying is an on-demand job, there is no option to enter a schedule. Specify a schedule only for recurrent restore jobs.

14. In the Review page, review your selections for the restore job. If all the details are correct for your restore job, click Submit, or click Back to make amendments.