注册

日志挖掘内容为空

董小姐 2023/11/25 472 0

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:```language
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-25_17-08-09.log 2023-11-25 17:08:09.609930 2023-11-25 17:08:17.737800 89330 89507
2 /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-25_17-10-55.log 2023-11-25 17:10:55.151152 2023-11-25 17:10:55.151152 89507 89714

used time: 0.637(ms). Execute id is 2914.
SQL> DBMS_LOGMNR.ADD_LOGFILE('/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-25_17-10-55.log');
DMSQL executed successfully
used time: 0.570(ms). Execute id is 2915.
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 89507 89714 1900-01-01 00:00:00.000000 1900-01-01 00:00:00.000000 0 /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-25_17-10-55.log

used time: 0.651(ms). Execute id is 2916.
SQL> DBMS_LOGMNR.START_LOGMNR(OPTIONS=>2128,STARTTIME=>TO_DATE('2023-11-25 09:10:55','YYYY-MM-DD HH24:MI:SS'),ENDTIME=>TO_DATE('2023-11-25 17:10:55','YYYY-MM-DD HH24:MI:SS'));
DMSQL executed successfully
used time: 17.466(ms). Execute id is 2917.
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_CONTENTS2 ;
no rows

used time: 0.679(ms). Execute id is 2918.
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;
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_CONT;
[-2106]:Error in line: 2
Invalid table or view name [V$LOGMNR_CONT].
used time: 0.355(ms). Execute id is 0.
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='TEST';
4
5 /
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

[-4104]:Error in line: 4
Expression used as query condition.
used time: 0.623(ms). Execute id is 0.
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='TEST';2
no rows

used time: 0.907(ms). Execute id is 2919.

SQL> select * from test;

LINEID id


1 1
2 1

used time: 0.600(ms). Execute id is 2920.

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