Restore operation fails for the Active/Active SAP HANA replication setup that has a custom-created hdbuserstore key

Article ID: 67789

Article Type: Troubleshooting

Last Modified:

Performing a restore operation for the Active/Active replication setup in a tenant database that has a custom-created hdbuserstore key produces an error.

Symptoms

A restore operation for the Active/Active replication setup fails with the following error:

CvProcess::system() - /usr/sap/DAB/HDB02/exe/hdbsql   -t -U CVBACKUP -d SYSTEMDB -C "ALTER SYSTEM STOP DATABASE DAB IMMEDIATE" | tee -a /opt/commvault2/iDataAgent/jobResults/CV_JobResults/2/0/1241934/restore.out 2>&1 CvProcess::system() - Command completed with rc=0 ClHanaAgent::StopTheTenant() - ALTER SYSTEM STOP DATABASE - Failed to stop the Tenant database [DAB]. Please try to stop manually and resume the job. Sending FAILED complete message to JM, 1241934 ClHanaAgent::StopTheTenant() - ALTER SYSTEM STOP DATABASE - Failed to stop the Tenant database [DAB]. Please try to stop manually and resume the job..

In HANA, run the following command on SYSTEMDB:

dabadm@sde-sslhana2:/usr/sap/DAB/HDB02/exe/python_support> hdbsql   -t -U CVBACKUP -d SYSTEMDB -C "ALTER SYSTEM STOP DATABASE DAB IMMEDIATE" * 7: feature not supported: writable statement not allowed in read-enabled replication: line 1 col 1 (at pos 0) SQLSTATE: HY000

Causes

A restore operation for the Active/Active replication setup that is in a tenant database produces an error because the node order is incorrect in the hdbuserstore key.

Resolution

Set the nodes in correct order in the custom-created hdbuserstore key.

Example
The following example is the output for ‘hdbnsutil -sr_state’ that has sde-sslhana1 as primary site and sde-sslhana2 as secondary site.

Host Mappings:

~~~~~~~~~~~~~~
sde-sslhana1 -> [DABSTAN] sde-sslhana2
sde-sslhana1 -> [DBPRIM] sde-sslhana1

Site Mappings:
~~~~~~~~~~~~~~
DBPRIM (primary/primary)
    |---DABSTAN (syncmem/logreplay_readaccess)

Tier of DBPRIM: 1
Tier of DABSTAN: 2

Replication mode of DBPRIM: primary
Replication mode of DABSTAN: syncmem

Operation mode of DBPRIM: primary
Operation mode of DABSTAN: logreplay_readaccess

Mapping: DBPRIM -> DABSTAN
done.

dabadm@sde-sslhana1:/usr/sap/DAB/HDB02/exe/python_support>
hdbuserstore List CVBACKUP

KEY CVBACKUP
  ENV : sde-sslhana2:30213,sde-sslhana2:30215,sde-slhana1:30213,sde-sslhana1:30215
  USER: <DBUserName>

When you run the following command, the order of the nodes for the hdbuserstore key are corrected:

hdbuserstore -i set CVBACKUP sde-sslhana1:30213,sde-sslhana1:30215,sde-sslhana2:30213,sde-sslhana2:30215 <DBUserName> <Password> dabadm@sde-sslhana2:/usr/sap/DAB/HDB02/exe/python_support> hdbsql   -t -U CVBACKUP -d SYSTEMDB -C "ALTER SYSTEM STOP DATABASE DAB IMMEDIATE" 0 rows affected (overall time 13.000803 sec; server time 12.997612 sec) dabadm@sde-sslhana2:/usr/sap/DAB/HDB02/exe/python_support>

1 Commvault Way, Tinton Falls, NJ 07724 Sitemap | Legal Notices | Trademarks | Privacy Policy
Copyright © 2022 Commvault | All Rights Reserved.