Oracle Logminer程序实现

2024-04-02 19:04:59 367人浏览薄情痞子

摘要

Logminer是oracle分析重做日志的工具，可以把日志中的信息还原成执行过的sql语句。Oracle的日志格式一直是不传之密，要理解日志的结构和存储格式才能从中提取有用的数据，还原用户操作。最近通过深

Logminer是oracle分析重做日志的工具，可以把日志中的信息还原成执行过的sql语句。Oracle的日志格式一直是不传之密，要理解日志的结构和存储格式才能从中提取有用的数据，还原用户操作。最近通过深入研究，搞清楚了Oracle重做日志的存储结构，用C语言编写了一个模拟Logminer的程序。
如果想看源代码和文档，请访问www.tomcoding.com

您可能感兴趣的文档:

点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: Oracle Logminer程序实现

本文链接: https://www.lsjlt.com/news/43485.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档

去做题

猜你喜欢

Oracle Logminer程序实现

Logminer是Oracle分析重做日志的工具，可以把日志中的信息还原成执行过的SQL语句。Oracle的日志格式一直是不传之密，要理解日志的结构和存储格式才能从中提取有用的数据，还原用户操作。最近通过深...

99+

2022-10-18
通过LogMiner实现Oracle数据库同步迁移

目录通过LogMiner实现Oracle数据同步迁移一、实现过程1.创建目录2.配置LogMiner3.开启日志追加模式4.重启数据库5.创建数据同步用户6.创建数据字典7.加入需要...

99+

2022-11-12
ORA-01353: existing Logminer session ORACLE 报错故障修复远程处理

文档解释 ORA-01353: existing Logminer session Cause: An attempt was made to execute DBMS_LOGMNR_D.SET_TABLESPACE while a Log...

99+

2023-11-04

报错故障 existing
ORA-01280: Fatal LogMiner error. ORACLE 报错故障修复远程处理

文档解释 ORA-01280: Fatal LogMiner error. Cause: An internal error occurred inside LogMiner. Action: Check the alert log and...

99+

2023-11-04

报错故障 Fatal
ORA-01344: LogMiner coordinator already attached ORACLE 报错故障修复远程处理

文档解释 ORA-01344: LogMiner coordinator already attached Cause: A coordinator process is already attached to the specified ...

99+

2023-11-05

报错故障 LogMiner
ORA-01341: LogMiner out-of-memory ORACLE 报错故障修复远程处理

文档解释 ORA-01341: LogMiner out-of-memory Cause: The LogMiner session requires more system resources than is currently avai...

99+

2023-11-05

报错故障 ORA
ORA-01320: Invalid Logminer dictionar attribute ORACLE 报错故障修复远程处理

文档解释 ORA-01320: Invalid Logminer dictionar attribute Cause: A Logminer dictionary attribute was supplied which is invali...

99+

2023-11-05

报错故障 Invalid
ORA-01332: internal Logminer Dictionary error ORACLE 报错故障修复远程处理

文档解释 ORA-01332: internal Logminer Dictionary error Cause: Unexpected error condition Action: Check trace and/or alert lo...

99+

2023-11-04

报错故障 internal
ORA-01319: Invalid Logminer session attribute ORACLE 报错故障修复远程处理

文档解释 ORA-01319: Invalid Logminer session attribute Cause: A session attribute was supplied which is invalid. Action: Re-...

99+

2023-11-04

报错故障 Invalid
ORA-01356: active logminer sessions found ORACLE 报错故障修复远程处理

文档解释 ORA-01356: active logminer sessions found Cause: Logminer sessions are currently active. Action: End all logminer s...

99+

2023-11-05

报错故障 active
ORA-01355: logminer tablespace change in progress ORACLE 报错故障修复远程处理

文档解释 ORA-01355: logminer tablespace change in progress Cause: The tables used by logminer are in the process of being mo...

99+

2023-11-05

报错故障 logminer
ORA-31479: could not create LogMiner session ORACLE 报错故障修复远程处理

文档解释 ORA-31479: could not create LogMiner session Cause: Failure during create of a new LogMiner session while advancing...

99+

2023-11-05

报错故障 create
ORA-01371: Complete LogMiner dictionary not found ORACLE 报错故障修复远程处理

文档解释 ORA-01371: Complete LogMiner dictionary not found Cause: One or more log files containing the LogMiner dictionary w...

99+

2023-11-05

报错故障 Complete
ORA-23653: LogMiner session does not exist ORACLE 报错故障修复远程处理

文档解释 ORA-23653: LogMiner session does not exist Cause: LogMiner session did not exist. Action: Make sure the Capture pro...

99+

2023-11-05

报错故障 LogMiner
ORA-01372: Insufficient processes for specified LogMiner operation ORACLE 报错故障修复远程处理

文档解释 ORA-01372: Insufficient processes for specified LogMiner operation Cause: The number of processes requested by the ...

99+

2023-11-04

报错故障 Insufficient
ORA-16083: LogMiner session has not been created ORACLE 报错故障修复远程处理

文档解释 ORA-16083: LogMiner session has not been created Cause: Logical standby apply engine was started without creating a...

99+

2023-11-05

报错故障 LogMiner
ORA-31490: could not attach to LogMiner session ORACLE 报错故障修复远程处理

文档解释 ORA-31490: could not attach to LogMiner session Cause: Failure during attach to a LogMiner session while advancing ...

99+

2023-11-05

报错故障 attach
ORA-01316: Already attached to a Logminer session ORACLE 报错故障修复远程处理

文档解释 ORA-01316: Already attached to a Logminer session Cause: A Logminer attach session was issued while already attache...

99+

2023-11-05

报错故障 attached
ORA-01345: Must be a LogMiner coordinator process ORACLE 报错故障修复远程处理

文档解释 ORA-01345: Must be a LogMiner coordinator process Cause: A LogMiner client attempted to perform a privileged operat...

99+

2023-11-05

报错故障 LogMiner
ORA-01343: LogMiner encountered corruption in the logstream ORACLE 报错故障修复远程处理

文档解释 ORA-01343: LogMiner encountered corruption in the logstream Cause: Log file is missing a range of scn values. Actio...

99+

2023-11-05

报错故障 LogMiner