Managing SAP HANA data with the Data Protection for SAP file manager

The Data Protection for SAP file manager is a tool that simplifies the inquire, restore, and delete operations of the SAP HANA backups that are saved to IBM Storage® Protect server.

Before you begin

Before you use the file manager, review the following details:
  • The file manager completes all operations by using the standard functions that are provided by Data Protection for SAP.
  • The interface consists of a split window that is character-based. In the left window, all backup IDs found on all IBM Storage Protectâ„¢ servers that match the backup ID prefix that is configured in the Data Protection for SAP profile are displayed. In the right window, all the files that belong to the selected backup ID are displayed. Individual backup IDs or multiple files can be selected.

Procedure

  1. Start the file manager with the path and name of the Data Protection for SAP profile:
    Note: The user must be a member of the dba group.
    backfm -p /hana/SID/dbs/initSID.utl [-o log file directory]
    
    If the -o parameter is specified at startup, the default directory for log files is changed.
  2. The file manager calls the backint executable file to connect to the IBM Storage Protect server configured in the Data Protection for SAP profile. If this call fails, the file manager shows an error message but does not analyze the cause of the error. Use the backint inquire function to analyze the error.
  3. The file manager runs an automatic inquire operation for all backup IDs. If you mark the backup ID that you are interested in and then press the Tab key to move the cursor to the right pane, all file names belonging to the marked backup ID are displayed.

Results

The following function keys are defined for restore and delete operations:
Up, Down, Left, Right - Move cursor
Move the highlighted cursor in the direction indicated on the key.
Tab - Switch window side
Move the cursor between the left and right sides of the window.
F2 - Restore
Restore all marked files. Before the restore operation begins, you can specify a common destination path and you are prompted to confirm the restore process. If you specify a destination path, all marked files are restored to that directory. Otherwise, the files are restored to the directory from which they were backed up.

For restore operations, the wanted files first must be marked. This action can be done either with the F3 function key to mark all the files that were found or with the ENTER key to mark only one wanted file. Marked files can be identified by the symbol *in front of the file name. Only the marked files are restored. For every restore operation, a log file is created in the following location:

$SAP_RETRIEVAL_PATH/backfm_timestamp.log

F3 - Mark all
All files that belong to the current backup ID are marked.
F4 - Unmark all
Unmark all files that belong to the current backup ID.
F5 - Refresh
Refresh the list of backup IDs and file names.
F6 - Fileinfo
Opens a separate window to display file information.

For backup IDs, the sequence number is displayed (backup version count). For SAP HANA, this number is always zero. For files, the IBM Storage Protect expiration date and time are displayed.

F7 - not available
F8 - Delete
Delete the selected backup ID and all corresponding files. The file manager can delete backup IDs with all included files. It is not possible to delete single files within a backup ID. To delete a backup ID, it must be highlighted. After you press F8, you must confirm the deletion operation. The backup ID and all included files are deleted from the IBM Storage Protect server.
F10 - Exit
Exit from Data Protection for SAP file manager.
ENTER - Mark/unmark file
Mark or unmark the file below the cursor.