How to check the SAP HANA database recovery when the hana stadio interface can't browse the backup records

Description

When performing SAP HANA restoration, users often encounter the problem that backup records cannot be viewed in HANA stadio interface. Here are several troubleshooting steps for reference:

1. Check whether the master server is to create the following empty file: /usr/openv/netbackup/db/altnames/No.Restrictions

2. Check the utl files from the /usr/openv/netbackup/ext/db_ext/SAP/scripts/sap_oracle directory to create a new file, such as initPRD.utl, only write in this file:

• policy policy_name

Then check whether the policy exists on the Java console interface of the NBU and whether the HANA client host name (including the original and target host names) is added to the client. You can try to set the permission of this file to 777.

3. In the/usr/openv/netbackup/ext/db_ext/SAP/directory create a node_names.txt file

• If it is the original machine, in the file you just fill out the client host name
• If it is different machine, in the first line fill in the original client host name
• The second line is the host name of the target machine, in the correct order, and also sets the permission of this file to 777.

4. Create or check whether the link file /usr/sap/<SID>/SYS/global/hdb/opt/ on the client is created.

# ln -s /usr/openv/netbackup/bin/hdbbackint_script /usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint

5. Double-click the SystemDB corresponding to the instance of the target machine on the Stadio interface to open the Configuration interface

• Find Global.ini >Backup
• Enter the following parameters of the System, Database, and Host options for the following entries:

• data_backup_parameter_file
• log_backup_parameter_file
• Catalog_backup_parameter_file

/usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/initPRD.utl

• You can also set the log_backup_using_backint and catalog_backup_using_backint parameters to true.

6. If the restore is performed on a different machine, check whether the utl file of catalog and log are correctly configured in the Global.ini>Backup in the configuration of the original HANA machine.

• If only the data_backup_parameter_file is configured
• And if log_backup_parameter_file and Catalog_backup_parameter_file parameters are not set

Then the original server may only backup the database, but not the catalog.

• After the utl files used for the catalog and log backups of the original machine are set correctly, a new backup should be initiated and the new catalog backup can be used to restore.
• Without a catalog backup, it is not possible to browse the backup records at recovery time.

7. If it is a different machine, check whether hana's catalog and log are backed up to the original machine's local disk through the file mode

• If so, you need to copy the catalog and log backup of the original machine to the target client

8. If the database is restored from another host, check whether the HANA database version of the original host is the same as that of the target HANA database.

• If they are different, database backup records cannot be accessed.