Please Help--Hana point-in-time recovery with command line

[Former Member]

Hi all,

Due to company rules, we cannot use hana studio to do the recovery. I did some research.  It seems that ‘HDBSettings.sh recoverSys.py –command ‘ can do the job.

My script is

1. HDBSettings.sh recoverSys.py --command "recover database UNTIL TIMESTAMP '2013-06-04 12:45:00' USING DATA PATH ('/usr/sap/HDB/HDB00/backup/data/bkp')  USING LOG PATH ('/usr/sap/HDB/HDB00/backup/log')"

The log backup is under /usr/sap/HDB/HDB00/backup/log'

The full backup is under  :/usr/sap/HDB/HDB00/backup/data

hana101:/usr/sap/HDB/HDB00/backup/data> ls -al

total 903276

drwxrwx--x 2 hdbadm sapsys      4096 Jun  4 14:43 .

drwxrwx--x 4 hdbadm sapsys      4096 May 29 11:49 ..

-rw-r--r-- 1 hdbadm sapsys     24576 Jun  4 12:43 bkp_databackup_0_1

-rw-r--r-- 1 hdbadm sapsys  71426048 Jun  4 12:43 bkp_databackup_1_1

-rw-r--r-- 1 hdbadm sapsys 428552192 Jun  4 12:43 bkp_databackup_2_1

-rw-r--r-- 1 hdbadm sapsys 354594816 Jun  4 12:43 bkp_databackup_3_1

-rw-r--r-- 1 hdbadm sapsys  69419008 Jun  4 12:43 bkp_databackup_4_1

But I  always get the below error.

================================

[140345981458176, 0.002] >> starting recoverSys (at Tue Jun 4 14:35:31 2013)

[140345981458176, 0.002] args: ()

[140345981458176, 0.002] keys: {'command': "recover database UNTIL TIMESTAMP '2013-06-04 12:45:00' USING DATA PATH ('/usr/sap/HDB/HDB00/backup/data/bkp')  USING LOG PATH ('/usr/sap/HDB/HDB00/backup/log')"}

Enter the password of user hdbadm :

recoverSys started: 2013-06-04 14:35:34

testing master: hana101.opslab.ariba.com

hana101.opslab.ariba.com is master

shutdown database

stop system

stop system: hana101.opslab.ariba.com

creating file recoverInstance.sql

restart database

restart master nameserver

start system: hana101.opslab.ariba.com

2013-06-04T14:35:38-07:00  P52758 13f111de064 ERROR   RECOVERY RECOVER DATA finished with error: [449] recovery strategy could not be determined, volume 1, reached log position 0, [111001] Log backup incompatible with data backup: Expected E6C61505-ACD8-20130529-184430-2C70000001 or 00000000-0000-19720306-084436-2E00000000 (from log backup log_backup_1_0_987712_990272) in data backup full_bkp_databackup_1_1 but found C12E58B8-AC38-20130531-232650-1BE0000001

start system: hana101.opslab.ariba.com failed: start of nameserver failed

Pease help we really need to figure out this.

Thanks,

Lily

[Former Member]

Hi Lily,

Please take a look at note 1779221, this note describes the error you are receiving above and should help resolve your issue.

Thanks,

Sharan