为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:V8.0
【操作系统】:Kylin V10
【CPU】:鲲鹏920
【问题描述】*:dm_DMSERVER2_202204.log日志解读
从日志内容上看,dm_DMSERVER2_202204.log的内容基本是刷盘,五分钟执行一次。数据库层面类似参数调整、在线日志切换、创建表空间、创建用户、数据库故障等信息记录在哪个日志文件中?
2022-04-06 11:07:17.831 [INFO] database P0000004030 T0000000000000004871 checkpoint requested by CKPT_INTERVAL, rlog free space[1073587712], used space[145920]
2022-04-06 11:07:17.831 [INFO] database P0000004030 T0000000000000004871 checkpoint generate by ckpt_interval
2022-04-06 11:07:17.831 [INFO] database P0000004030 T0000000000000004748 checkpoint begin, used_space[145920], free_space[1073587712]…
2022-04-06 11:07:17.835 [INFO] database P0000004030 T0000000000000004748 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2022-04-06 11:07:17.835 [INFO] database P0000004030 T0000000000000004748 ckpt2_log_adjust: ckpt_lsn(215116572), ckpt_fil(0), ckpt_off(82346496), cur_lsn(215116796), l_next_seq(7202967),
g_next_seq(6628614), cur_free(82420736), total_space(1073733632), free_space(1073659392), n_ep(1)
2022-04-06 11:07:17.835 [INFO] database P0000004030 T0000000000000004748 checkpoint end, 0 pages flushed, used_space[74240], free_space[1073659392].
2022-04-06 11:12:17.885 [INFO] database P0000004030 T0000000000000004871 checkpoint requested by CKPT_INTERVAL, rlog free space[1073583104], used space[150528]
2022-04-06 11:12:17.885 [INFO] database P0000004030 T0000000000000004871 checkpoint generate by ckpt_interval
2022-04-06 11:12:17.885 [INFO] database P0000004030 T0000000000000004748 checkpoint begin, used_space[150528], free_space[1073583104]…
2022-04-06 11:12:17.888 [INFO] database P0000004030 T0000000000000004748 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2022-04-06 11:12:17.888 [INFO] database P0000004030 T0000000000000004748 ckpt2_log_adjust: ckpt_lsn(215116797), ckpt_fil(0), ckpt_off(82420736), cur_lsn(215117021), l_next_seq(7203041),
g_next_seq(6628688), cur_free(82497024), total_space(1073733632), free_space(1073657344), n_ep(1)
2022-04-06 11:12:17.888 [INFO] database P0000004030 T0000000000000004748 checkpoint end, 0 pages flushed, used_space[76288], free_space[1073657344].
2022-04-06 11:17:17.941 [INFO] database P0000004030 T0000000000000004871 checkpoint requested by CKPT_INTERVAL, rlog free space[1073583104], used space[150528]
2022-04-06 11:17:17.941 [INFO] database P0000004030 T0000000000000004871 checkpoint generate by ckpt_interval
2022-04-06 11:17:17.941 [INFO] database P0000004030 T0000000000000004748 checkpoint begin, used_space[150528], free_space[1073583104]…
2022-04-06 11:17:17.944 [INFO] database P0000004030 T0000000000000004748 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2022-04-06 11:17:17.944 [INFO] database P0000004030 T0000000000000004748 ckpt2_log_adjust: ckpt_lsn(215117022), ckpt_fil(0), ckpt_off(82497024), cur_lsn(215117246), l_next_seq(7203111),
g_next_seq(6628758), cur_free(82571264), total_space(1073733632), free_space(1073659392), n_ep(1)
2022-04-06 11:17:17.944 [INFO] database P0000004030 T0000000000000004748 checkpoint end, 0 pages flushed, used_space[74240], free_space[1073659392].
dm_DMSERVER2_202204.log的内容包含:在线日志切换、数据库故障等
在管理工具中,用sysdba 用户执行
sp_set_para_value(1,‘SVR_LOG’,1)
然后会在数据库服务器达梦安装目录下的log 文件夹里生成dmsql_DMSERVER.log 日志文件,
数据库执行的所有语句(参数调整、创建表空间、创建用户)都会记录在里面
跟踪完毕后用sysdba 用户执行
sp_set_para_value(1,‘SVR_LOG’,0)
关闭日志,以防磁盘空间被写满