Backup Error in Hana

Here , I Exaplined about backup failed with the error messages Backup error: The state 'ManagerCommandRunning' of the BackupManager or Backup error: connection broken SQLSTATE: HY000 or Error: other backup.pl is running

4> ERROR :Command
[su - siddm -c "xyz/usr/sap/SID/home/backup_bkp.pl";] failed with return code [512] and message [* 2: general error: Backup error: The state 'ManagerCommandRunning' of the BackupManager.

workaround for the error -
Backup will fail with this error when another backup is running at same time. In the HANA studio check the thread tab for this. If you see Backup manager is still running from a long time and from server level backup processes are not running. Then this problem will be solved by full system restart.

5> ERROR :Command
[su- sidadm –c “xyz/usr/sap/SID/home/backup_bkp.pl”] failed with return code [512] and message [*2: general error: Backup error: connection broken SQLSTATE: HY000]

workaround for the error -
Backup will fail with error when database went down during backup was running. For this check the availability log and backup timing. You can observe that during backup window database was unavailable.

6> ERROR :Command
[su - sidadm -c "xyz/usr/sap/SID/home/backup_bkp.pl";] failed with exit code [256] and mes-sage [Error: other backup.pl is runnig]

workaround for the error -
If the backup is failing with this error then because of previous running backup.pl new backup will fail. To solve this problem kill the backup processes which are running from a long time and run backup again.


To find the backup ID of the running data backup, use the following SQL command:

select BACKUP_ID from "SYS"."M_BACKUP_CATALOG" where entry_type_name ='complete data backup' and state_name = 'running' order by sys_start_time desc;

Backup Cancel  :

Backup Cancel (backup_id)