注册

dbms_logmnr.start_logmnr归档日志分析无结果

天山 2024/01/29 980 2 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM7
【操作系统】:
【CPU】:
【问题描述】*:
select name , first_time , next_time , first_change# , next_change# from
v$archived_log;

dbms_logmnr.add_logfile('/dblog/dmarch/ARCHIVE_LOCAL1_20240126154412490_0.log');
select low_scn, next_scn, low_time, high_time, log_id, filename from v$logmnr_logs;

dbms_logmnr.start_logmnr(Options=>2128 , Starttime=>'2024-01-26 15:44:12.287000' ,Endtime=>'2024-01-26 15:44:21.864000');

select operation_code , scn, sql_redo , timestamp ,seg_owner, table_name from
V$LOGMNR_CONTENTS where seg_owner = 'SYSDBA' and operation_code in (3,1,2);

dbms_logmnr.end_logmnr();
配置文件里的RLOG_APPEND_LOGIC=1
以上执行过程没报错,但是结果是空的!为什么呢?

回答 0
暂无回答
扫一扫
联系客服