Oracle重做日志记录是什么样的？
Oracle重做日志记录是什么样的？我尝试在任何地方都能想到，但找不到任何示例。
它们是人类可读的文本日志吗？ （并直接解析吗？）还是它们很复杂，需要专门的工具才能解析？
当给定的表具有任何更改的列值，新行或删除行时，我对我感兴趣。我可能会写一个AWS lambda功能来处理这些事件 - 假设这是合理的事情。
What do Oracle redo log records look like? I've tried searching everywhere I can think of, and have been unable to find any examples.
Are they text logs that are human readable? (And straightforward to parse?) Or are they complicated and require specialized tools to parse?
I'm interested in when a given set of tables has any changed column values, new rows, or deleted rows. I would likely write an aws lambda function to process these events - assuming that's a reasonable thing to do.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我们可以假设您做了Google“ Oracle Redolog internals”还是类似的？
那里有很多信息。
特别是朱利安·戴克（Julian Dyke）（现已退休的）材料总是很棒的：
http://www.juliandyke.com/presentations/presentations/presentations.presentations.php
http://www.juliandyke.com/presentations/presentations/redointernals.ppt
这样一来，应该明确表明这是一项巨大的，错误的任务，可以正确执行和根据“ PMDBA”的支持多年，
有几种商业工具已经完成了这项工作，虽然它们的价格很高，但与建立自己的功能相比，它们通常是“抢断”的。
金门当然是Oracle自己的解决方案。昂贵，最未来的证明。
Logminer解决方案很棒，但这是不弃用的，并且在最近的版本/功能上遇到麻烦
，在其开发和早期部署过程中工作了多年，我对现在的Qlik Replicate非常忠实 - 最初是从Attunity出发的。它为任何数据库（包括云的内容）提供了“任何”源（包括甲骨文），并提供带有简单的UI，可选的JSON描述以及许多性能和功能功能的全负载。有限的，基于SQLLITE函数，可用转换。
祝你好运！
May we assume you did google "Oracle redolog internals" or similar did you?
There is a treasure trove of information out there.
In particular Julian Dyke's (now retired) material are always great:
http://www.juliandyke.com/Presentations/Presentations.php
http://www.juliandyke.com/Presentations/RedoInternals.ppt
Even just glancing over this should make it clear that it is a monumental, error-prone, task to do tis properly and supported for years to come, as per 'pmdba'
There are several commercial tools who have done the work, and while they typically have a big price tag that are a 'steal' compared to building your own except for the most rudimentary functions.
Golden Gate is of course Oracle own solution. Expensive and most future proof.
LOGminer solution were/are great but that is deprecated and will run into trouble with recent versions/features
Personally, having worked for years during its development and early deployment, I am a big fan of what is now Qlik Replicate - originally from Attunity. It offers 'any' source (including Oracle) to any database (including cloud stuff) CDC and full-load with an easy UI, optional JSON descriptions, and a host of performance and functional features. Limited, SQLlite function based, transformations are available.
Good luck!