Re: verification of replication (Golden Gate)

GoldenGate has a few options that you can use. Questions that needs to be asked is “what is golden gate going to be used for”? Is your setup going to be oracle-to-oracle or oracle-to-heterogeinous database? Oracle-to-Oracle, is it going to be classic replication or integrated?

In either case, the base monitoring should be done using the logs available, ggserr.log, discard files, and report files. Then you can enhance the information in these files by using the LAG parameters in the Manager process. The REPORTCOUNT parameter in the parameter files will give you runtime statistics.

If you are using integrated replication for oracle-to-oracle, you then get access to lots of views that can be used to diagnose runtime apply and capture issues.

Lastly, you can use the AWR tools with the integrated process, but this requires you to be on DB 12c (12.1.0.1).

Enjoy!

Bobby

> On Oct 10, 2016, at 11:16 PM, Purav Chovatia <puravc_at_gmail.com> wrote:
>
> Hi Vijay, you can additionally check for discard file and the report file. However those files give additional info about an error in replication. If an err has occurred (process failure or trxn/replication failure) it will be logged in the ggserr.log.
>
> If you have an exception table to log conflicts then that is where you may check additionally.
>
> HTH
>
>
> On 11 Oct 2016 08:30, "vijayrsehgal" <vijaysehgal21_at_gmail.com <mailto:vijaysehgal21_at_gmail.com>> wrote:
> Dear Experts,
>
> This will be the first time we will be using Golden Gate for replicating data, in your experience other than going through the logs what else should we be monitoring to verify that data is being replicated without any issues. Any steps/suggestions/reads to proactively avoid problems of replication more than welcome.
>
> I am not doubting GG, but it's good to have processes in place :).
>
>
> Regards,
> Vijay Sehgal

--
http://www.freelists.org/webpage/oracle-l