ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 再次用dbms_logmnr查到人为删除数据

再次用dbms_logmnr查到人为删除数据

原创 Linux操作系统 作者:victor1010 时间:2010-03-16 12:29:42 0 删除 编辑

 

 exec sys.dbms_logmnr.add_logfile(LogFileName => 'F:\oracle\arch\aadbd\ARC04814.001',Options =>sys.dbms_logmnr.NEW);

exec sys.dbms_logmnr.add_logfile(LogFileName=>'F:\oracle\arch\aadbd\ARC04815.001');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'F:\oracle\arch\aadbd\ARC04816.001');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'F:\oracle\arch\aadbd\ARC04817.001');

select * from v$logmnr_logs;

 exec sys.dbms_logmnr.start_logmnr(Options => sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
 
 create table t_logmnr tablespace users as select * from v$logmnr_contents;

exec sys.dbms_logmnr.end_logmnr
 
 select t.SCN,
        t.TIMESTAMP,
        t.SEG_OWNER,
        t.OPERATION,
        t.SQL_REDO,
        t.SQL_UNDO
   from v$logmnr_contents t
  where t.SEG_NAME = 'T';

 select * from t_logmnr;


--
 exec sys.dbms_logmnr.add_logfile(LogFileName => '/home/aadbdata1/aadbb/arch/arch_15720.arc',Options =>sys.dbms_logmnr.NEW);
 
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15721.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15722.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15723.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15724.arc');
--
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15737.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15738.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15739.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15740.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15741.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15742.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15743.arc');

exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15760.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15759.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15758.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15757.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15756.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15755.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15754.arc');


--
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15724.arc');exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15725.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15726.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15727.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15728.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15729.arc');


-rw-r-----    1 oracle   dba       104857088 Mar 14 03:09 arch_15760.arc
-rw-r-----    1 oracle   dba       104857088 Mar 13 22:54 arch_15759.arc
-rw-r-----    1 oracle   dba       104857088 Mar 13 21:11 arch_15758.arc
-rw-r-----    1 oracle   dba       104857088 Mar 13 18:47 arch_15757.arc
-rw-r-----    1 oracle   dba       104857088 Mar 13 13:46 arch_15756.arc
-rw-r-----    1 oracle   dba       104857088 Mar 13 08:15 arch_15755.arc
-rw-r-----    1 oracle   dba       104857088 Mar 13 06:07 arch_15754.arc

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

请登录后发表评论 登录
全部评论

注册时间:2008-04-29

  • 博文量
    296
  • 访问量
    626157