注册

查看日志挖掘的内容显示0行

董小姐 2023/11/27 881 8 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:```language

Server[LOCALHOST:5237]:mode is normal, state is open
login used time : 3.500(ms)
disql V8
SQL> select name,type,value from v$parameter where name='RLOG_APPEND_LOGIC';

LINEID name TYPE VALUE


1 RLOG_APPEND_LOGIC SYS 1

used time: 7.578(ms). Execute id is 501.
SQL> SP_CREATE_SYSTEM_PACKAGES(1,'DBMS_LOGMNR');
DMSQL executed successfully
used time: 35.313(ms). Execute id is 502.
SQL> SELECT NAME,FIRST_TIME,NEXT_TIME,FIRST_CHANGE#,NEXT_CHANGE# FROM V$ARCHIVED_LOG;

LINEID NAME FIRST_TIME NEXT_TIME FIRST_CHANGE# NEXT_CHANGE#


1 /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-27_15-01-03.log 2023-11-27 15:01:03.308538 2023-11-27 15:01:09.879905 43642 43811
2 /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-27_15-03-50.log 2023-11-27 15:03:50.546191 2023-11-27 15:07:40.057701 43811 43911
3 /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-27_15-09-50.log 2023-11-27 15:09:50.453509 2023-11-27 15:12:28.425398 43911 44075
4 /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-27_15-12-33.log 2023-11-27 15:12:33.345091 2023-11-27 15:12:33.345091 44076 44409

used time: 1.463(ms). Execute id is 503.
SQL> DBMS_LOGMNR.ADD_LOGFILE('/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-27_15-12-33.log');
DMSQL executed successfully
used time: 6.153(ms). Execute id is 504.
SQL> SELECT LOW_SCN, NEXT_SCN, LOW_TIME, HIGH_TIME, LOG_ID, FILENAME FROM V$LOGMNR_LOGS;

LINEID LOW_SCN NEXT_SCN LOW_TIME HIGH_TIME LOG_ID


       FILENAME                                                           
       -------------------------------------------------------------------

1 44076 44409 2023-11-27 15:12:31.000000 2023-11-27 15:12:31.000000 0
/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-27_15-12-33.log

used time: 1.322(ms). Execute id is 505.
SQL> DBMS_LOGMNR.START_LOGMNR(OPTIONS=>2128,STARTTIME=>TO_DATE('2023-11-27 11:57:36','YYYY-MM-DD HH24:MI:SS'),ENDTIME=>TO_DATE('2023-11-27 15:15:03','YYYY-MM-DD HH24:MI:SS'));
DMSQL executed successfully
used time: 129.257(ms). Execute id is 506.
SQL> select TIMESTAMP,START_TIMESTAMP,COMMIT_TIMESTAMP,OPERATION,OPERATION_CODE,ROLL_BACK,TABLE_NAME,ROW_ID,USERNAME,DATA_OBJ#,DATA_OBJV#,SQL_REDO,REDO_VALUE,UNDO_VALUE
from V$LOGMNR_CONTENTS
where table_name='PERSON_TYPE';2 3
no rows

used time: 1.078(ms). Execute id is 507.

是不是只有开启归档、启用记录逻辑操作功能之后的操作才能被挖掘到?
回答 0
暂无回答
扫一扫
联系客服