cancel
Showing results for 
Search instead for 
Did you mean: 

Fetching Backup Catalog SAP DBTech JDBC invalid argument file access error

05-29-2020 8:44 PM
ken_halvorsen2 Active Participant
3781 views 2 comments
0 Likes
SAP Managed Tags
Subscribe

I'm trying to Restore a tenant from a backup of another tenant in an SAP HANA 2.0 SPS3 system using HANA Studio.

But I get the "Fetching Backup Catalog... has encounter a problem" error. It reads: com.sap.ndb.studion.backup.wizard.recovery.StartegyOutputException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [8]: invalid argument: file access error: /usr/sap/<sid>/HDB01/<server_name>/trace/strategyOutput.xml:2 (No such file or directory).

I have found several SAP Notes, including 2762503, setting the catalog_backup_ising_backint parameter to true.

To recreate this error, From the SYSTEMDB@<SID> (SYSTEM) right click and select Backup and Recovery -> Recover Tenant Database... Then Select the target <sid>, then Recover the database to a specific data backup. Then select Backint System Copy and enter the Source System <source SID>@<SID>. It Stops the target database. Searches for and errors with the above error message.

What am I missing? I believe it should find the Backup Catalog and we then pick the backup to be restored back to.

As a second purpose, after I can get the test restore from the same database, I want to be able to search and find the production system backups to be able to restore from in a DRP situation.

Thank you for your help

Ken

0 Likes

Accepted Solutions (0)

Answers (2)

Answers (2)

sumitjais
Active Contributor

Hi Ken,

You went through correct note 2762503.

Did you set catalog_backup_using_backint = true ( in source system) after the issue? If so, trigger a new backup at source and try to recover it at target (as the old source backups don't have catalog backedup).

catalog_backup_using_backint allows the catalog to be backed up i.e, required to read the particular backup. Ensure that in source system , the value for catalog_backup_using_backint is 'true 'and the catalogs are backedup at the path global.ini/[persistence]/basepath_catalogbackup

If the issue continues, please provide the values of Source system for below parameters

  1. global.ini/[persistence]/basepath_catalogbackup
  2. global.ini/[persistence]/basepath_logbackup
bruno_geovane
Discoverer
0 Likes

Hello ken.halvorsen01

I am exactly with the same problem... did you solve it?

Thanks