Reading the same archived redo log over and over

[MoeyE]

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

[SushilKumar]

Hello @MoeyE 

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/...

Regards,

Sushil Kumar

[Heinvandenheuvel]

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