为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8.1
【操作系统】:windows 10
【CPU】: amd 7600x
【问题描述】*:做了导出导入以后,解析到的sqlRedo里边 表名和字段名全是OBJ#123123, COL1, COL2这种,为什么会出现这种情况。
sqlRedo 样例:INSERT INTO "OBJ# 150995944"."OBJ# 1025"("COL 1", "COL 2", "COL 3", "COL 4", "COL 5", "COL 6", "COL 7", "COL 8", "COL 9") VALUES(1847098979746070529, 1990992714431174478, 0.1953, 0.7449, DATE'2024-09-23', 131672994, 1354658109, 698368249, TIMESTAMP'2024-10-18 10:14:48.869');
正确的应该是 PRODUCTION.PRODUCT(PRORUCT_ID...)...
测试建议:DBMS_LOGMNR只支持对归档日志进行分析,需要配置归档信息和开启RLOG_APPEND_LOGIC参数;建议在1:1测试环境测试数据进行(生产环境慎用)。参考步骤如下,具体说明见官方文档:
alter system set 'RLOG_APPEND_LOGIC'=1 MEMORY;
DBMS_LOGMNR.ADD_LOGFILE('/dat/arch/ARCHIVE_LOCAL1_20240606232724328810_0.log');
DBMS_LOGMNR.START_LOGMNR(OPTIONS=>2048);
select count() from V$LOGMNR_CONTENTS where operation='UPDATE';
select count() from V$LOGMNR_CONTENTS where operation='UPDATE' and "V$LOGMNR_CONTENTS".SQL_REDO like '%1271%';
select ID from sysobjects where name like '%XXXXX_DATA_20240525%'; --1271
select count(*) from V$LOGMNR_CONTENTS where operation='UPDATE' and "V$LOGMNR_CONTENTS".TABLE_NAME='XXXXX_SCADA_20240525';
DBMS_LOGMNR.END_LOGMNR();