为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:Kylin v10
【CPU】:鲲鹏
【问题描述】*:数据库执行备份时,数据库运行日志中出现报错:
2022-04-12 23:00:02.077 [WARNING] database P0001843337 T0000000000001449761 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-12 23:00:10.352 [WARNING] database P0001843337 T0000000000001449761 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-13 23:00:01.937 [WARNING] database P0001843337 T0000000000001945213 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-13 23:00:09.797 [WARNING] database P0001843337 T0000000000001945213 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-14 23:00:01.739 [WARNING] database P0001843337 T0000000000002440172 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-14 23:00:07.604 [WARNING] database P0001843337 T0000000000002440172 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-15 23:00:02.083 [WARNING] database P0001843337 T0000000000002934562 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-15 23:00:07.176 [WARNING] database P0001843337 T0000000000002934562 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-16 23:00:01.754 [WARNING] database P0001843337 T0000000000003428828 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-16 23:00:06.927 [WARNING] database P0001843337 T0000000000003428828 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-17 23:00:02.025 [WARNING] database P0001843337 T0000000000003922938 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
2022-04-17 23:00:21.565 [WARNING] database P0001843337 T0000000000003922938 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
数据库的备份语句是:
backup database increment maxpiecesize 5120 COMPRESSED LEVEL 3 trace level 2;
backup archivelog all delete input trace level 2;
exit;
请问下告警的原因是什么?如果调整?
2022-04-12 23:00:02.077 [WARNING] database P0001843337 T0000000000001449761 arch file(…/log/dm_SBTTRACE_202204.log) version check fail(file: /data/sdc/wxy/ent/dev4/log/rfil.c, line: 1093)
如日志所示,将dm_SBTTRACE_202204.log作为归档日志文件(archive log file)解析时存在警告。
执行备份操作时为防止用户将归档日志文件指定为SBT TRACE日志文件(默认dm_SBTTRACE_年月.log),会将SBT TRACE文件作为归档解析,如果不是归档文件则正常执行备份。而解析归档日志时,对于此类非归档文件解析失败时则会打印警告信息。
可以删除dm_SBTTRACE_202204.log后确认是否仍输出警告信息。
这个告警可以忽略