Loading...

HDBSettings.sh Example: Performing SAP HANA 2.0 Multitenant Database Container Restores for Disaster Recovery

Use this procedure when you need to perform a disaster recovery restore on a SAP HANA 2.0 or higher Multitenant Database Container Database.

The following conditions apply to this procedure:

  • The SID on the destination database can be the same as, or different from the source database.
  • When you restore the SYSTEMDB, the destination database must be a SYSTEMDB.
  • When you restore the tenant databases, the destination must be a tenant database. The name can be the same as, or different from the source database.

Note: You must restore the SYSTEMDB and all tenant databases.

Before You Begin

  1. Make sure that you have the following information:
    • The source instance SID name
    • The SAP HANA source physical client name
  2. Update the SAP HANA parameter file with the following entries:
    • srcCrossClient - This is the source physical client name.
    • scrCrossDbName - This is the source database name.
  3. Stop the SAP HANA destination server. On the command line, type the following command:

    Note: If the database is a multinode database, then you must run this command on all nodes.

    HANA stop

Procedure

  • Select one of the following recovery options:
    • Recover to the most recent backup. On the command line, type the following command substituting the timestamp that is in the future and the source SID (in this example, W01).

      HDBSettings.sh recoverSys.py --command="RECOVER DATABASE UNTIL TIMESTAMP '2018-10-27 20:33:49' CLEAR LOG USING SOURCE 'SYSTEMDB@W01' CHECK ACCESS USING BACKINT " --wait --timeout=600

    • Recover to a point in time. On the command line, type the following command, substituting the timestamp and source SID (in this example, W01).

      HDBSettings.sh recoverSys.py --command="RECOVER DATABASE UNTIL TIMESTAMP '2017-10-27 01:33:49' CLEAR LOG USING SOURCE 'SYSTEMDB@W01' CHECK ACCESS USING BACKINT " --wait --timeout=600

    • Perform a data only recovery. On the command line, type the following command, substituting the backup prefix and source SID (in this example, W01).

      HDBSettings.sh recoverSys.py --command="RECOVER DATA USING SOURCE 'SYSTEMDB@W01' USING BACKINT ('4344652_COMPLETE_DATA_BACKUP') CLEAR LOG"

What to Do Next

Recover the tenant databases. For more information, see HDBSQL Example: Recovering the SAP HANA 2.0 Tenant Databases for a Disaster Recovery.

Last modified: 11/27/2019 3:59:41 PM