topic Reading the same archived redo log over and over in Qlik Replicate

Reading the same archived redo log over and over

MoeE — Tue, 21 May 2024 23:49:03 GMT

Hi,

We've noticed that Replicate reads from the same archived redo log file every couple minutes. Does anyone know if this is normal behaviour by Replicate? The task does have high latency.

I did some other searches in task logs that don't have latency and found that they had multiple reads on the online redo logs on different dates and times.

So basically I just want to know if this is normal behaviour, and get a general idea of what is going on. It would be greatly appreciated. Thank you.

Regards,

Mohammed

Re: Reading the same archived redo log over and over

SushilKumar — Wed, 22 May 2024 01:03:42 GMT

Hello @MoeE

Thanks for reaching out to Qlik via Qlik Community Support portal.

Seems there may other associated along with it . You need to put Source_Capture to verbose to check why it QR is reading same Archive log again and again . Check for some disconnection and Timeout happen for participating Source endpoint.

Would request engage Support Via case as Such issue require through analysis of Settings, hence request you to reach out to technical Support via a case and provide Diagnostics package.

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/1815056

Regards,

Sushil Kumar

Re: Reading the same archived redo log over and over

Heinvandenheuvel — Wed, 22 May 2024 04:22:16 GMT

yeah, you probably need a support case. Be sure to provide all version information:

Replicate, Oracle source db

you probably also nee to provide all or select from v$archived_log around the 'stuck' redo log. It is really odd for it to read archive-log first, then redo. That should be the other way around

select name, SEQUENCE#, thread#, first_change# from v$archived_log where SEQUENCE# > X - 10 and SEQUENCE# < X + 10