Home of OpenLogReplicator
Difficult time has come to my free time that I can spend to write blog posts. It’s high time to update how OLR project is doing. Well, the project is doing fine and had major improvements. This briefly explains new features of the project. Every version apart from bug fixes and stability improvements include new … Read more
I have not blogged about new features of OpenLogReplicator since version 1.0 was released. Now it is time to catch up. Every version apart from bug fixes and stability improvements include new major features: Version 1.5.0 Key feature of this release is the ability to produce metrics directly for Prometheus. The metrics include counters for … Read more
I love situations when the provider of software advertises some feature but does not tell what it really is and how it is implemented. Both Ask Tom and Stackoverflow don’t really tell you what is it really about. Well, in such cases it is best to actually see at some code which is parsing the … Read more
OpenLogReplicator can be fine-tuned over and over. Still something would to be imperfect. Some code might not be optimal and need refactor. Another feature might be recognised as super important and a must-have. This will never end. Still, after over 4 years of fixing bugs and constant development, the time has come to confirm that … Read more
After almost 3 years of development, the project has reached a moment, that most of the features planned for version 1.0 are finished for OpenLogReplicator. So … announcing version 0.9.0-beta. At this point the goal is to make the code stable as possible and fix all reported bugs. If you want to test the code … Read more
Technically speaking support of DDL is trivial. All schema is written in SYS.xxx$ tables. Just what you need to do is to track the changes, and once they appear, rebuild internal dictionaries. Someone adds column to table? Well, you would see an INSERT to SYS.COL$ and maybe some other tables. … A few months later … Read more
The task here is just to run native replication solution directly on Raspberry PI hardware. No emulators, no workarounds, no cheating. Let’s find out what is the redo log processing speed. The key to this approach is using OpenLogReplicator as CDC engine and it’s offline mode. With this mode you can read redo logs without … Read more
The format is proprietary and there is no public official document which would describe the structure. Here is a brief summary of various sources which are publicly available. One might think that there is very little information available, but that’s not true. This is a list I have made in the past when I was … Read more
Every Oracle database user assumes that the output of the logdump command should provide a valid output. During testing of OpenLogReplicator I came across something strange. It appears that the output of OpenLogReplicator logdump mode is better than the original output of Oracle database logdump command. Maybe I am wrong? Let’s create a test scenario … Read more
A side product of OpenLogReplicator is the ability to create logs which are in a very simular form as the logdump command from Oracle database. To create such dump you need to configure parameter in the OpenLogReplicator CFG file. There are 2 allowed values: create classic ‘logdump’ output create classic ‘logdump’ output enhanced with interpretation … Read more