Logminer简单用法

最新推荐文章于 2024-12-19 19:38:35 发布

Fung

最新推荐文章于 2024-12-19 19:38:35 发布

阅读量247

点赞数

分类专栏： Oracle Utility

Oracle Utility 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了Oracle Logminer的基本使用步骤，包括安装Logminer、创建数据字典、添加日志文件、使用字典分析日志、查看及结束日志挖掘过程等关键操作。

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

Logminer简单用法

1. 安装Logminer

SQL>@?/rdbms/admin/dbmslm.sql
SQL>@?/rdbms/admin/dbmslmd.sql
SQL>@?/rdbms/admin/dbmslms.sql

2. 创建数据字典

SQL> alter system set utl_file_dir='/oradata/lgmnr' scope=spfile;
--restart the instance
-- Create a dictionary file 
--   (init.ora parameter utl_file_dir must be set)
exec dbms_logmnr_d.build('mydictfile', '/oradata/lgmnr');

3. 添加日志

-- Register log files, can be from a different db
--   (NEWFILE=start new list/ ADDFILE=add next file)
exec dbms_logmnr.add_logfile('/arch/1_141_810359695.dbf', dbms_logmnr.new); 
exec dbms_logmnr.add_logfile('/arch/1_142_810359695.dbf', dbms_logmnr.addfile); 
exec dbms_logmnr.add_logfile('/arch/1_143_810359695.dbf', dbms_logmnr.addfile);

4. 使用字典分析日志

-- Start the logminer session
exec dbms_logmnr.start_logmnr(DictFileName => '/oradata/lgmnr/mydictfile');

5. 查看日志

-- Query v_$logmnr_contents view to extract required info
select timestamp, sql_undo
from   sys.v_$logmnr_contents
where  seg_name = 'T';
select operation,sql_redo,sql_undo from v$logmnr_contents where seg_owner='BBED' and seg_name='T' and rownum<=10;

6. 结束日志挖掘

-- Query v_$logmnr_contents view to extract required info
select timestamp, sql_undo
from   sys.v_$logmnr_contents
where  seg_name = 'T';
select operation,sql_redo,sql_undo from v$logmnr_contents where seg_owner='BBED' and seg_name='T' and rownum<=10;