Transaction Log full in Primary database SAP ASE HADR

[former_member246738]

Dear experts,

We had a situation recently wherein due to a network outage the connection between our BW Production primary database and it's standby database was down for more than a whole day. This led to a transaction log full situation on the primary site and it was not possible to dump the transaction log by any means. I need to know:

1. What is the best remedy in such situations wherein we can atleast dump the transaction log on the primary site for business operations to continue as usual.

2. I know about repagent truncation point. I need to understand what is the quickest way to recover to a point where the transaction log can atleast be dumped.

Regards

[hganga]

Hi, you can try disabling the replication between sites (RMA command sap_disable_replication), that would be freed the transaction log, but you will need to enabling again and rematerialize the secondary DB to restablish the replication.

Best regards.