Comments (5)
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.
Related Issues (20)
- Feature: create agent to run on database host HOT 3
- Feature: Read redo log files using OCI connection HOT 1
- Bug: Add support for DDL with length > 4k
- OpenLogReplicator with Online mode doesn't work and throws error HOT 3
- Feature: Add support for binary XMLType support on Oracle 23c HOT 1
- Feature: Add custom location for archived redo log files HOT 1
- Bug: The data can be normally parsed, but the downstream cannot retrieve data from the queue. HOT 5
- BUG: CLOB contents are translated to different language even though there is an entry made in English HOT 5
- Grant validation always fails for SyS.CCOL$ HOT 1
- Get the redo record's START_SCN and COMMIT_SCN HOT 4
- Add pseudo ROW_ID for DML-based events. HOT 2
- Include `owner` in DDL changelog of non-table objects HOT 3
- Is support oracle standby database for data guard mode? HOT 2
- Make checkpoint files read/write operations faster
- Occasional, unskippable error: too short field supplemental log: 8 Error HOT 10
- Network stream server crashes if client prematurely disconnects HOT 1
- Feature: Include session information in transaction data HOT 2
- Feature: Add support for Oracle 23c HOT 2
- Bug: In online mode, the archived logs cannot be queried, causing the program to endlessly search for the archived log path HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from openlogreplicator.