Problem
SAP HANA backup policy fails with status code 29 as soon as the backup starts in Netbackup.
Error Message
bphdb stderr.log shows following error during failure
/usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/saphana-DDB.sh:line 51: DBname: command not found
*10: authentication failed SQLSTATE: 28000
Cause
The backup account or its password updated in the backup script is either changed or not correct.
Solution
1) Run following command on the SAP server with same account and password used for backup and it fails to login to the SAP HANA interactive terminal with the same error.
HANADEVDB:/usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle # /usr/sap/DDB/HDB06/exe/hdbsql -i 06 -n <account name> -u SYSTEM -p <password> -j -a -x
* 10: authentication failed SQLSTATE: 28000.
2) If we get the above output then advise the DBA team to provide and update a correct password for the backup account to run the backups.
3) If we are able to to login to the SAP interactive terminal with the above command then check the backup script and verify if the correct / changed password is updated in the backup script.
4) Backup script may have account details updated in multiple lines. We need to update the correct password in each line which has the account details.
5) Rerun the backup and monitor the progress.
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.