Heterogeneous Backup and Restore w/ Point in Time Recovery

[Former Member]

Hello,

We were successful backing up and restoring an SAP HANA ( SPS09 ) database between two distinct instance installations ( different SIDs ). We tried to include the transaction logs as well ( for a point in time recovery ) but we were unable to make it work. Is this even possible during a heterogeneous backup and restore between distinct SAP HANA databases/installations ?

Command Line: This worked with a full backup and no transaction logs applied; target database catalog was not used

/usr/sap/xxx/SYS/exe/hdb/python_support/recoverSys.py --password=xxx --wait --command=" RECOVER DATA  USING FILE ('/hana/hana-backup/xxx/HDBxx/backup/data/COMPLETE_DATA_BACKUP')  CLEAR LOG"

Thank you in advance,

/gxo13

[Former Member · Accepted solution]

Hi Greg,

There are some preconditions to be checked first.

Have to you checked the admin guide about the same.

You have to clear the existing archive log files and place the ones which you want to roll forward to.

HDBSettings.sh recoverSys.py --wait --command="RECOVER DATABASE UNTIL TIMESTAMP '2014-01-05 20:15:00' CLEAR LOG USING DATA PATH ('/hana/backup/SID/YYYYMMDD_HHMM/data/') USING LOG PATH ('/hana/backup/SID/log/')"

Also the times mentioned are in UTC .

It did work for us after initial hicupps.

[Former Member · Accepted solution]

Awesome ! Thank you for syntax clarification ! Tested successfully !

[Former Member]

Hi Gregorio,

HANA Point in time backup and recovery from one source SID to another destinatiion SID is possible if you are using the file based backups

We do have notes from SAP for limitations of using this option for BACKINT solutions as of SPS09

The step to recover a HANA system point in time please refer the section 5.2.5.2.3.3 SQL statements for Database recovery and Data recovery in the latest SAP HANA Administration

guide and can be seen below

The query you are using above is also seen in the screen below and it is used for recovering a HANA system by avoiding the redo logs

You have options to use HANA Studio as well while doing such a recovery

Please refer section 5.2.6.2 in the same document

Hope it helps

Sunil