利用LogMiner分析Oracle日志文件

Analysis of Oracle Log Files Using LogMiner Application

LogMiner是Oracle8i以后版本提供的日志文件分析工具,利用它可以提取Oracle数据库日志的内容,获取重做和回滚SQL语句,执行数据更改的事后审计。以"医院信息系统"相关业务为例,简要介绍如何利用强大的LogMiner工具分析Oracle数据库日志,实现对数据库操作的审查和回退。

LogMiner application is usually used to analyze log files of Oracle 8i database. By using LogMiner, pigeonhole log files can be easily picked up from Oracle database, the SQL sentences of redo & return can be got, and the transaction of can be upgrade database also audited. This paper is based on the example of Hospital Information System. The LogMiner application not only is used to analyze the log files of Oracle database, also to perform the transaction auditions and rollback operations.