Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Hi all,

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

My script is

  1. --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: is master

shutdown database

stop system

stop system:

creating file recoverInstance.sql

restart database

restart master nameserver

start system:

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: failed: start of nameserver failed

Pease help we really need to figure out this.



Not what you were looking for? View more on this topic or Ask a question