LogMiner脚本

#!/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