Skip to Content
Nov 21, 2013 at 06:00 AM

Recovery not working


Hello All

In a simple scenario of creating new system with backup of old system the HANA studio is not responding.

1. Both the instances are on AWS

2. Both the instances are on Rev66

3. HANA studio is also Rev66 version

Steps performed:

1. Taken the backup from source system

2. Copied over to new system, changed permissions of the files and tried recovering from HANA Studio.

Studio runs for a minute and does nothing, and says as below:



Tried to recover my command line as below, the recovery says it's completed and after couple of minutes the HANA system goes down and doesn't come up.

hanaserver:/usr/sap/HDB/HDB00> --command "recover data using file ('ASOF_NOV20_1635PST') clear log"

[140380360279808, 0.004] >> starting recoverSys (at Thu Nov 21 05:42:22 2013)

[140380360279808, 0.004] args: ()

[140380360279808, 0.004] keys: {'command': "recover data using file ('ASOF_NOV20_1635PST') clear log"}

own pid: 10424

Enter the password of user hdbadm :

recoverSys started: 2013-11-21 05:42:32

testing master: hanaserver

hanaserver is master

shutdown database, timeout is 120

stop system

stop system: hanaserver

stopping system: 2013-11-21 05:42:32

stopped system: 2013-11-21 05:42:56

creating file recoverInstance.sql

restart database

restart master nameserver: 2013-11-21 05:43:11

start system: hanaserver

2013-11-21T05:43:15+00:00 P011846 142792f063d INFO RECOVERY state of service: nameserver, hanaserver:30001, volume: 1, RecoveryExecuteTopologyAndSSFSRecoveryFinished

recoverSys finished successfully: 2013-11-21 05:43:17

[140380360279808, 55.101] 0

[140380360279808, 55.101] << ending recoverSys, rc = 0 (RC_TEST_OK), after 55.097 secs

Can you advise here what are the other ways we can do the recover and why Studio is not picking up the recovery.

When browsed through the trace, I could find the below clue:

[11375]{-1}[-1/-1] 2013-11-21 05:46:13.929315 i Daemon TrexDaemon.cpp(11147) : comment file contains: nameserver: previous recovery incomplete: volume: 3 is in state: RecoveryLogInitializationFinished volume: 4 is in state: RecoveryLogInitializationFinished volume: 2 is in state: RecoveryLogInitializationFinished

stop process hdbstatisticsserver with pid 11971

Does this mean the recovery from command line was not successful ?

Adding the below error screenshot from studio while I recover the system:




pastedImage_0.png (19.6 kB)
st1.JPG (17.6 kB)
st.JPG (17.8 kB)