oracle9i 中使用 logmnr-优快云博客

本文详细介绍如何使用Oracle LogMiner工具进行归档日志分析，包括准备工作、配置字典文件、添加归档日志文件及启动分析过程。通过具体步骤展示如何查询归档日志中的DDL操作和特定表的DELETE操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[准备]
1.Package file
@oracle_home/rdbms/admin/dbmslmd.sql

2.Dictionary file build
.initSID.ora file change
utl_file_dir = /oracle/logs
[logmnr]
1.dic.ora 文件生成
execute dbms_logmnr_d.build(dictionary_filename=>'dict.ora',dictionary_location=>'/oracle/ANT/data4/logmnr');

2.添加需要使用的log文件
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/ANT/arch/archANT161.log', options=>dbms_logmnr.new);
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/ANT/arch/archANT162.log', options=>dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/ANT/arch/archANT163.log', options=>dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename=>'/oracle/ANT/arch/archANT160.log', options=>dbms_logmnr.addfile);
3.开始进行分析
execute dbms_logmnr.start_logmnr(DictFileName=>'/oracle/ANT/data4/logmnr/dict.ora');

select username ,operation,sql_redo
from v＄logmnr_contents
where operation='DDL'

SELECT SEG_OWNER,SEG_NAME,OPERATION,TO_CHAR(TIMESTAMP,'YYYY/MM/DD HH24:MI:SS')"TIME"
SQL_REDO,SQL_UNDO
FROM V＄LOGMNR_CONTENTS
WHERE SEG_OWNER='SAHRIS'
AND SEG_NAME = 'KAOKE'
AND OPERATION='DELETE'

select sql_undo from v＄logmnr_contents
where SEG_NAME = 'KAOKE'
AND seg_owner='SAHRIS'
AND OPERATION='DELETE'

4.dbms_logmnr.end_logmnrA[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/503782/viewspace-983267/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/503782/viewspace-983267/