> Expert > Backup and Restore Agents > Databases > SAP > SAP HANA > SAP HANA Multitenant Database Container Overview > SAP HANA Multitenant Database Container Restores

Restoring the SAP HANA SYSTEMDB Database

Restore the multitenant database container SYSTEMDB database. You can only recover the SYSTEMDB database to the most recent state.

If you need to restore a SYSTEMDB database and tenant databases, perform the SYSTEMDB database restore first, and then restore the tenant databases.

You can restore to the same destination, or to the following new destinations:

  • Restore to a new destination that has the same SYSTEMDB SID as the source

  • Restore to a new destination that has a different SYSTEMDB SID from the source

Before You Begin

  1. Perform a SAP HANA full backup on a Multitenant SYSTEMDB database.

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

Procedure

  1. From the CommCell Browser, go to Client Computers > pseudo-client > SAP HANA > instance.

  2. Right-click the SYSTEMDB database backup set, point to All Tasks, and then click Browse and Restore.

    The Browse and Restore dialog box appears.

  3. Select Latest Backup, and then click View Content.

  4. From the Browse window, select the SYSTEMDB database in the right pane, and then click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the General tab, 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. Optional: Restore from a copy precedence.

    If the backup is corrupted, restore from a storage policy copy.

    For more information on modifying the copy precedence of a storage policy copy, see Copy Precedence.

    1. Click Advanced.

      The Advanced Restore Options dialog box appears.

    2. On the Copy Precedence tab, select the Restore from Copy Precedence number check box and enter a copy precedence number.

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

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

Result

The software restores the SYSTEMDB database to the specified location.

If you did not select the Initialize Logs check box, then the job goes to pending with a job pending reason (JPR) that is similar to the following message:

Error Code: [18:146] Description: SAP HANA Error [2017-02-28T07:59:55-05:00 P003115 15a84cd9aa8 ERROR RECOVERY RECOVER DATA finished with error: [448] recovery could not be completed, volume 1, reached log position 0, [110058] The existing log area is not compatible to the log and data backups ]. Source: hana07, Process: ClHanaAgent

What to Do Next

Perform a tenant database restore.

Loading...