abnormal behavior in batch mode about openlogreplicator HOT 5 OPEN

Hi @AidenPTHuang , yes, you can do something. You can for example make donation to the author to increase the priority for the fix.

from openlogreplicator.

Hi,
I'm still encountering this issue.
Is there any step I can do for the error "ERROR 50023 duplicate SYS.COL$ value: (rowid: AAAAACAABAAAACRAAl)"?
Or do you know the meaning of ERROR 50023??

from openlogreplicator.

Hi @AidenPTHuang , I have divided the topic of slow reading/writing of checkpoint files as a separate inc.

Regarding the batch mode. What I understand is that you want to get some redo log file.
Process it batch mode. And then replace the redo log file and run again in batch or online mode.
Thus would not work.

I have made a branch with documentation update.
I have put there information about such operation.
https://github.com/bersler/OpenLogReplicator/tree/batch_mode_warnings

Generally batch mode is just for single use. Prepare some config, run it and done. Whatever checkpoint files are created, they are not suitable for any other work.

If you want to have continuous replication, you should use the online of offline mode.

Running per redo log as batch is not working. First of all, if you create a batch for every redo log files, you would not process transactions which span multiple redo log files. The would just be ignored.

For batch mode, you have just some redo log files, some checkpoint which might not necessarily match the actual schema for start of the redo log and you want just to get maximum of the redo log files you can. And then stop work.

If you want to next use online or offline - you need to prepare a new config. For online or offline mode you need to delete the checkpoint files and recreate it, and reposition the start of replication.

What you might want to use is just offline mode.

If the current features for replication modes are not enough - please describe your environment and how you would like to use OLR.

Regards,
Adam

from openlogreplicator.

Hi Adam

In my environment, my application can't access Oracle online redo logs, but can connect to Oracle database and get archived redo logs from a shared storage. I've tried to use online and offline mode, but failed to start OLR because of online redo logs path not found. So I used Batch mode to run, and got error as I mention above in few redo logs.

from openlogreplicator.

Hi @AidenPTHuang ,
What you want to do is to run OLR in offline mode and use option 'flags': 1.
With this setting OLR would not read online redo logs. Just offline. Please check the documentation and try this configuration.

from openlogreplicator.