logminer例

最新推荐文章于 2024-07-12 16:56:26 发布

congguaiyt12098

最新推荐文章于 2024-07-12 16:56:26 发布

阅读量75

点赞数

文章标签：数据库

参考文档：

主题:	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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/377444/viewspace-266462/