注册

归档日志的问题

达梦数据库 2023/10/08 605 0

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8
【操作系统】:Windows 2016
【CPU】:
【问题描述】*:
我创建的测试表结构为:
CREATE TABLE "mytest"."test003"
(
"COLUMN_1" LONGVARCHAR DEFAULT 23,
"COLUMN_2" LONGVARBINARY,
"COLUMN_3" BLOB,
"COLUMN_4" CLOB,
"COLUMN_5" INTERVAL YEAR(4),
"COLUMN_6" INTERVAL YEAR(4) TO MONTH,
"COLUMN_7" INTERVAL MONTH(2),
"COLUMN_8" INTERVAL DAY(2),
"COLUMN_9" INTERVAL DAY(2) TO HOUR,
"COLUMN_10" INTERVAL DAY(4) TO MINUTE,
"COLUMN_11" INTERVAL DAY(2) TO SECOND(6),
"COLUMN_12" INTERVAL HOUR(2),
"COLUMN_13" INTERVAL HOUR(2) TO MINUTE,
"COLUMN_14" INTERVAL HOUR(2) TO SECOND(6),
"COLUMN_15" INTERVAL MINUTE(2),
"COLUMN_16" INTERVAL MINUTE(2) TO SECOND(6),
"COLUMN_17" INTERVAL SECOND(2, 6),
"COLUMN_18" BFILE,
"COLUMN_19" ROWID,
"COLUMN_20" BIGINT IDENTITY(1, 1) NOT NULL,
NOT CLUSTER PRIMARY KEY("COLUMN_20")) STORAGE(ON "MAIN", CLUSTERBTR) ;
然后用DM Manager插入一条记录,除了COLUMN_20之外,每个字段都设置了值,其中BLOB,CLOB等的值都小于1K数据量。当分析用DBMS_LOGMNR获取归档日志的内容的时候,这个对应的SQL_REDO的值相差很大,不是用COUT_BLOB代替的,而是不完整,不是一个完整的SQL语句,是这样的:

INSERT INTO "mytest"."test003"("COLUMN_1", "COLUMN_2", "COLUMN_3", "COLUMN_4", "COLUMN_5", "COLUMN_6", "COLUMN_7", "COLUMN_8", "COLUMN_9", "COLUMN_10", "COLUMN_11", "COLUMN_12", "COLUMN_13", "COLUMN_14", "COLUMN_15", "COLUMN_16", "COLUMN_17", "COLUMN_18", "COLUMN_19", "COLUMN_20") VALUES('DEM部署说明

  1. 创建一个数据库作为DEM后台数据库, 数据库dm.ini参数配置进行优化, 推荐配置:
    MEMORY_POOL = 200
    BUFFER = 1000
    KEEP = 64
    SORT_BUF_SIZE = 50
    ows下应以administrator用户运行dmagent。', 0x424DB6010000000000003600000028000000100000000800000001001800000000008001000000000000000000000000000000000000241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED, 0x424DB6010000000000003600000028000000100000000800000001001800000000008001000000000000000000000000000000000000241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED241CED2
回答 0
暂无回答
扫一扫
联系客服