LogMiner脚本

最新推荐文章于 2021-02-28 18:42:27 发布

Perry705

最新推荐文章于 2021-02-28 18:42:27 发布

阅读量357

点赞数

分类专栏： ORACLE_LogMiner

本文链接：https://blog.csdn.net/u011616400/article/details/40182181

版权

ORACLE_LogMiner 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

#!/bin/bash

sqlplus / as sysdba << EOF

spool spool.log

execute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.dat',dictionary_location => '/u01/log');

execute dbms_logmnr.add_logfile('/u01/app/oracle/oradata/orcl/redo1.log',DBMS_LOGMNR.new );
execute dbms_logmnr.add_logfile('/u01/app/oracle/oradata/orcl/redo2.log',DBMS_LOGMNR.addfile);
execute dbms_logmnr.add_logfile('/u01/app/oracle/oradata/orcl/redo3.log',DBMS_LOGMNR.addfile);
execute dbms_logmnr.add_logfile('/u01/app/oracle/oradata/orcl/redo4.log',DBMS_LOGMNR.addfile);

select filename from v\$logmnr_logs;

execute dbms_logmnr.start_logmnr(dictfilename => '/u01/log/logminer_dict.dat');

SELECT sql_redo FROM v\$logmnr_contents where username='EISOO' and operation IN ('DDL','UPDATE','DELETE','INSERT','DIRECT INSERT') and seg_owner not in ('SYS','SYSTEM');

spool off

quit

EOF