Bug: In online mode, the archived logs cannot be queried, causing the program to endlessly search for the archived log path

[hj2016]

I start the task in online mode to recover from a checkpoint, and there are many archived log files missing in between. After starting, it keeps querying the database for archived log files, but since it can't find them, it gets stuck in an infinite loop without progressing forward. I have identified some issues with the archived log query statement because the condition IS_RECOVERY_DEST_FILE = 'NO' is being filtered out. "After modifying IS_RECOVERY_DEST_FILE = 'YES', it can be queried successfully." But information from the DG database is also being queried, which is another issue I've identified here. After making this modification, there are no issues, and the missing data in between has been captured.

[hj2016]

Perhaps I can submit a pull request for you?

[bersler]

Hi @hj2016 , thank you for submitting this issue. I am currently on vacation. I will take a look next week when I am back.

[hj2016]

Is my thinking correct here, do I need to submit a PR to fix the problem?

[bersler]

Hi @hj2016 , the problem is not the fix. The problem is to create a reproduction of the issue to actually verify it. Please provide a reproduction of the fault:

1. take docker image for OLR + Oracle (preferred: https://github.com/bersler/OpenLogReplicator-tutorials so that the fault can be reproduced on Oracle XE)
2. set configuration of OLR to ... (preferred: json file)
3. run some SQL commands, restart, whatever else
4. achieve fault

or alternatively for other errors:

1. OLR configuration file
2. OLR checkpoint file set
3. set of redo log files which contain error
4. achieve fault

[bersler]

I still am unable to reproduce the issue, I plan to close this issue if nothing changes till end of may.

[bersler]

Unable to reproduce the issue, closed.