ITPub博客

首页 > Linux操作系统 > Linux操作系统 > logminer例

logminer例

原创 Linux操作系统 作者:guo_li_yuan 时间:2008-05-14 11:00:32 0 删除 编辑
参考文档:
主题: How to Recover from delete on a table using 10g logminer (by example)?
  文档 ID: 注释:390537.1 类型: HOWTO
  上次修订日期: 02-JAN-2008 状态: PUBLISHED


In 10g when you are using the LogMiner against the same database that generated the
redo log files, LogMiner scans the control file and determines the redo log files needed, based
on the requested time or SCN range.  You no longer need to map the time frame. to an explicit set of redo log files.
For this scan to occur, we need to use the continuous_mine option and specify approximate startscn
or starttime.
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

Session altered.

SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR( STARTTIME => '06-SEP-2006 23:19:22', ENDTIME => '06-SEP-2006 23:20:22',options=> DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG +DBMS_LOGMNR.CONTINUOUS_MINE);

SQL> set heading off      结果文件中

insert into "SCOTT"."TAB1"("ID","NAME") values ('43','test43');                
insert into "SCOTT"."TAB1"("ID","NAME") values ('44','test44');                

SQL_UNDO                                                                       
--------------------------------------------------------------------------------  会不显示出来

insert into "SCOTT"."TAB1"("ID","NAME") values ('45','test45'); 



SQL> Set feedback off

SQL> begin
  2  for i in 1..100 loop
  3  insert into TAB1 values(i,'test'||i);
  4  commit;
  5  end loop;
  6  end;
  7  /
PL/SQL 过程已成功完成。  会不显示


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

下一篇: sap资料相关
请登录后发表评论 登录
全部评论

注册时间:2008-01-04

  • 博文量
    11
  • 访问量
    18399