添加日志列表

我这是添加了5.11日上午9点-11点之间归档的日志
（如果是在线日志，可以考虑先归档）

exec dbms_logmnr.add_logfile(logfilename=>'/oraarch/1_474_902256601.dbf',options=>dbms_logmnr.new);

启动LogMiner

exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

查看对某张表的操作：

select timestamp,sql_redo from v$logmnr_contents where seg_name='LCM_USERS';

2016-05-11 10:50:25
update "LCM"."LCM_USERS" set "PASSWORD" = 'TEpp7ZH8ne9', "DISABLED" = '0', "ROLE_NUM" = '201', "CSWAP_NUM" = '10', "NODE_GROUP_NAME" = 'ICBH'

where "PASSWORD" = 'o4\9\F[nsXI' and "DISABLED" = '0' and "ROLE_NUM" = '201' and "CSWAP_NUM" = '10' and "NODE_GROUP_NAME" = 'ICBH' and ROWID =

'AAADrjAAEAAAb1MAAk';

2016-05-11 10:50:25
update "LCM"."LCM_USERS" set "PASSWORD" = 'TEpp7ZH8ne9', "DISABLED" = '0', "ROLE_NUM" = '201', "CSWAP_NUM" = '10', "NODE_GROUP_NAME" = 'ICBH'

where "PASSWORD" = 'TEpp7ZH8ne9' and "DISABLED" = '0' and "ROLE_NUM" = '201' and "CSWAP_NUM" = '10' and "NODE_GROUP_NAME" = 'ICBH' and ROWID =

'AAADrjAAEAAAb1MAAk';

2016-05-11 10:55:55
update "LCM"."LCM_USERS" set "PASSWORD" = 'TEpp7ZH8ne9', "DISABLED" = '0', "ROLE_NUM" = '201', "CSWAP_NUM" = '10', "NODE_GROUP_NAME" = 'ABCI'

where "PASSWORD" = 'TEpp7ZH8ne9' and "DISABLED" = '0' and "ROLE_NUM" = '201' and "CSWAP_NUM" = '10' and "NODE_GROUP_NAME" = 'ABCI' and ROWID =

'AAADrjAAEAAAAi/AAL';

关闭LogMiner

exec dbms_logmnr.end_logmnr();

ITPub博客

LogMiner 简单一例

最新文章