本文主要介绍如何使用DM
提供的用于检查数据文件完整性的命令行工具dmdbchk
，包括该工具所具备的功能及其参数的具体使用方法。
1 概述
数据文件合法性检验。
● 数据文件校验只校验数据文件大小。如果数据库文件实际大小大于或等于文件头中记录的大小，则合法。索引正确性校验。
● 索引检验包括：普通表B
树索引校验、LIST
表扁平B
树索引校验、列存储表索引校验。
● 校验内容具体包括：B
树的层次、层次关系，每层的内部页、叶子页以及页之间的前后链接关系，每个页的页头信息（如页类型等)等。对象 ID
合法性校验。
● 对象ID
校验包括数据库内的所有对象的ID
检验。对象包括：索引、表、约束、存储过 程、模式、同义词、用户等。
● 如果从系统表中查出的对象ID
小于库的ID
预留页中记录的该 类型对象的下一分配ID
，则合法。因为库的ID
预留页中记录的是各类型对象下一个新分配 对象将使用的ID
，因此若系统表中的对象ID
大于或等于该ID
，说明库已损坏。
●dmdbchk
并不能检查出用户实际数据的正确性残留信号量和共享内存的检测及删除
● 一般 Linux 下默认可创建的信号量个数为128
个，共享内存为4096
个。
●DM
数据库服 务器正常退出的情况下，会将创建的信号量或共享内存删除，但如果服务器异常退出，这些 信号量及共享内存会一直留在操作系统中直到通过手工方式删除。如果残留的信号量或共享 内存个数达到操作系统上限，服务器再次启动时，会因为创建信号量或共享内存失败而无法 启动成功，因此在本工具中提供对Linux
残留信号量和共享内存的检测及删除命令。
2 使用方法说明
dmdbchk
工具不同的参数用法也不同，详情可以查阅手册；
● 如果是校验数据库的参数，则要求必须是经过初始化，且正常关闭的数据库，才能被dmdbchk
工具校验，否则dmdbchk
会报错退出。
2.1. 校验结果
● 校验完毕后，dmdbchk
会在当前目录下（dmdbchk
所在目录）生成一个名为dbchk_err.txt
的检查报告，供用户查看。 ● 该工具位于安装目录的/dmdbms/bin
目录下。 ●dmdbchk
校验的过程对用户不可见，校验的结果以报告的形式呈现给用户。dmdbchk
校验数据库的报告内容分为七部分：
一
dmdbchk
版本信息；
二 开始标志；
三 数据文件校验结果；
四 索引校验结果；
五 对象ID
校验结果；
六 结束标志；
七 错误总数。
[图片]
工具dmdbchk
离线工具，需要数据库正常停止，可以输出有哪些表哪些index
有问题；可以把表或索引重建。
1.2. 示例
[dmdba@dm91 bin]$ ./dmdbchk help
version: 05134284336-20250117-257733-20132
格式: ./dmdbchk KEYWORD=value
例程: ./dmdbchk path=/opt/dmdbms/bin/dm.ini
关键字 说明
--------------------------------------------------------------------------------
PATH dm.ini绝对路径或者当前目录的dm.ini
DCR_INI dmdcr.ini的路径
HELP 打印帮助信息
START_INDEXID 最小检查索引号
END_INDEXID 最大检查索引号
CHECK_SEMA 检查当前系统信号量使用情况（只适用于LINUX，1：只做检查 2：检查并删除残留信号量）
CHECK_SHM 检查当前系统共享内存使用情况（只适用于LINUX，1：只做检查 2：检查并删除残留共享内存）
CHECK_REC 检查数据库中B树叶子节点的记录（0：不做检查 1：检查 2：同时检查BLOB字段 默认为0，仅用于B树索引检测，在FILE_PATH参数下不起作用）
PARALLEL 用于指定检测的过程中所使用的线程数目(1-100, 默认8)
FILE_PATH 单独检测指定的dbf文件的路径地址
TABLESPACEID 单独检测指定的表空间号
FEEDBACK 是否显示检测百分比进度（0：不显示 1：显示 2：只显示简略信息 默认为0）
OUTPUT_FIL 用于指定生成的检测报告的路径（默认为当前目录下的dbchk_err.txt）
[dmdba@dm91 bin]$
例 1. 校验数据库
./dmdbchk PATH=/home/test/dmdbms/dm.ini
# 如果 dm.ini 在 dmdbchk 当前目录，也可以写成这样：
./dmdbchk PATH=dm.ini
例 2. 检测某台 linux 机器上信号量的使用情况。
./dmdbchk CHECK_SEMA=1
例 3 删除某台 linux 机器上的残留信号量。
./dmdbchk CHECK_SEMA=
3 使用场景说明
查询到某个功能时，数据库莫名异常服务时，检查日志中有 page error 相关异常。同时及其他检查。
3.1 起停数据库服务说明
假设是异常停止的数据库需要先启动服务才可以使用dmdbchk
发现有不少老铁还是不知道怎么起停服务、查看进程这里继续讲解下。通常部署时候均配置有环境变量信息，切换到dmdba
用户下操作执行DmS
按tab
按键补全命令start
回车即可，如下命令所示：
[dmdba@dm91 bin]$ cd $DM_HOME/bin
[dmdba@dm91 bin]$ ./DmServiceDEM start
查看数据库服务器进程时候有运行，执行 ps -ef|grep dmser
即可以查看到运行的进程服务。
[dmdba@dm91 bin]$ ps -ef|grep dmser
dmdba 34581 34006 0 09:11 pts/1 00:00:00 grep --color=auto dmser
dmdba 73487 1 3 2月11 pts/2 07:53:16 dm/dmdbms/dm81448/bin/dmserver path=/dm/dmdata/dmdb/dm.ini -noconsole
dmdba 87035 1 0 2月19 ? 00:27:14 dm/dmdbms/dm81448/bin/dmserver path=/dm/dmdata/DEM/dm.ini -noconsole
[dmdba@dm91 bin]$
停止数据库服务方式如下
[dmdba@dm91 bin]$ cd $DM_HOME/bin
[dmdba@dm91 bin]$ ./DmServiceDEM stop
3.2.dmdbchk
举例
[dmdba@dm91 bin]$ ./dmdbchk path=/dm/dmdata/DEM/dm.ini
[2025-02-22 09:13:55]dmdbchk V8
[2025-02-22 09:13:55]file dm.key not found, use default license!
Can not open ini file dmdcr.ini!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
ndct db load finished, code:0
[2025-02-22 09:13:55]DM DB CHECK START......
[2025-02-22 09:13:55]--------check dbf file size start---------
[2025-02-22 09:13:55]FILE=(ts_id=0, fil_id=0, path=/dm/dmdata/DEM/SYSTEM.DBF)
[2025-02-22 09:13:55]FILE=(ts_id=1, fil_id=0, path=/dm/dmdata/DEM/ROLL.DBF)
[2025-02-22 09:13:55]FILE=(ts_id=4, fil_id=0, path=/dm/dmdata/DEM/MAIN.DBF)
[2025-02-22 09:13:55]FILE=(ts_id=5, fil_id=0, path=/dm/dmdata/DEM/PROMETHEUS.DBF)
[2025-02-22 09:13:55]--------check dbf file size end-----------
[2025-02-22 09:13:55]--------check indexes start---------------
[2025-02-22 09:13:55]INDEX=(id=33554459, name=SYSINDEXSYSAUDITSQLSEQ, table_name=SYSAUDITSQLSEQ)
[2025-02-22 09:13:55]INDEX=(id=33554434, name=SYSINDEXINDEXES, table_name=SYSINDEXES)
[2025-02-22 09:13:55]INDEX=(id=33554458, name=SYSINDEXSYSAUDIT, table_name=SYSAUDIT)
[2025-02-22 09:13:55]INDEX=(id=33554440, name=SYSINDEXTUSERS, table_name=SYSUSER$)
[2025-02-22 09:13:55]INDEX=(id=33554468, name=SYSINDEXSTATS, table_name=SYSSTATS)
[2025-02-22 09:13:55]INDEX=(id=33554464, name=SYSINDEXCONTEXTINDEXES, table_name=SYSCONTEXTINDEXES)
[2025-02-22 09:13:55]INDEX=(id=33554452, name=SYSINDEXCONSTRAINTS, table_name=SYSCONS)
[2025-02-22 09:13:55]INDEX=(id=33554442, name=SYSINDEXSYSGRANTS, table_name=SYSGRANTS)
[2025-02-22 09:13:55]INDEX=(id=33554489, name=SYSINDEXSPWDCHGS, table_name=SYSPWDCHGS)
[2025-02-22 09:13:55]INDEX=(id=33554510, name=SYSINDEXCONTEXTLIBS, table_name=SYSCONTEXTLIBS)
[2025-02-22 09:13:55]INDEX=(id=33554539, name=SYSINDEXCLASSES, table_name=SYSCLASSES)
[2025-02-22 09:13:55]INDEX=(id=33554546, name=SYSINDEXSYSACCHISTORIES, table_name=SYSACCHISTORIES)
[2025-02-22 09:13:55]INDEX=(id=33554498, name=SYSINDEXSYSAUDITRULES, table_name=SYSAUDITRULES)
[2025-02-22 09:13:55]INDEX=(id=33554548, name=SYSINDEXSYSHPARTTABLEINFO, table_name=SYSHPARTTABLEINFO)
[2025-02-22 09:13:55]INDEX=(id=33554550, name=SYSINDEXMACLVLS, table_name=SYSMACLVLS)
[2025-02-22 09:13:55]INDEX=(id=33554549, name=SYSINDEXMACPLYS, table_name=SYSMACPLYS)
[2025-02-22 09:13:55]INDEX=(id=33554433, name=SYSINDEXCOLUMNS, table_name=SYSCOLUMNS)
[2025-02-22 09:13:55]INDEX=(id=33554552, name=SYSINDEXMACGRPS, table_name=SYSMACGRPS)
[2025-02-22 09:13:55]INDEX=(id=33554541, name=SYSINDEXSYSDUAL, table_name=SYSDUAL)
[2025-02-22 09:13:55]INDEX=(id=33554544, name=SYSINDEXSYSTYPEINFOS, table_name=SYSTYPEINFOS)
[2025-02-22 09:13:55]INDEX=(id=33554553, name=SYSINDEXMACLABELS, table_name=SYSMACLABELS)
[2025-02-22 09:13:55]INDEX=(id=33554554, name=SYSINDEXMACTABPLY, table_name=SYSMACTABPLY)
[2025-02-22 09:13:55]INDEX=(id=33554561, name=SYSINDEXSYSRESOURCES, table_name=SYSRESOURCES)
[2025-02-22 09:13:55]INDEX=(id=33554555, name=SYSINDEXMACUSRPLY, table_name=SYSMACUSRPLY)
[2025-02-22 09:13:55]INDEX=(id=33554559, name=SYSINDEXCOLCYT, table_name=SYSCOLCYT)
[2025-02-22 09:13:55]INDEX=(id=33554560, name=SYSINDEXMACOBJ, table_name=SYSMACOBJ)
[2025-02-22 09:13:55]INDEX=(id=33554551, name=SYSINDEXMACCOMPS, table_name=SYSMACCOMPS)
[2025-02-22 09:13:55]INDEX=(id=33554562, name=SYSINDEXTABLECOMMENTS, table_name=SYSTABLECOMMENTS)
[2025-02-22 09:13:55]INDEX=(id=33554566, name=RINDEXSYSCONS, table_name=SYSCONS)
[2025-02-22 09:13:55]INDEX=(id=33554567, name=FINDEXSYSCONS, table_name=SYSCONS)
[2025-02-22 09:13:55]INDEX=(id=33554564, name=SYSINDEXSYSREWRITE, table_name=SYS_REWRITE_EQUIVALENCES)
[2025-02-22 09:13:55]INDEX=(id=33554565, name=SYSINDEXSYSDISTABLEINFO, table_name=SYSDISTABLEINFO)
[2025-02-22 09:13:55]INDEX=(id=33554540, name=SYSINDEXSYSOBJECTS, table_name=SYSOBJECTS)
[2025-02-22 09:13:55]INDEX=(id=33554568, name=SYSINDEXCOLINFOS, table_name=SYSCOLINFOS)
[2025-02-22 09:13:55]INDEX=(id=33554570, name=RINDSYSDEPENDENCIES, table_name=SYSDEPENDENCIES)
[2025-02-22 09:13:55]INDEX=(id=33554571, name=SYSINDEXFREQROOTS, table_name=SYSFREQROOTS)
[2025-02-22 09:13:55]INDEX=(id=33554572, name=SYSINDEXTABLECOMMENTSKEYS, table_name=SYSTABLECOMMENTS)
[2025-02-22 09:13:55]INDEX=(id=33554569, name=SYSINDEXSYSDEPENDENCIES, table_name=SYSDEPENDENCIES)
[2025-02-22 09:13:55]INDEX=(id=33554556, name=SYSINDEXSYSOBJINFOS, table_name=SYSOBJINFOS)
[2025-02-22 09:13:55]INDEX=(id=33554574, name=SYSINDEXSYSUSERINI$, table_name=SYSUSERINI$)
[2025-02-22 09:13:55]INDEX=(id=33554563, name=SYSINDEXCOLUMNCOMMENTS, table_name=SYSCOLUMNCOMMENTS)
[2025-02-22 09:13:55]INDEX=(id=33554575, name=SYSINDEXSYSINJECTHINT, table_name=SYSINJECTHINT)
[2025-02-22 09:13:55]INDEX=(id=33554576, name=SYSINDEXIDSYSOBJECTS, table_name=SYSOBJECTS)
[2025-02-22 09:13:55]INDEX=(id=33554577, name=SYSINDEXSYSDUAL2, table_name=SYSDUAL2)
[2025-02-22 09:13:55]INDEX=(id=33554573, name=SYSINDEXCOLUMNCOMMENTSKEYS, table_name=SYSCOLUMNCOMMENTS)
[2025-02-22 09:13:55]INDEX=(id=33554580, name=SYSINDEXSYSSTATPREFS, table_name=SYSSTATPREFS)
[2025-02-22 09:13:55]INDEX=(id=33554578, name=SYSINDEXMSTATS, table_name=SYSMSTATS)
[2025-02-22 09:13:55]INDEX=(id=33554543, name=SYSINDEXSYSTEXTS, table_name=SYSTEXTS)
[2025-02-22 09:13:55]INDEX=(id=33554581, name=SYSINDEXSYSSTATTABLEIDU, table_name=SYSSTATTABLEIDU)
[2025-02-22 09:13:55]INDEX=(id=33554583, name=SYSINDEXPROXYINFOS, table_name=PROXY_INFO$)
[2025-02-22 09:13:55]INDEX=(id=33554582, name=SYSINDEXFCOLDEFAULT, table_name=SYSFCOLDEFAULT)
[2025-02-22 09:13:55]INDEX=(id=33554588, name=SYSINDEXSYSTUNINGREPORT, table_name=SYSTUNINGREPORT)
[2025-02-22 09:13:55]INDEX=(id=33554586, name=SYSINDEXSYSTUNINGTASK, table_name=SYSTUNINGTASK)
[2025-02-22 09:13:55]INDEX=(id=33554585, name=SYSUSERPROFILES, table_name=SYSUSERPROFILES)
[2025-02-22 09:13:55]INDEX=(id=33554587, name=SYSINDEXSYSTUNINGEXECUTION, table_name=SYSTUNINGEXECUTION)
[2025-02-22 09:13:55]INDEX=(id=33554589, name=SYSINDEXSYSMODIFICATIONS, table_name=SYSMODIFICATIONS)
[2025-02-22 09:13:55]INDEX=(id=33554579, name=SYSINDEXOPENHISTORY, table_name=SYSOPENHISTORY)
[2025-02-22 09:13:55]INDEX=(id=33554606, name=SYSINDEX_DPC_TABLESPACE, table_name=DPC_TABLESPACE)
[2025-02-22 09:13:55]INDEX=(id=33554584, name=SYSPROFILES, table_name=SYSPROFILES)
[2025-02-22 09:13:55]INDEX=(id=33554608, name=SYSINDEX_SYSTSGROUPS, table_name=SYSTSGROUPS)
[2025-02-22 09:13:55]INDEX=(id=33554609, name=SYSINDEXREDEFSTATUS, table_name=SYSREDEFSTATUS)
[2025-02-22 09:13:55]INDEX=(id=33554611, name=SYSINDEXREDEFDERROR, table_name=SYSREDEFDERROR)
[2025-02-22 09:13:55]INDEX=(id=33554610, name=SYSINDEXREDEFOBJECT, table_name=SYSREDEFOBJECT)
[2025-02-22 09:13:55]INDEX=(id=33554613, name=SYSINDEXSYSPLNOBJID, table_name=SYSPLNOBJID)
[2025-02-22 09:13:55]INDEX=(id=33554612, name=SYSINDEXSYSPLNINFO, table_name=SYSPLNINFO)
[2025-02-22 09:13:55]INDEX=(id=33554625, name=SYSINDEXOPARGS, table_name=SYSOPARGS)
[2025-02-22 09:13:55]INDEX=(id=33554626, name=SYSINDEXRECYCLEBIN, table_name=RECYCLEBIN$)
[2025-02-22 09:13:55]INDEX=(id=33554624, name=SYSINDEXCOLBYUSER, table_name=SYSCOLBYUSER)
[2025-02-22 09:13:55]INDEX=(id=33554614, name=SYSINDEXSYSPLNINFOKEYS, table_name=SYSPLNINFO)
[2025-02-22 09:13:55]INDEX=(id=33554591, name=SYSINDEXSYSPKGPROCINFOS, table_name=SYSPKGPROCINFOS)
[2025-02-22 09:13:55]INDEX=(id=33554628, name=SYSINDEXCRASHTRXS, table_name=SYSCRASHTRXS)
[2025-02-22 09:13:55]INDEX=(id=33554627, name=SYSINDEXERRORPAGES, table_name=SYSERRORPAGES)
[2025-02-22 09:13:55]INDEX=(id=33554632, name=SYSINDEX_SYSTEMPLATEHUGEDAUX, table_name=SYSTEMPLATEHUGEDAUX)
[2025-02-22 09:13:55]INDEX=(id=33554631, name=SYSINDEX_SYSTEMPLATEHUGEAUX, table_name=SYSTEMPLATEHUGEAUX)
[2025-02-22 09:13:55]INDEX=(id=33554633, name=SYSINDEX_SYSTEMPLATEHUGEUAUX, table_name=SYSTEMPLATEHUGEUAUX)
[2025-02-22 09:13:55]INDEX=(id=33554629, name=SYSINDEXSYSPLANHIST, table_name=SYSPLANHIST)
[2025-02-22 09:13:55]INDEX=(id=33554635, name=SYSINDEXFECOLS, table_name=SYSFECOLS)
[2025-02-22 09:13:55]INDEX=(id=33554634, name=SYSINDEXFECKS, table_name=SYSFECKS)
[2025-02-22 09:13:55]INDEX=(id=33554636, name=SYSINDEXSYSSQLPROFILE, table_name=SYSSQLPROFILE)
[2025-02-22 09:13:55]INDEX=(id=33554644, name=SYSINDEXIDSYSMACLABELS, table_name=SYSMACLABELS)
[2025-02-22 09:13:55]INDEX=(id=33554590, name=SYSINDEXNAMESYSOBJECTS, table_name=SYSOBJECTS)
[2025-02-22 09:13:55]INDEX=(id=33554643, name=SYSINDEXDROPTIMERECYCLEBIN, table_name=RECYCLEBIN$)
[2025-02-22 09:13:55]INDEX=(id=33554645, name=SYSINDEX_SYSOIDS, table_name=SYSOIDS)
[2025-02-22 09:13:55]INDEX=(id=33554642, name=SYSINDEXNAMERECYCLEBIN, table_name=RECYCLEBIN$)
[2025-02-22 09:13:55]INDEX=(id=33555434, name=SECOND_INDXE_SYS_REWRITE_EQUIVALENCES_X7Q1, table_name=SYS_REWRITE_EQUIVALENCES)
[2025-02-22 09:13:55]INDEX=(id=33555432, name=INDEX33555432, table_name=SYSMACPLYS)
[2025-02-22 09:13:55]INDEX=(id=33554592, name=SYSINDEXSYSPKGPROCPARAMS, table_name=SYSPKGPROCPARAMS)
[2025-02-22 09:13:55]INDEX=(id=33554650, name=SYSINDEXSYSTYPEATTRINFO, table_name=SYSTYPEATTRINFO)
[2025-02-22 09:13:55]INDEX=(id=33555435, name=INDEX33555435, table_name=SYSAUDITSQLSEQ)
[2025-02-22 09:13:55]INDEX=(id=33554646, name=SYSINDEX_SYSOIDSTABID, table_name=SYSOIDS)
[2025-02-22 09:13:55]INDEX=(id=33555438, name=INDEX33555438, table_name=DPC_TABLESPACE)
[2025-02-22 09:13:55]INDEX=(id=33555439, name=INDEX33555439, table_name=SYSTUNINGTASK)
[2025-02-22 09:13:55]INDEX=(id=33555441, name=INDEX33555441, table_name=SYSTUNINGEXECUTION)
[2025-02-22 09:13:55]INDEX=(id=33555444, name=INDEX33555444, table_name=SYSSQLPROFILE)
[2025-02-22 09:13:55]INDEX=(id=33555433, name=SYSINDEXPIDIDSYSOBJECTS, table_name=SYSOBJECTS)
[2025-02-22 09:13:55]INDEX=(id=33555452, name=SYSINDEXPARTTIDSYSHPARTTABLEINFO, table_name=SYSHPARTTABLEINFO)
[2025-02-22 09:13:55]INDEX=(id=33555447, name=INDEX33555447, table_name=DBMS_PARALLEL_EXECUTE_CHUNKS$)
[2025-02-22 09:13:55]INDEX=(id=33555457, name=INDEX33555457, table_name=POLICY_CONTEXTS)
[2025-02-22 09:13:55]INDEX=(id=33555455, name=INDEX33555455, table_name=POLICY_GROUPS)
[2025-02-22 09:13:55]INDEX=(id=33555448, name=INDEX33555448, table_name=DBMS_PARALLEL_EXECUTE_CHUNKS$)
[2025-02-22 09:13:55]INDEX=(id=33555456, name=INDEX33555456, table_name=POLICIES)
[2025-02-22 09:13:55]INDEX=(id=33555459, name=INDEX33555459, table_name=POLICY_MASKS)
[2025-02-22 09:13:55]INDEX=(id=33555458, name=INDEX33555458, table_name=POLICY_COLS)
[2025-02-22 09:13:55]INDEX=(id=33555462, name=INDEX33555462, table_name=AQ$_QUEUE_TABLES)
[2025-02-22 09:13:55]INDEX=(id=33555464, name=INDEX33555464, table_name=AQ$_QUEUES)
[2025-02-22 09:13:55]INDEX=(id=33555461, name=INDEX33555461, table_name=DBMS_ALERT_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555460, name=INDEX33555460, table_name=DBMS_LOCK_ALLOCATED)
[2025-02-22 09:13:55]INDEX=(id=33555445, name=INDEX33555445, table_name=DBMS_PARALLEL_EXECUTE_TASK$)
[2025-02-22 09:13:55]INDEX=(id=33555469, name=INDEX33555469, table_name=SYSTSGROUPS)
[2025-02-22 09:13:55]INDEX=(id=33555446, name=INDEX33555446, table_name=DBMS_PARALLEL_EXECUTE_TASK$)
[2025-02-22 09:13:55]INDEX=(id=33555463, name=INDEX33555463, table_name=AQ$_QUEUE_TABLES)
[2025-02-22 09:13:55]INDEX=(id=33555473, name=INDEX33555473, table_name=ADMIN_CONFIG)
[2025-02-22 09:13:55]INDEX=(id=33555468, name=INDEX33555468, table_name=REG$)
[2025-02-22 09:13:55]INDEX=(id=33555474, name=INDEX33555474, table_name=ADMIN_USER)
[2025-02-22 09:13:55]INDEX=(id=33555476, name=INDEX33555476, table_name=ADMIN_AUDIT)
[2025-02-22 09:13:55]INDEX=(id=33555472, name=INDEX33555472, table_name=ADMIN_ROLE)
[2025-02-22 09:13:55]INDEX=(id=33555475, name=INDEX33555475, table_name=ADMIN_USER)
[2025-02-22 09:13:55]INDEX=(id=33555471, name=INDEX33555471, table_name=ADMIN_ROLE)
[2025-02-22 09:13:55]INDEX=(id=33555477, name=INDEX33555477, table_name=ADMIN_AUDIT_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555466, name=INDEX33555466, table_name=AQ$_QUEUES)
[2025-02-22 09:13:55]INDEX=(id=33555482, name=INDEX33555482, table_name=DBTOOL_SERVER_CONN)
[2025-02-22 09:13:55]INDEX=(id=33555483, name=INDEX33555483, table_name=DBTOOL_SERVER_CONN)
[2025-02-22 09:13:55]INDEX=(id=33555486, name=INDEX33555486, table_name=DMA_ALERT)
[2025-02-22 09:13:55]INDEX=(id=33555488, name=INDEX33555488, table_name=DMA_ALERT_HIS)
[2025-02-22 09:13:55]INDEX=(id=33555487, name=INDEX33555487, table_name=DMA_ALERT)
[2025-02-22 09:13:55]INDEX=(id=33555465, name=INDEX33555465, table_name=AQ$_QUEUES)
[2025-02-22 09:13:55]INDEX=(id=33555479, name=INDEX33555479, table_name=DBTOOL_PREFERENCE)
[2025-02-22 09:13:55]INDEX=(id=33555478, name=INDEX33555478, table_name=ADMIN_AUDIT_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555490, name=INDEX_DMA_ALERT_HIS_ALERT_ID, table_name=DMA_ALERT_HIS)
[2025-02-22 09:13:55]INDEX=(id=33555481, name=INDEX_UNIQUE_DBTOOL_PREFERENCE, table_name=DBTOOL_PREFERENCE)
[2025-02-22 09:13:55]INDEX=(id=33555493, name=INDEX33555493, table_name=DMA_ALERT_HIS_NOTIFY)
[2025-02-22 09:13:55]INDEX=(id=33555480, name=INDEX_DBTOOL_PREFERENCE, table_name=DBTOOL_PREFERENCE)
[2025-02-22 09:13:55]INDEX=(id=33555494, name=INDEX33555494, table_name=DMA_ALERT_HIS_NOTIFY)
[2025-02-22 09:13:55]INDEX=(id=33555495, name=INDEX_DMA_ALERT_HIS_NOTIFY_USER_ID, table_name=DMA_ALERT_HIS_NOTIFY)
[2025-02-22 09:13:55]INDEX=(id=33555491, name=INDEX_DMA_ALERT_HIS_GMT_CREATE, table_name=DMA_ALERT_HIS)
[2025-02-22 09:13:55]INDEX=(id=33555492, name=INDEX_DMA_ALERT_HIS_RES_ID, table_name=DMA_ALERT_HIS)
[2025-02-22 09:13:55]INDEX=(id=33555501, name=INDEX33555501, table_name=DMA_ALERT_TEMPLATE)
[2025-02-22 09:13:55]INDEX=(id=33555502, name=INDEX33555502, table_name=DMA_ALERT_TEMPLATE)
[2025-02-22 09:13:55]INDEX=(id=33555489, name=INDEX33555489, table_name=DMA_ALERT_HIS)
[2025-02-22 09:13:55]INDEX=(id=33555500, name=INDEX_DMA_ALERT_RULE_ALERT_ID, table_name=DMA_ALERT_RULE)
[2025-02-22 09:13:55]INDEX=(id=33555503, name=INDEX33555503, table_name=DMA_ALERT_USER)
[2025-02-22 09:13:55]INDEX=(id=33555499, name=INDEX33555499, table_name=DMA_ALERT_RULE)
[2025-02-22 09:13:55]INDEX=(id=33555505, name=INDEX33555505, table_name=DMA_INSPECT)
[2025-02-22 09:13:55]INDEX=(id=33555496, name=INDEX33555496, table_name=DMA_ALERT_RES)
[2025-02-22 09:13:55]INDEX=(id=33555504, name=INDEX_DMA_ALERT_USER_ALERT_ID, table_name=DMA_ALERT_USER)
[2025-02-22 09:13:55]INDEX=(id=33555497, name=INDEX_DMA_ALERT_RES_ALERT_ID, table_name=DMA_ALERT_RES)
[2025-02-22 09:13:55]INDEX=(id=33555506, name=INDEX33555506, table_name=DMA_INSPECT)
[2025-02-22 09:13:55]INDEX=(id=33555510, name=INDEX33555510, table_name=DMA_INSPECT_RPT)
[2025-02-22 09:13:55]INDEX=(id=33555508, name=INDEX_DMA_INSPECT_RES_INSPECT_ID, table_name=DMA_INSPECT_RES)
[2025-02-22 09:13:55]INDEX=(id=33555498, name=INDEX_DMA_ALERT_RES_RES_ID, table_name=DMA_ALERT_RES)
[2025-02-22 09:13:55]INDEX=(id=33555509, name=INDEX_DMA_INSPECT_RES_RES_ID, table_name=DMA_INSPECT_RES)
[2025-02-22 09:13:55]INDEX=(id=33555507, name=INDEX33555507, table_name=DMA_INSPECT_RES)
[2025-02-22 09:13:55]INDEX=(id=33555511, name=INDEX_DMA_INSPECT_RPT_INSPECT_ID, table_name=DMA_INSPECT_RPT)
[2025-02-22 09:13:55]INDEX=(id=33555512, name=INDEX33555512, table_name=DMA_INSPECT_USER)
[2025-02-22 09:13:55]INDEX=(id=33555519, name=INDEX33555519, table_name=DMA_BACKUP_RES)
[2025-02-22 09:13:55]INDEX=(id=33555513, name=INDEX_DMA_INSPECT_USER_INSPECT_ID, table_name=DMA_INSPECT_USER)
[2025-02-22 09:13:55]INDEX=(id=33555514, name=INDEX33555514, table_name=DMA_BACKUP)
[2025-02-22 09:13:55]INDEX=(id=33555515, name=INDEX33555515, table_name=DMA_BACKUP_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555522, name=INDEX33555522, table_name=DMA_BACKUP_USER)
[2025-02-22 09:13:55]INDEX=(id=33555524, name=INDEX33555524, table_name=DMA_DATABASE)
[2025-02-22 09:13:55]INDEX=(id=33555523, name=INDEX_DMA_BACKUP_USER_BACKUP_ID, table_name=DMA_BACKUP_USER)
[2025-02-22 09:13:55]INDEX=(id=33555518, name=IDX_BACKUP_STAT_TIME, table_name=DMA_BACKUP_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555526, name=INDEX33555526, table_name=DMA_DATABASE_LOCK)
[2025-02-22 09:13:55]INDEX=(id=33555516, name=IDX_BACKUP_STAT_ID, table_name=DMA_BACKUP_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555527, name=INDEX33555527, table_name=DMA_DATABASE_LOCK)
[2025-02-22 09:13:55]INDEX=(id=33555530, name=INDEX33555530, table_name=DMA_DATABASE_DEADLOCK)
[2025-02-22 09:13:55]INDEX=(id=33555517, name=IDX_BACKUP_STAT_DB_ID, table_name=DMA_BACKUP_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555531, name=INDEX33555531, table_name=DMA_DATABASE_DEADLOCK)
[2025-02-22 09:13:55]INDEX=(id=33555532, name=INDEX33555532, table_name=DMA_DATABASE_DF)
[2025-02-22 09:13:55]INDEX=(id=33555521, name=INDEX_DMA_BACKUP_RES_RES_ID, table_name=DMA_BACKUP_RES)
[2025-02-22 09:13:55]INDEX=(id=33555533, name=INDEX_DMA_DB_DF, table_name=DMA_DATABASE_DF)
[2025-02-22 09:13:55]INDEX=(id=33555520, name=INDEX_DMA_BACKUP_RES_INSPECT_ID, table_name=DMA_BACKUP_RES)
[2025-02-22 09:13:55]INDEX=(id=33555534, name=INDEX33555534, table_name=DMA_DATABASE_EVENT)
[2025-02-22 09:13:55]INDEX=(id=33555542, name=INDEX33555542, table_name=DMA_DATABASE_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555540, name=INDEX33555540, table_name=DMA_DATABASE_INI_FILE)
[2025-02-22 09:13:55]INDEX=(id=33555535, name=INDEX33555535, table_name=DMA_DATABASE_EVENT)
[2025-02-22 09:13:55]INDEX=(id=33555543, name=INDEX_DMA_DB_SESSION, table_name=DMA_DATABASE_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555552, name=INDEX33555552, table_name=DMA_DATABASE_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555536, name=INDEX33555536, table_name=DMA_DATABASE_DANGER_EVENT)
[2025-02-22 09:13:55]INDEX=(id=33555538, name=INDEX33555538, table_name=DMA_DATABASE_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555553, name=INDEX33555553, table_name=DMA_DATABASE_GROUP_DPC_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555541, name=INDEX33555541, table_name=DMA_DATABASE_INI_FILE)
[2025-02-22 09:13:55]INDEX=(id=33555539, name=INDEX33555539, table_name=DMA_DATABASE_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555547, name=INDEX33555547, table_name=DMA_DATABASE_SQL_LOG_FILE_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555555, name=INDEX33555555, table_name=DMA_DATABASE_GROUP_DPC_SQL)
[2025-02-22 09:13:55]INDEX=(id=33555554, name=INDEX33555554, table_name=DMA_DATABASE_GROUP_DPC_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555556, name=INDEX33555556, table_name=DMA_DATABASE_GROUP_DPC_SQL_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555557, name=INDEX33555557, table_name=DMA_DATABASE_GROUP_DPC_SQL_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555546, name=INDEX33555546, table_name=DMA_DATABASE_SQL_LOG_FILE_INFO)
[2025-02-22 09:13:55]INDEX=(id=33555537, name=INDEX33555537, table_name=DMA_DATABASE_DANGER_EVENT)
[2025-02-22 09:13:55]INDEX=(id=33555558, name=INDEX33555558, table_name=DMA_DATABASE_GROUP_DPC_SQL_PLAN)
[2025-02-22 09:13:55]INDEX=(id=33555560, name=INDEX33555560, table_name=DMA_DATABASE_GROUP_DSC_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555564, name=INDEX33555564, table_name=DMA_DATABASE_GROUP_RW_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555565, name=INDEX33555565, table_name=DMA_DATABASE_GROUP_RW_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555561, name=INDEX33555561, table_name=DMA_DATABASE_GROUP_DSC_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555562, name=INDEX33555562, table_name=DMA_DATABASE_GROUP_MPP_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555563, name=INDEX33555563, table_name=DMA_DATABASE_GROUP_MPP_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555559, name=INDEX33555559, table_name=DMA_DATABASE_GROUP_DPC_SQL_PLAN)
[2025-02-22 09:13:55]INDEX=(id=33555567, name=INDEX33555567, table_name=DMA_DATABASE_GROUP_DW_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555568, name=INDEX33555568, table_name=DMA_DATABASE_GROUP_MCOPY_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555570, name=INDEX33555570, table_name=DMA_DATABASE_GROUP_DPC_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555572, name=INDEX33555572, table_name=DMA_DATABASE_GROUP_DSC_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555571, name=INDEX33555571, table_name=DMA_DATABASE_GROUP_DPC_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555566, name=INDEX33555566, table_name=DMA_DATABASE_GROUP_DW_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555574, name=INDEX33555574, table_name=DMA_DATABASE_GROUP_MPP_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555573, name=INDEX33555573, table_name=DMA_DATABASE_GROUP_DSC_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555578, name=INDEX33555578, table_name=DMA_DATABASE_GROUP_DW_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555575, name=INDEX33555575, table_name=DMA_DATABASE_GROUP_MPP_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555580, name=INDEX33555580, table_name=DMA_DATABASE_GROUP_MCOPY_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555579, name=INDEX33555579, table_name=DMA_DATABASE_GROUP_DW_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555569, name=INDEX33555569, table_name=DMA_DATABASE_GROUP_MCOPY_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555581, name=INDEX33555581, table_name=DMA_DATABASE_GROUP_MCOPY_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555576, name=INDEX33555576, table_name=DMA_DATABASE_GROUP_RW_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555582, name=INDEX33555582, table_name=DMA_DATABASE_ARCH_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555583, name=INDEX33555583, table_name=DMA_DATABASE_ARCH_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555588, name=INDEX33555588, table_name=DMA_DATABASE_TABLE_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555589, name=INDEX_DMA_DATABASE_TABLE_STAT, table_name=DMA_DATABASE_TABLE_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555584, name=INDEX33555584, table_name=DMA_DATABASE_ARCH_FILE)
[2025-02-22 09:13:55]INDEX=(id=33555585, name=INDEX_DMA_DB_ARCH_FILE, table_name=DMA_DATABASE_ARCH_FILE)
[2025-02-22 09:13:55]INDEX=(id=33555591, name=INDEX33555591, table_name=DMA_UD_SQL)
[2025-02-22 09:13:55]INDEX=(id=33555590, name=INDEX33555590, table_name=DMA_DATABASE_TS)
[2025-02-22 09:13:55]INDEX=(id=33555577, name=INDEX33555577, table_name=DMA_DATABASE_GROUP_RW_SESSION)
[2025-02-22 09:13:55]INDEX=(id=33555592, name=INDEX33555592, table_name=DMA_UD_SQL_DB)
[2025-02-22 09:13:55]INDEX=(id=33555596, name=INDEX33555596, table_name=DMA_UD_SCRIPT)
[2025-02-22 09:13:55]INDEX=(id=33555586, name=INDEX33555586, table_name=DMA_DATABASE_TABLE)
[2025-02-22 09:13:55]INDEX=(id=33555594, name=INDEX33555594, table_name=DMA_UD_SQL_DB_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555599, name=INDEX33555599, table_name=DMA_UD_SCRIPT_MF_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555595, name=INDEX33555595, table_name=DMA_UD_SQL_DB_STAT)
[2025-02-22 09:13:55]INDEX=(id=33555587, name=INDEX33555587, table_name=DMA_DATABASE_TABLE)
[2025-02-22 09:13:55]INDEX=(id=33555593, name=INDEX_DMA_UD_SQL_DB, table_name=DMA_UD_SQL_DB)
[2025-02-22 09:13:56]INDEX=(id=33555605, name=INDEX33555605, table_name=DMA_MAINFRAME_STAT)
[2025-02-22 09:13:56]INDEX=(id=33555604, name=INDEX33555604, table_name=DMA_MAINFRAME)
[2025-02-22 09:13:56]INDEX=(id=33555602, name=INDEX33555602, table_name=DMA_GROUP)
[2025-02-22 09:13:56]INDEX=(id=33555597, name=INDEX33555597, table_name=DMA_UD_SCRIPT_MF)
[2025-02-22 09:13:56]INDEX=(id=33555603, name=INDEX33555603, table_name=DMA_GROUP)
[2025-02-22 09:13:56]INDEX=(id=33555600, name=INDEX33555600, table_name=DMA_DATABASE_USER)
[2025-02-22 09:13:56]INDEX=(id=33555598, name=DMA_UD_SCRIPT_MF_INDEX, table_name=DMA_UD_SCRIPT_MF)
[2025-02-22 09:13:56]INDEX=(id=33555601, name=INDEX_DMA_DB_USER, table_name=DMA_DATABASE_USER)
[2025-02-22 09:13:56]INDEX=(id=33555607, name=INDEX33555607, table_name=DMA_MAINFRAME_GROUP_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555606, name=INDEX33555606, table_name=DMA_MAINFRAME_STAT)
[2025-02-22 09:13:56]INDEX=(id=33555609, name=INDEX33555609, table_name=DMA_MAINFRAME_GROUP_STAT)
[2025-02-22 09:13:56]INDEX=(id=33555608, name=INDEX33555608, table_name=DMA_MAINFRAME_GROUP_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555616, name=INDEX33555616, table_name=NOTIFY_USER)
[2025-02-22 09:13:56]INDEX=(id=33555617, name=INDEX33555617, table_name=NOTIFY)
[2025-02-22 09:13:56]INDEX=(id=33555611, name=INDEX33555611, table_name=DMA_MULTI_CONN_SQL_TEMPLATE)
[2025-02-22 09:13:56]INDEX=(id=33555610, name=INDEX33555610, table_name=DMA_MAINFRAME_GROUP_STAT)
[2025-02-22 09:13:56]INDEX=(id=33555622, name=INDEX33555622, table_name=DBTOOL_MANAGER_IMP_EXP)
[2025-02-22 09:13:56]INDEX=(id=33555623, name=INDEX33555623, table_name=DBTOOL_MANAGER_IMP_EXP)
[2025-02-22 09:13:56]INDEX=(id=33555618, name=INDEX33555618, table_name=NOTIFY)
[2025-02-22 09:13:56]INDEX=(id=33555612, name=INDEX33555612, table_name=DMA_MULTI_CONN_SQL_TEMPLATE)
[2025-02-22 09:13:56]INDEX=(id=33555624, name=INDEX33555624, table_name=DMA_PROCESS)
[2025-02-22 09:13:56]INDEX=(id=33555627, name=INDEX33555627, table_name=DMA_SUBSCRIPTION_RESOURCE)
[2025-02-22 09:13:56]INDEX=(id=33555625, name=IDX_PROCESS_MF_ID_COMMAND, table_name=DMA_PROCESS)
[2025-02-22 09:13:56]INDEX=(id=33555619, name=INDEX33555619, table_name=NOTIFY_SEND)
[2025-02-22 09:13:56]INDEX=(id=33555628, name=INDEX33555628, table_name=DMA_DATABASE_AUDITRECORD)
[2025-02-22 09:13:56]INDEX=(id=33555638, name=INDEX33555638, table_name=DMA_DATABASE_RLOG_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555635, name=INDEX33555635, table_name=DMA_DATABASE_SERVER_LOG_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555631, name=INDEX33555631, table_name=DMA_DATABASE_AUDITRECORD_SEND_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555632, name=INDEX33555632, table_name=DMA_DATABASE_AUDITRECORD_SEND_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555636, name=INDEX33555636, table_name=DMA_DATABASE_SERVER_LOG_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555640, name=INDEX33555640, table_name=DMA_DATABASE_RLOG_FILE)
[2025-02-22 09:13:56]INDEX=(id=33555629, name=IDX_DMA_DATABASE_AUDITRECORD_TS, table_name=DMA_DATABASE_AUDITRECORD)
[2025-02-22 09:13:56]INDEX=(id=33555630, name=IDX_DMA_DATABASE_AUDITRECORD_OPTIME, table_name=DMA_DATABASE_AUDITRECORD)
[2025-02-22 09:13:56]INDEX=(id=33555620, name=INDEX33555620, table_name=NOTIFY_SEND)
[2025-02-22 09:13:56]INDEX=(id=33555641, name=IDX_DMA_DATABASE_RLOG_FILE, table_name=DMA_DATABASE_RLOG_FILE)
[2025-02-22 09:13:56]INDEX=(id=33555644, name=INDEX33555644, table_name=DMA_DATABASE_BACKUPSET_BKP)
[2025-02-22 09:13:56]INDEX=(id=33555639, name=IDX_DMA_DATABASE_RLOG_HISTORY, table_name=DMA_DATABASE_RLOG_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555646, name=INDEX33555646, table_name=DMA_GATHER_DATA_TABLE)
[2025-02-22 09:13:56]INDEX=(id=33555642, name=INDEX33555642, table_name=DMA_DATABASE_BACKUPSET)
[2025-02-22 09:13:56]INDEX=(id=33555647, name=INDEX33555647, table_name=DMA_GATHER_DATA_TABLE)
[2025-02-22 09:13:56]INDEX=(id=33555643, name=IDX_DMA_DATABASE_BACKUPSET, table_name=DMA_DATABASE_BACKUPSET)
[2025-02-22 09:13:56]INDEX=(id=33555645, name=IDX_DMA_DATABASE_BACKUPSET_BKP, table_name=DMA_DATABASE_BACKUPSET_BKP)
[2025-02-22 09:13:56]INDEX=(id=33555659, name=INDEX33555659, table_name=DBTOOL_REPLACE_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555650, name=INDEX33555650, table_name=DBTOOL_INSPECT)
[2025-02-22 09:13:56]INDEX=(id=33555648, name=INDEX33555648, table_name=DMA_RESOURCE_PKG)
[2025-02-22 09:13:56]INDEX=(id=33555649, name=INDEX33555649, table_name=DMA_RESOURCE_PKG)
[2025-02-22 09:13:56]INDEX=(id=33555651, name=INDEX33555651, table_name=DBTOOL_INSPECT)
[2025-02-22 09:13:56]INDEX=(id=33555658, name=INDEX33555658, table_name=DBTOOL_REPLACE)
[2025-02-22 09:13:56]INDEX=(id=33555662, name=INDEX33555662, table_name=DBTOOL_REPLACE_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555685, name=INDEX33555685, table_name=DBTOOL_BATCH)
[2025-02-22 09:13:56]INDEX=(id=33555666, name=INDEX33555666, table_name=DBTOOL_DEPLOY)
[2025-02-22 09:13:56]INDEX=(id=33555664, name=INDEX_DBTOOL_REPLACE_EXECUTE_LOG_EXECUTE_ID, table_name=DBTOOL_REPLACE_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555665, name=INDEX_DBTOOL_REPLACE_EXECUTE_LOG_TASK_ID, table_name=DBTOOL_REPLACE_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555667, name=INDEX33555667, table_name=DBTOOL_DEPLOY)
[2025-02-22 09:13:56]INDEX=(id=33555661, name=INDEX_DBTOOL_REPLACE_EXECUTE_REPLACE_ID, table_name=DBTOOL_REPLACE_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555660, name=INDEX33555660, table_name=DBTOOL_REPLACE_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555686, name=INDEX33555686, table_name=DBTOOL_BATCH_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555687, name=INDEX33555687, table_name=DBTOOL_BATCH_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555698, name=INDEX33555698, table_name=DBTOOL_DTS_MODE)
[2025-02-22 09:13:56]INDEX=(id=33555696, name=INDEX33555696, table_name=DBTOOL_DASHBOARD)
[2025-02-22 09:13:56]INDEX=(id=33555688, name=INDEX33555688, table_name=DBTOOL_BATCH_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555663, name=INDEX33555663, table_name=DBTOOL_REPLACE_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555699, name=INDEX33555699, table_name=DBTOOL_DTS_MODE)
[2025-02-22 09:13:56]INDEX=(id=33555697, name=INDEX33555697, table_name=DBTOOL_DASHBOARD)
[2025-02-22 09:13:56]INDEX=(id=33555706, name=INDEX33555706, table_name=DMA_MAINFRAME_CORE)
[2025-02-22 09:13:56]INDEX=(id=33555709, name=INDEX33555709, table_name=DMA_MAINFRAME_CORE_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555691, name=INDEX_DBTOOL_BATCH_EXECUTE_LOG_TASK_ID, table_name=DBTOOL_BATCH_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555712, name=INDEX33555712, table_name=UPGRADE_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555707, name=INDEX33555707, table_name=DMA_MAINFRAME_CORE)
[2025-02-22 09:13:56]INDEX=(id=33555689, name=INDEX33555689, table_name=DBTOOL_BATCH_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555711, name=INDEX_DMA_MF_CORE_HISTORY, table_name=DMA_MAINFRAME_CORE_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555710, name=INDEX33555710, table_name=DMA_MAINFRAME_CORE_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555690, name=INDEX_DBTOOL_BATCH_EXECUTE_LOG_EXECUTE_ID, table_name=DBTOOL_BATCH_EXECUTE_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555721, name=INDEX33555721, table_name=ADMIN_PERMISSION_USER)
[2025-02-22 09:13:56]INDEX=(id=33555708, name=INDEX_DMA_MF_CORE, table_name=DMA_MAINFRAME_CORE)
[2025-02-22 09:13:56]INDEX=(id=33555723, name=INDEX33555723, table_name=DMA_MAINFRAME_BAK)
[2025-02-22 09:13:56]INDEX=(id=33555719, name=INDEX33555719, table_name=ADMIN_PERMISSION_ROLE)
[2025-02-22 09:13:56]INDEX=(id=33555722, name=INDEX33555722, table_name=ADMIN_PERMISSION_USER)
[2025-02-22 09:13:56]INDEX=(id=33555756, name=INDEX33555756, table_name=DMA_MULTI_CONN_SQL_TEMPLATE_DB)
[2025-02-22 09:13:56]INDEX=(id=33555755, name=INDEX33555755, table_name=DMA_MULTI_CONN_SQL_TEMPLATE_DB)
[2025-02-22 09:13:56]INDEX=(id=33555766, name=INDEX33555766, table_name=DMA_DATABASE_SQL_LOG_VIEW_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555768, name=INDEX33555768, table_name=DMA_DATABASE_JOB_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555714, name=INDEX33555714, table_name=UPGRADE_EXECUTE_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555720, name=INDEX33555720, table_name=ADMIN_PERMISSION_ROLE)
[2025-02-22 09:13:56]INDEX=(id=33555713, name=INDEX33555713, table_name=UPGRADE_EXECUTE_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555770, name=INDEX33555770, table_name=DMA_DATABASE_TRX_WAIT)
[2025-02-22 09:13:56]INDEX=(id=33555780, name=INDEX33555780, table_name=DMA_DATABASE_SERVER_LOG_GROUP_STAT)
[2025-02-22 09:13:56]INDEX=(id=33555776, name=INDEX33555776, table_name=DMA_DATABASE_SERVER_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555777, name=INDEX_DMA_DATABASE_SERVER_LOG_ID, table_name=DMA_DATABASE_SERVER_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555790, name=INDEX33555790, table_name=DMA_DATABASE_SQL_LOG_VIEW_INFO)
[2025-02-22 09:13:56]INDEX=(id=33555791, name=INDEX33555791, table_name=DMA_DATABASE_JOB_HISTORY)
[2025-02-22 09:13:56]INDEX=(id=33555795, name=INDEX33555795, table_name=DMA_PROCESS_STAT)
[2025-02-22 09:13:56]INDEX=(id=33555787, name=INDEX_DMA_DATABASE_SQL_LOG_VIEW_ID, table_name=DMA_DATABASE_SQL_LOG_VIEW)
[2025-02-22 09:13:56]INDEX=(id=33555786, name=INDEX33555786, table_name=DMA_DATABASE_SQL_LOG_VIEW)
[2025-02-22 09:13:56]INDEX=(id=33555782, name=INDEX33555782, table_name=DMA_DATABASE_SQL_LOG_FILE)
[2025-02-22 09:13:56]INDEX=(id=33555818, name=INDEX33555818, table_name=DBTOOL_DTS_RUNNING_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555819, name=INDEX33555819, table_name=DBTOOL_DTS_RUNNING_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555783, name=INDEX_DMA_DATABASE_SQL_LOG_FILE_ID, table_name=DMA_DATABASE_SQL_LOG_FILE)
[2025-02-22 09:13:56]INDEX=(id=33555792, name=INDEX33555792, table_name=DMA_DATABASE_TRX_WAIT)
[2025-02-22 09:13:56]INDEX=(id=33555838, name=INDEX33555838, table_name=DBTOOL_DEPLOY_DB_INI_SNAPSHOT)
[2025-02-22 09:13:56]INDEX=(id=33555833, name=INDEX33555833, table_name=DBTOOL_DEPLOY_DB_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555830, name=INDEX33555830, table_name=DBTOOL_DEPLOY_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555821, name=INDEX33555821, table_name=DBTOOL_DTS_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555832, name=INDEX33555832, table_name=DBTOOL_DEPLOY_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555856, name=INDEX33555856, table_name=DBTOOL_INSPECT_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555839, name=INDEX33555839, table_name=DBTOOL_DEPLOY_DB_INI_SNAPSHOT)
[2025-02-22 09:13:56]INDEX=(id=33555841, name=INDEX_DBTOOL_DEPLOY_DB_LOG, table_name=DBTOOL_DEPLOY_DB_LOG)
[2025-02-22 09:13:56]INDEX=(id=33555859, name=INDEX33555859, table_name=DBTOOL_INSPECT_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555844, name=INDEX33555844, table_name=DBTOOL_DEPLOY_EXECUTE)
[2025-02-22 09:13:56]INDEX=(id=33555835, name=INDEX33555835, table_name=DBTOOL_DEPLOY_TASK_MSG)
[2025-02-22 09:13:56]INDEX=(id=33555842, name=INDEX_DBTOOL_DEPLOY_TASK_MSG, table_name=DBTOOL_DEPLOY_TASK_MSG)
[2025-02-22 09:13:56]INDEX=(id=33555857, name=INDEX33555857, table_name=DBTOOL_INSPECT_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555843, name=INDEX_DBTOOL_DEPLOY_DB_INI_SNAPSHOT, table_name=DBTOOL_DEPLOY_DB_INI_SNAPSHOT)
[2025-02-22 09:13:56]INDEX=(id=33555866, name=INDEX33555866, table_name=DBTOOL_BATCH_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555886, name=INDEX33555886, table_name=DMA_DATABASE)
[2025-02-22 09:13:56]INDEX=(id=33555869, name=INDEX33555869, table_name=DBTOOL_BATCH_TASK)
[2025-02-22 09:13:56]INDEX=(id=33555884, name=INDEX_DBTOOL_SERVER_CONN, table_name=DBTOOL_SERVER_CONN)
[2025-02-22 09:13:56]--------check indexes end-----------------
[2025-02-22 09:13:56]--------check iid start-------------------
[2025-02-22 09:13:56]check cons id ...
[2025-02-22 09:13:56]check index id ...
[2025-02-22 09:13:56]check table id ...
[2025-02-22 09:13:56]check proc id ...
[2025-02-22 09:13:56]check schema id ...
[2025-02-22 09:13:56]check synonym id ...
[2025-02-22 09:13:56]check user id ...
[2025-02-22 09:13:56]--------check iid end---------------------
[2025-02-22 09:13:56]--------check tablespace list and inode start-------------------
[2025-02-22 09:13:56]check tablespace(1)..
[2025-02-22 09:13:56]check tablespace(4)..
[2025-02-22 09:13:56]check tablespace(0)..
[2025-02-22 09:13:56]check tablespace(5)..
[2025-02-22 09:13:56]--------check tablespace list and inode end-------------------
[2025-02-22 09:13:56]DM DB CHECK END......
[2025-02-22 09:13:56]
Checked Files Total: 4
Checked Indexes Total: 347
Error Indexes Total: 0
Checked Pages Total: 466
Corrupted Pages Total: 0
Data Error Pages Total: 0
Invalidate Pages Total: 0
Checked Tablespaces Total: 4
Error List Total: 0
Checked Inodes Total: 2840
Error Inodes Total: 0
[dmdba@dm91 bin]$
没有问题会输出如下：error count is 0
，重点关注是否有error
相关记录，下图标记为检查结果明细。
文章转载自国产数据库学堂，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
