I am facing a problem with Oracle GoldenGate. We are in the process of migrating few databases which are from 3TB to 10TB.
Now the problem is while replicating, indexes are getting unusable at destination and we need to rebuild them to optimise update and delete but some indexes are of size around 300GB to 500GB and to rebuild them 5-6 hours are required with replication stop and by doing this LAG at destination continuously increasing.
Is there any way overcome this problem?
Thanks in advance.