why HANA backup check availability or check access fails/timeouts from HANA Studio in Azure Native backup using recovery vault.

Question

why HANA backup check availability or check access fails/timeouts from HANA Studio in Azure Native backup using recovery vault.

Patil, Prafulla B 0

During HANA DB restore or PIT recovery from HANA Studio, Check availability or check access fails for HANA backup on Azure Native backup using recovery vault.

Restore using full backup-

Check availability of backup- timeouts

PIT recovery- with check access- FAILS

2023-11-06T14:12:35-06:00 P0042494 18ba643fb64 INFO RECOVERY command: RECOVER DATABASE FOR MDS UNTIL TIMESTAMP '2023-11-06 17:55:00' CLEAR LOG USING CATALOG BACKINT USING LOG PATH ('/usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/') USING DATA PATH ('/usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/') USING BACKUP_ID 1699207215094 CHECK ACCESS USING BACKINT IGNORE DELTA DATA BACKUPS

2023-11-06T14:15:02-06:00 P0042494 18ba643fb64 INFO RECOVERY using backup catalog 1699294845748 from /usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/log_backup_0_0_0_0

2023-11-06T15:08:05-06:00 P0042494 18ba643fb64 ERROR RECOVERY error in backint: /usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/FULL_SCHD_databackup_0_1 638348040150950000-1699207215094

2023-11-06T15:08:05-06:00 P0042494 18ba643fb64 ERROR RECOVERY error in backint: /usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/FULL_SCHD_databackup_2_1 638348040150950000-1699207215094

2023-11-06T15:08:05-06:00 P0042494 18ba643fb64 ERROR RECOVERY error in backint: /usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/FULL_SCHD_databackup_3_1 638348040150950000-1699207215094

2023-11-06T15:08:05-06:00 P0042494 18ba643fb64 INFO RECOVERY Ignoring unavailable backint backup in strategy: BACKINT inquire job from /usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/FULL_SCHD_databackup_0_1 failed with error code ERRORBACKINT inquire job from /usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/FULL_SCHD_databackup_2_1 failed with error code ERRORBACKINT inquire job from /usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/FULL_SCHD_databackup_3_1 failed with error code ERROR

2023-11-06T15:08:05-06:00 P0042494 18ba643fb64 ERROR RECOVERY RECOVER DATA finished with error: [449] recovery strategy could not be determined, [111014] The backup with backup id '1699207215094' cannot be used for recovery

PIT Recovery without check access- SUCCESS

RECOVER DATABASE FOR MDS UNTIL TIMESTAMP '2023-11-06 17:55:00' CLEAR LOG USING CATALOG BACKINT USING LOG PATH ('/usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/') USING DATA PATH('/usr/sap/MDS/SYS/global/hdb/backint/DB_MDS/') USING BACKUP_ID 1699207215094 IGNORE DELTA DATA BACKUPS

Without check availability, check access- the restore, recovery is successful without issues.

Please let us know why this check availability or check access fails/timeouts from HANA Studio in Azure Native backup using recovery vault.

We use Private End Points to access Azure recovery service vault.

SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-08T14:31:17.65+00:00

Hello @Patil, Prafulla B Thank you for reaching out to us on Microsoft Q&A platform. Happy to help!

It looks like restore of HANA database backup on Azure VM is failing.

Can you confirm if backups are running successfully?

If not, check If the registration of the backup extension was completely successful, and there is nothing blocking access to Azure Storage or the other Azure Backup services, the backup should complete successfully.

Source: https://learn.microsoft.com/en-us/azure/backup/backup-azure-sap-hana-database#establish-network-connectivity

If you are using Private Endpoints, please make sure the DNS settings are properly setup as per documentation below:

Source: https://learn.microsoft.com/en-us/azure/backup/private-endpoints#manage-dns-records

Also, suggest you to cross verify the below parameters at the DB level . Reference doc -> About SAP HANA database backup in Azure VMs - Azure Backup | Microsoft Learn

Hope this helps. Let us know how it goes!
Patil, Prafulla B 0 Reputation points

2023-11-08T15:28:05.65+00:00

Response moved to comment section.
Patil, Prafulla B 0 Reputation points

2023-11-08T15:28:59.6666667+00:00

Hi @SadiqhAhmed-MSFT,

Thanks for your response.

We use Azure recovery vault with Private end points.

HANA DB backup config is successful and full, log backup are working properly.

Restore and PIT Recovery is also working only without backup Availability check.

So issue is during Backup Availability check only.

1- During PIT Recovery- Check Availability fails, so I triggered without check and PIT recovery is success.

2- During restore- Check Availability gets timeout , so I triggered without check and restore is success.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-09T14:33:52.47+00:00

@Patil, Prafulla B Not sure, why it is failing with availability check. If this is concerning, you then I would suggest reaching out to Azure technical support team for further assistance.
Patil, Prafulla B 0 Reputation points

2023-11-09T15:05:27.2366667+00:00

Thanks @SadiqhAhmed-MSFT , I have raised case with Azure support.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-09T16:51:22.2633333+00:00

@Patil, Prafulla B Keep us posted if there is any progress.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-13T06:23:23.45+00:00

@Patil, Prafulla B Any update on this?
Patil, Prafulla B 0 Reputation points

2023-11-13T16:32:03.56+00:00
@SadiqhAhmed-MSFT No updates, TrackingID#2311070040013146 is raised for this.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-14T05:34:54.2033333+00:00

@Patil, Prafulla B Thanks for sharing the service request #.

1 answer

Your answer

SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-08T14:31:17.65+00:00

Hello @Patil, Prafulla B Thank you for reaching out to us on Microsoft Q&A platform. Happy to help!

It looks like restore of HANA database backup on Azure VM is failing.

Can you confirm if backups are running successfully?

If not, check If the registration of the backup extension was completely successful, and there is nothing blocking access to Azure Storage or the other Azure Backup services, the backup should complete successfully.

Source: https://learn.microsoft.com/en-us/azure/backup/backup-azure-sap-hana-database#establish-network-connectivity

If you are using Private Endpoints, please make sure the DNS settings are properly setup as per documentation below:

Source: https://learn.microsoft.com/en-us/azure/backup/private-endpoints#manage-dns-records

Also, suggest you to cross verify the below parameters at the DB level . Reference doc -> About SAP HANA database backup in Azure VMs - Azure Backup | Microsoft Learn

Hope this helps. Let us know how it goes!
Patil, Prafulla B 0 Reputation points

2023-11-08T15:28:05.65+00:00

Response moved to comment section.
Patil, Prafulla B 0 Reputation points

2023-11-08T15:28:59.6666667+00:00

Hi @SadiqhAhmed-MSFT,

Thanks for your response.

We use Azure recovery vault with Private end points.

HANA DB backup config is successful and full, log backup are working properly.

Restore and PIT Recovery is also working only without backup Availability check.

So issue is during Backup Availability check only.

1- During PIT Recovery- Check Availability fails, so I triggered without check and PIT recovery is success.

2- During restore- Check Availability gets timeout , so I triggered without check and restore is success.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-09T14:33:52.47+00:00

@Patil, Prafulla B Not sure, why it is failing with availability check. If this is concerning, you then I would suggest reaching out to Azure technical support team for further assistance.
Patil, Prafulla B 0 Reputation points

2023-11-09T15:05:27.2366667+00:00

Thanks @SadiqhAhmed-MSFT , I have raised case with Azure support.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-09T16:51:22.2633333+00:00

@Patil, Prafulla B Keep us posted if there is any progress.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-13T06:23:23.45+00:00

@Patil, Prafulla B Any update on this?
Patil, Prafulla B 0 Reputation points

2023-11-13T16:32:03.56+00:00

@SadiqhAhmed-MSFT No updates, TrackingID#2311070040013146 is raised for this.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-11-14T05:34:54.2033333+00:00

@Patil, Prafulla B Thanks for sharing the service request #.

Answer 1

@Patil, Prafulla B Thank you for your patience and understanding!

As per support team the issue has been resolved. Sharing the solution with broader community! Issue Details:

Symptoms: Check Availability action from native restore was failing while normal restores were succeeding.

Cause: Check Availability was using a different workflow in the extension that was not working with PEs correctly.

Resolution: Product Group fixed issue in next extension release. It took some time for deployment to complete and get confirmation from our customers.

@Patil, Prafulla B Confirmed that, Check Availability ran as expected on 1.0.0.89.

Hope this helps others who might be looking for a solution to similar issues.

If the response helped, do "Accept Answer" and up-vote it

Share via

why HANA backup check availability or check access fails/timeouts from HANA Studio in Azure Native backup using recovery vault.

1 answer

Your answer