on 06-04-2013 10:54 PM
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.