oracle 10g logminer

最新推荐文章于 2024-09-15 08:03:51 发布

congxiejiao6058

最新推荐文章于 2024-09-15 08:03:51 发布

阅读量68

点赞数

文章标签：数据库

以session为操作单位

1. 设置logminer使用的目录

conn / as sysdba

alter system set utl_file_dir='/u02/arch/hkeudm' scope=spfile;

shutdown immediate

startup

2. 生成 logminer package

conn / as sysdba

@?/rdbms/admin/dbmslm.sql

@?/rdbms/admin/dbmslmd.sql

3. 生成 logminer file

execute dbms_logmnr_d.build('logminer.ora','/u02/arch/hkeudm');

4. 将要分析的日志文件加入要分析的log list中

execute dbms_logmnr.add_logfile('/u02/oradata/hkeudm/redo04.log',dbms_logmnr.new);
execute dbms_logmnr.add_logfile('/u02/oradata/hkeudm/redo05.log',dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile('/u02/oradata/hkeudm/redo06.log',dbms_logmnr.addfile);

　如果需要从分析列表里去掉一个文件用

execute dbms_logmnr.remove_logfile('/u02/oradata/hkeudm/redo06.log');

5. 查询分析的日志文件包含的scn范围和日期范围。

set lines 220

column low_scn format 9999999999

column next_scn format 9999999999

column filename format a50

select log_id,low_time,high_time,low_scn,next_scn,FILENAME from v$logmnr_logs;

6. 执行分析:

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

execute dbms_logmnr.start_logmnr (dictfilename=> '/u02/arch/hkeudm/logminer.ora', startscn=> 11244354, endscn=> 11294833, starttime => to_date('2008-04-10 10:28:02','yyyy-mm-dd hh24:mi:ss'), endtime => to_date('2008-04-10 13:28:02','yyyy-mm-dd hh24:mi:ss') );

7. 查看redo sql

Select SCN,timestamp, session# session_num,sql_redo From V$LOGMNR_CONTENTS where username='HKEU_DATA' -- Order by 1

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

转载于:http://blog.itpub.net/15843490/viewspace-582511/