Article ID: 59784
Article Type: Troubleshooting
Last Modified:
The SAP HANA replication system backup jobs fail with an error.
The backups fail with the following error:
/bin/sh /opt/commvault/Base/Temp//hanaBkp_19817 > /opt/commvault/Base/Temp//hanaBkp_19817.out 2>&1
/usr/sap/XYZ/HDB05/exe/hdbsql -t -U BACKUP "backup data for XYZ using backint ('421116_COMPLETE_DATA_BACKUP') TOOLOPTION 'BACKUP -j 421116 -a 2:10066 -t 1 -jt 421116:4:2:0:32808 -data -at 135 -d sde-bigsap.localdomain*sde-bigsap*8400*8402 -vm Instance001 -cn sdehana01'"
* 7: feature not supported: writable statement not allowed in read-enabled replication: line 1 col 1 (at pos 0) SQLSTATE: HY000
Register the replication setup with logreplay as the operationMode.
xyzadm@sdehana01:/usr/sap/XYZ/HDB05> hdbnsutil -sr_register --remoteHost=sdehana02 --remoteInstance=05 --replicationMode=syncmem --name=PRM1 --operationMode=logreplay
xyzadm@sdehana01:/usr/sap/XYZ/HDB05> hdbnsutil -sr_state
Site Mappings:
Tier of SBY1: 1
Tier of PRM1: 2
SBY1 (primary/primary)
|---PRM1 (syncmem/logreplay)