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> HDBSettings.sh recoverSys.py --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:
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:
Thanks
Srikar