> Back to the basics. How can we avoid this kind of situation.
>
> Places are 24/7 and we don't know when those places have breaks to make
> backup/restore.

Your database was created near 2 years ago. I.e. your application generated
2147483646 transactions in less than 800 days. Or more than 2.6 mln tx per day,
or more than 111K tx per hour, or almost 2K tx per minute. How do you create
such load ? Are you really need such crazy amount of transactions ? Think about
it, improve your application and forget about the issue.

> So how can we reset transaction counters without use backup/restore.

No direct way.

Regards,
Vlad