Unable to recover HANA Database

[Former Member]

Hi Team,

Im trying to recover the HANA database through Studio.

But when I try to open Recover option fron studio I get below popup

"could not logon to sap hana system host"

"reason soap env server [invalid credentials]"

Thanks in Advance

[Former Member]

You need to use the credentials of the system that you have recovered from. 

[former_member182967]

Hi S,

Recover DB needs the username <sid>adm in OS and its password.

Regards,

Ning

[Former Member]

Hi Ning,

Yeah, I have <sid>adm USERNAME and PASSWORD.

But after providing user credentials also im facing same error.

(Or)

Should I recover Database only through OS level?

Thanks

S Ahmed

[former_member182967]

Hi S,

Maybe the user information input is wrong. (to change the password of OS user <sid>adm, using command passwd How to change &amp;lt;sid&amp;gt;adm password on HANA a... | SCN)

If you can logon the OS with user root, and then switch to <sid>adm. Perform the recovery using Python script recoverSys.py.

For more information about the script, check RECOVER DATABASE - SAP HANA SQL and System Views Reference - SAP Library

Options for Recovery with recoverSys.py - SAP HANA Administration Guide - SAP Library

Regards,

Ning