【达梦】达梦数据库在重启的时候在干嘛

于 2024-07-25 16:33:13 发布
阅读量19 收藏
点赞数 1
分类专栏： 国产数据库-达梦 文章标签： 数据库 oracle sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43346403/article/details/140693695
版权

1.数据库关闭日志分析 

2024-07-25 16:11:54.755 [FATAL] database P0000009778 T0000000000000009778  sigterm_handler receive signal 15
2024-07-25 16:11:54.755 [INFO] database P0000009778 T0000000000000009783  Server is stopping...
2024-07-25 16:11:54.755 [INFO] database P0000009778 T0000000000000009783  listener closed  and all sessions disconnected
2024-07-25 16:11:58.757 [INFO] database P0000009778 T0000000000000009783  adjust undo_retention & wakeup purge thread...
2024-07-25 16:11:58.757 [INFO] database P0000009778 T0000000000000009783  INI parameter UNDO_RETENTION changed, the original value 0, new value 1
2024-07-25 16:11:58.757 [INFO] database P0000009778 T0000000000000009783  full check point starting...
2024-07-25 16:11:58.757 [INFO] database P0000009778 T0000000000000009783  generate force checkpoint, rlog free space[536837120], used space[25600]
2024-07-25 16:11:58.757 [INFO] database P0000009778 T0000000000000009791  checkpoint begin, used_space[25600], free_space[536837120]...
2024-07-25 16:11:58.759 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2024-07-25 16:11:58.759 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: ckpt_lsn(49763), ckpt_fil(0), ckpt_off(11914752), cur_lsn(49763), l_next_seq(7367), g_next_seq(7367), cur_free(11914752), total_space(536862720), used_space(0), free_space(536862720), n_ep(1)
2024-07-25 16:11:58.759 [INFO] database P0000009778 T0000000000000009791  checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].
2024-07-25 16:11:58.760 [INFO] database P0000009778 T0000000000000009783  full check point end.
2024-07-25 16:11:58.760 [INFO] database P0000009778 T0000000000000009783  shutdown audit subsystem...
2024-07-25 16:11:58.760 [INFO] database P0000009778 T0000000000000009783  shutdown schedule subsystem...
2024-07-25 16:11:58.770 [INFO] database P0000009778 T0000000000000009783  shutdown timer successfully.
2024-07-25 16:11:58.770 [INFO] database P0000009778 T0000000000000009783  pre-shutdown MAL subsystem...
2024-07-25 16:11:58.770 [INFO] database P0000009778 T0000000000000009783  shutdown worker threads subsystem...
2024-07-25 16:11:59.087 [INFO] database P0000009778 T0000000000000009783  wait for mtsk link worker to exit..
2024-07-25 16:11:59.087 [INFO] database P0000009778 T0000000000000009783  shutdown mpp session subsystem...
2024-07-25 16:11:59.087 [INFO] database P0000009778 T0000000000000009783  wait for rapply is all over... 
2024-07-25 16:11:59.087 [INFO] database P0000009778 T0000000000000009783  rapply worker threads exit successfully.
2024-07-25 16:11:59.087 [INFO] database P0000009778 T0000000000000009783  pre ending task & worker threads...
2024-07-25 16:11:59.087 [INFO] database P0000009778 T0000000000000009783  shutdown dblink subsystem...
2024-07-25 16:11:59.087 [INFO] database P0000009778 T0000000000000009783  shutdown pthd_pools...
2024-07-25 16:11:59.089 [INFO] database P0000009778 T0000000000000009783  shutdown session subsystem...
2024-07-25 16:11:59.089 [INFO] database P0000009778 T0000000000000009783  shutdown rollback segments purging subsystem...
2024-07-25 16:11:59.208 [INFO] database P0000009778 T0000000000000009783  ending tsk and worker threads...
2024-07-25 16:11:59.219 [INFO] database P0000009778 T0000000000000009783  ckpt2_exec_immediately begin.
2024-07-25 16:11:59.219 [INFO] database P0000009778 T0000000000000009791  checkpoint begin, used_space[0], free_space[536862720]...
2024-07-25 16:11:59.222 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2024-07-25 16:11:59.222 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: ckpt_lsn(49943), ckpt_fil(0), ckpt_off(11914752), cur_lsn(49943), l_next_seq(7368), g_next_seq(7368), cur_free(11923968), total_space(536862720), used_space(9216), free_space(536853504), n_ep(1)
2024-07-25 16:11:59.223 [INFO] database P0000009778 T0000000000000009791  checkpoint end, 0 pages flushed, used_space[9216], free_space[536853504].
2024-07-25 16:11:59.223 [INFO] database P0000009778 T0000000000000009791  checkpoint begin, used_space[9216], free_space[536853504]...
2024-07-25 16:11:59.224 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2024-07-25 16:11:59.224 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: ckpt_lsn(49943), ckpt_fil(0), ckpt_off(11923968), cur_lsn(49943), l_next_seq(7368), g_next_seq(7368), cur_free(11923968), total_space(536862720), used_space(0), free_space(536862720), n_ep(1)
2024-07-25 16:11:59.224 [INFO] database P0000009778 T0000000000000009791  checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].
2024-07-25 16:11:59.224 [INFO] database P0000009778 T0000000000000009791  checkpoint begin, used_space[0], free_space[536862720]...
2024-07-25 16:11:59.225 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2024-07-25 16:11:59.225 [INFO] database P0000009778 T0000000000000009791  ckpt2_log_adjust: ckpt_lsn(49943), ckpt_fil(0), ckpt_off(11923968), cur_lsn(49943), l_next_seq(7368), g_next_seq(7368), cur_free(11923968), total_space(536862720), used_space(0), free_space(536862720), n_ep(1)
2024-07-25 16:11:59.225 [INFO] database P0000009778 T0000000000000009791  checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].
2024-07-25 16:11:59.225 [INFO] database P0000009778 T0000000000000009783  shutdown archive subsystem...
2024-07-25 16:11:59.248 [INFO] database P0000009778 T0000000000000009783  rafil_close_with_trunc file[/dm/arch/ARCHIVE_LOCAL1_0x39E4FB77_EP0_2024-07-25_15-31-10.log] to 546304 len, g_next_seq:7367, ret = 1!
2024-07-25 16:11:59.248 [INFO] database P0000009778 T0000000000000009783  rfil_close_low set arch rfil[/dm/arch/ARCHIVE_LOCAL1_0x39E4FB77_EP0_2024-07-25_15-31-10.log]'s sta to inactive, l_next_seq = 7367, g_next_seq = 7367, clsn = 49943, handle = 16, free=546304, len=546304
2024-07-25 16:11:59.259 [INFO] database P0000009778 T0000000000000009783  OK
2024-07-25 16:11:59.259 [INFO] database P0000009778 T0000000000000009783  shutdown redo log subsystem...
2024-07-25 16:11:59.260 [INFO] database P0000009778 T0000000000000009783  rfil_close_low set main rfil[/dm/mdbms/data/DAMENG1/DAMENG101.log]'s sta to inactive, l_next_seq = 7368, g_next_seq = 7368, clsn = 49943, handle = 7, free=11923968, len=268435456
2024-07-25 16:11:59.261 [INFO] database P0000009778 T0000000000000009783  os_sema2_free, sema_id:6, sema_value:1!
2024-07-25 16:11:59.272 [INFO] database P0000009778 T0000000000000009783  shutdown MAL subsystem...
2024-07-25 16:11:59.375 [INFO] database P0000009778 T0000000000000009783  global inject hint deinit
2024-07-25 16:11:59.382 [INFO] database P0000009778 T0000000000000009783  fil_sys_destroy
2024-07-25 16:12:00.064 [INFO] database P0000009778 T0000000000000009783  close lsnr socket
2024-07-25 16:12:00.065 [INFO] database P0000009778 T0000000000000009783  DM Database Server shutdown successfully.
2024-07-25 16:12:00.065 [INFO] database P0000009778 T0000000000000009783  nsvr_notify_exit wakeup main thread to exit

(1)开始关机  
(2)关闭监听,断开连接 
(3)调整 undo_retention 参数 
(4)做检查点 
(5)关闭审计子系统 
(6)关闭调度子系统
(7)关闭时钟 
(8)开始准备关闭MAL子系统 
(9)关闭worker线程 
(10)关闭mpp会话子系统 
(11)关闭DBLINK子系统
(12)关闭 pthd_pools
(13)关闭会话子系统 
(14)关闭回滚段清理子系统 
(15)日志检查点调整
(16)关闭归档子系统 
(17)关闭redo log子系统
(18)关闭MAL子系统
(19)关闭监听套接字
(20)关闭达梦数据库服务

2.数据库启动日志分析 

2024-07-25 16:12:25.787 [INFO] database P0000013653 T0000000000000013653  INI parameter DPC_2PC changed, the original value 1, new value 0
2024-07-25 16:12:25.794 [INFO] database P0000013653 T0000000000000013653  version info: develop
2024-07-25 16:12:25.795 [INFO] database P0000013653 T0000000000000013653  os_sema2_create_low, create and inc sema success, key:82762375, sem_id:7, sem_value:1!
2024-07-25 16:12:25.800 [INFO] database P0000013653 T0000000000000013653  Database's huge_with_delta is 1, and rlog_gen_for_huge is 0!
2024-07-25 16:12:25.810 [INFO] database P0000013653 T0000000000000013653  DM Database Server 64 V8 03134283890-20220720-165295-10045 startup...
2024-07-25 16:12:25.812 [INFO] database P0000013653 T0000000000000013653  INI parameter ROLLSEG_POOLS changed, the original value 19, new value 1
2024-07-25 16:12:25.853 [WARNING] database P0000013653 T0000000000000013653  fail to load libproj.so, /dm/mdbms/bin/libproj.so: cannot open shared object file: No such file or directory
2024-07-25 16:12:25.865 [INFO] database P0000013653 T0000000000000013653  fil_sys_init
2024-07-25 16:12:26.017 [INFO] database P0000013653 T0000000000000013653  Database mode = 0, oguid = 0
2024-07-25 16:12:26.019 [INFO] database P0000013653 T0000000000000013653  License will expire on 2024-08-08
2024-07-25 16:12:26.021 [INFO] database P0000013653 T0000000000000013653  Initialize temp tablespace, file path: /dm/mdbms/data/DAMENG1/TEMP.DBF, code: 0
2024-07-25 16:12:26.061 [INFO] database P0000013653 T0000000000000013653  rfil[/dm/mdbms/data/DAMENG1/DAMENG101.log] ver: 7007, sta: 1, arch_lsn = 0, arch_seq = 0, clsn = 49943, clsn_fil = 0, clsn_off = 11923968, l_next_seq = 7368, g_next_seq = 7368, free = 11923968
2024-07-25 16:12:26.062 [INFO] database P0000013653 T0000000000000013653  rlog4_apply_info_set, p_db_magic:[0x0](old value:0x0), n_apply_ep: 0(old n_ep=0), apply_info_lsn: 0(old apply_info_lsn=0), apply_seq_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
2024-07-25 16:12:26.062 [INFO] database P0000013653 T0000000000000013653  rlog4_raft_info_set, l_term_id:0, rlog->term_id[0], term_id[0], rlog->c_seqno[0], c_seqno[7367], rlog->c_lsn[0], c_lsn [49943]
2024-07-25 16:12:26.062 [INFO] database P0000013653 T0000000000000013653  rlog4_raft_info_set in recover, set rlog->c_seqno(0)->(7367).
2024-07-25 16:12:26.062 [INFO] database P0000013653 T0000000000000013653  rlog4_raft_info_set in recover, set rlog->c_lsn(0)->(49943).
2024-07-25 16:12:26.062 [INFO] database P0000013653 T0000000000000013653  rlog4_init, set rlog h_seqno from 0 to 7367, h_lsn from 0 to 49943.
2024-07-25 16:12:26.062 [INFO] database P0000013653 T0000000000000013653  hlog_sys_destroy, n_logs[1], adjust_sta[0]
2024-07-25 16:12:26.063 [INFO] database P0000013653 T0000000000000013653  rfil[/dm/mdbms/data/DAMENG1/DAMENG101.log] ver: 7007, sta: 1, arch_lsn = 0, arch_seq = 0, clsn = 49943, clsn_fil = 0, clsn_off = 11923968, l_next_seq = 7368, g_next_seq = 7368, free = 11923968
2024-07-25 16:12:26.063 [INFO] database P0000013653 T0000000000000013653  rlog4_apply_info_set, p_db_magic:[0x0](old value:0x0), n_apply_ep: 0(old n_ep=0), apply_info_lsn: 0(old apply_info_lsn=0), apply_seq_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
2024-07-25 16:12:26.064 [INFO] database P0000013653 T0000000000000013653  rlog4_raft_info_set, l_term_id:0, rlog->term_id[0], term_id[0], rlog->c_seqno[0], c_seqno[7367], rlog->c_lsn[0], c_lsn [49943]
2024-07-25 16:12:26.064 [INFO] database P0000013653 T0000000000000013653  rlog4_raft_info_set in recover, set rlog->c_seqno(0)->(7367).
2024-07-25 16:12:26.064 [INFO] database P0000013653 T0000000000000013653  rlog4_raft_info_set in recover, set rlog->c_lsn(0)->(49943).
2024-07-25 16:12:26.064 [INFO] database P0000013653 T0000000000000013653  rlog4_init, set rlog h_seqno from 0 to 7367, h_lsn from 0 to 49943.
2024-07-25 16:12:26.064 [INFO] database P0000013653 T0000000000000013653  hlog_sys_destroy, n_logs[1], adjust_sta[0]
2024-07-25 16:12:26.065 [INFO] database P0000013653 T0000000000000013653  EP[0] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.065 [INFO] database P0000013653 T0000000000000013653  EP[0] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.068 [INFO] database P0000013653 T0000000000000013653  EP[1] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.068 [INFO] database P0000013653 T0000000000000013653  EP[1] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.069 [INFO] database P0000013653 T0000000000000013653  EP[2] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.069 [INFO] database P0000013653 T0000000000000013653  EP[2] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.071 [INFO] database P0000013653 T0000000000000013653  EP[3] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.071 [INFO] database P0000013653 T0000000000000013653  EP[3] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.071 [INFO] database P0000013653 T0000000000000013653  EP[4] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.071 [INFO] database P0000013653 T0000000000000013653  EP[4] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.073 [INFO] database P0000013653 T0000000000000013653  EP[5] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.073 [INFO] database P0000013653 T0000000000000013653  EP[5] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.074 [INFO] database P0000013653 T0000000000000013653  EP[6] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.074 [INFO] database P0000013653 T0000000000000013653  EP[6] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.076 [INFO] database P0000013653 T0000000000000013653  EP[7] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.076 [INFO] database P0000013653 T0000000000000013653  EP[7] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.077 [INFO] database P0000013653 T0000000000000013653  EP[8] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.077 [INFO] database P0000013653 T0000000000000013653  EP[8] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.079 [INFO] database P0000013653 T0000000000000013653  EP[9] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.079 [INFO] database P0000013653 T0000000000000013653  EP[9] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.080 [INFO] database P0000013653 T0000000000000013653  EP[10] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.080 [INFO] database P0000013653 T0000000000000013653  EP[10] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.082 [INFO] database P0000013653 T0000000000000013653  EP[11] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.082 [INFO] database P0000013653 T0000000000000013653  EP[11] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.083 [INFO] database P0000013653 T0000000000000013653  EP[12] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.083 [INFO] database P0000013653 T0000000000000013653  EP[12] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.084 [INFO] database P0000013653 T0000000000000013653  EP[13] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.084 [INFO] database P0000013653 T0000000000000013653  EP[13] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.085 [INFO] database P0000013653 T0000000000000013653  EP[14] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.085 [INFO] database P0000013653 T0000000000000013653  EP[14] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.087 [INFO] database P0000013653 T0000000000000013653  EP[15] plog_redo_init(redo_type: 0) by apply info, set redo_lsn from 0 to 0
2024-07-25 16:12:26.087 [INFO] database P0000013653 T0000000000000013653  EP[15] plog_redo_init(redo_type: 0) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2024-07-25 16:12:26.143 [INFO] database P0000013653 T0000000000000013653  hlog_sys_destroy, n_logs[1], adjust_sta[0]
2024-07-25 16:12:26.144 [INFO] database P0000013653 T0000000000000013653  file lsn: 49943
2024-07-25 16:12:26.144 [INFO] database P0000013653 T0000000000000013653  rlog4_apply_info_clear, arr_clear:0, file_path:/dm/mdbms/data/DAMENG1/DAMENG101.log
2024-07-25 16:12:26.144 [INFO] database P0000013653 T0000000000000013653  rlog4_apply_info_clear reset p_db_magic[0], n_apply_ep[0], apply_info_lsn[0], apply_seq_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2024-07-25 16:12:26.146 [INFO] database P0000013653 T0000000000000013653  ndct db load finished
2024-07-25 16:12:26.148 [INFO] database P0000013653 T0000000000000013653  hpc_dw_apply_info_check_make, p_db_magic(0), n_apply_ep(0), apply_pkg_seq([0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]), apply_lsn_arr([0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]), db_magic(971307895), n_ep(1), apply_info_lsn(49943), pkg_seq_arr([7367, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]), file_lsn([49943, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0])
2024-07-25 16:12:26.148 [INFO] database P0000013653 T0000000000000013653  ohis_ctl_add success, ctl info: rguid:DAMENG1_7, sys_mode:NORMAL, p_iname:DAMENG1, c_iname:DAMENG1, p_db_magic:971307895, c_db_magic:971307895, n_ep:1, pkg_seqno:[7367], lsn_arr:[49943]
2024-07-25 16:12:26.148 [INFO] database P0000013653 T0000000000000013653  rlog4_apply_info_clear, arr_clear:0, file_path:/dm/mdbms/data/DAMENG1/DAMENG101.log
2024-07-25 16:12:26.148 [INFO] database P0000013653 T0000000000000013653  rlog4_apply_info_clear reset p_db_magic[0], n_apply_ep[0], apply_info_lsn[0], apply_seq_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2024-07-25 16:12:26.151 [INFO] database P0000013653 T0000000000000013653  ndct second level fill fast pool finished
2024-07-25 16:12:26.151 [INFO] database P0000013653 T0000000000000013653  ndct third level fill fast pool finished
2024-07-25 16:12:26.151 [INFO] database P0000013653 T0000000000000013653  ndct second level fill fast pool finished
2024-07-25 16:12:26.151 [INFO] database P0000013653 T0000000000000013653  ndct third level fill fast pool finished
2024-07-25 16:12:26.151 [INFO] database P0000013653 T0000000000000013653  ndct fill fast pool finished
2024-07-25 16:12:26.165 [WARNING] database P0000013653 T0000000000000013653  fail to load libgssapi_krb5.so, /dm/mdbms/bin/libgssapi_krb5.so: cannot open shared object file: No such file or directory
2024-07-25 16:12:26.177 [INFO] database P0000013653 T0000000000000013653  iid_set_new_next_trxid_if_necessary, next_trxid: 20061
2024-07-25 16:12:26.177 [INFO] database P0000013653 T0000000000000013653  iid_set_new_next_trxid_if_necessary, next_trxid: 20061
2024-07-25 16:12:26.177 [INFO] database P0000013653 T0000000000000013653  iid page's trxid[20061]
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  pseg_sys_recv start, startup_flag:1
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  pseg_sys_recv begin...
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  EP[0] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  EP[1] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  EP[2] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  EP[3] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  EP[4] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  EP[5] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.178 [INFO] database P0000013653 T0000000000000013653  EP[6] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[7] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[8] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[9] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[10] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[11] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[12] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[13] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[14] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  EP[15] pseg_state is 0, set pseg state to 2
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg collect items time used 1(ms), mgr_state:1!
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  iid page's trxid[21063]
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg_sys_reset_next_trxid_by_slot_ctl set next_trx_id to 22064, value in iid page is 21063.
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  after iid_next_trxid_adjust_if_necessary, value in iid page is 22065.
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg_sys_recv_cmtarr_reg first_tid:0
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  trx4_cmtarr_set_first_tid set first_tid from 0 to 22065
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  total 0 active crash trx, pseg_crash_trx_rollbacksys_only(0) begin ...
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg_crash_trx_rollback end
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg_crash_trx_rollback all active trx used 0(ms), mgr_state:1!
2024-07-25 16:12:26.179 [INFO] database P0000013653 T0000000000000013653  pseg_sys_recv used 2 ms
2024-07-25 16:12:26.186 [INFO] database P0000013653 T0000000000000013653  pseg recv finished
2024-07-25 16:12:26.189 [INFO] database P0000013653 T0000000000000013653  nsvr_startup end.
2024-07-25 16:12:26.290 [INFO] database P0000013653 T0000000000000013653  aud sys init success.
2024-07-25 16:12:26.290 [INFO] database P0000013653 T0000000000000013653  aud rt sys init success.
2024-07-25 16:12:26.291 [INFO] database P0000013653 T0000000000000013653  systables desc init success.
2024-07-25 16:12:26.291 [INFO] database P0000013653 T0000000000000013653  ndct_db_load_info success.
2024-07-25 16:12:26.292 [INFO] database P0000013653 T0000000000000013653  nsvr_process_before_open begin.
2024-07-25 16:12:26.308 [INFO] database P0000013653 T0000000000000013653  nsvr_process_before_open success.
2024-07-25 16:12:26.309 [INFO] database P0000013653 T0000000000000013653  backup control file /dm/mdbms/data/DAMENG1/dm.ctl to file /dm/mdbms/data/DAMENG1/dm_20240725161226_309785.ctl
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013653  backup control file /dm/mdbms/data/DAMENG1/dm.ctl to file /dm/mdbms/data/DAMENG1/ctl_bak/dm_20240725161226_310738.ctl succeed
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013653  local instance name is DAMENG1, mode is NORMAL, status is OPEN.
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013653  SYSTEM IS READY.
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013653  set g_dw_stat from UNDEFINED to NONE success, g_dw_recover_stop is 0
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013678  total 0 active crash trx, pseg_crash_trx_rollbacksys_only(0) begin ...
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013678  pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013678  pseg_crash_trx_rollback end
2024-07-25 16:12:26.311 [INFO] database P0000013653 T0000000000000013678  hpc_clear_active_trx adjust n_crash_active_trx from 0 to 0.
2024-07-25 16:12:26.312 [INFO] database P0000013653 T0000000000000013696  nsvr_lsnr_thread successfully created.
2024-07-25 16:12:27.312 [INFO] database P0000013653 T0000000000000013675  trx4_min_tid_collect set min_active_id_opt, min_active_id: 22069, first_tid: 22065
2024-07-25 16:12:27.313 [INFO] database P0000013653 T0000000000000013664  rafil_file_create [/dm/arch/ARCHIVE_LOCAL1_0x39E4FB77_EP0_2024-07-25_16-12-27.log] start
2024-07-25 16:12:27.314 [INFO] database P0000013653 T0000000000000013664  rfil_close_low set arch rfil[/dm/arch/ARCHIVE_LOCAL1_0x39E4FB77_EP0_2024-07-25_16-12-27.log]'s sta to inactive, l_next_seq = 2457, g_next_seq = 2457, clsn = 0, handle = 16, free=4096, len=268435456
2024-07-25 16:12:27.315 [INFO] database P0000013653 T0000000000000013664  rafil_file_create [/dm/arch/ARCHIVE_LOCAL1_0x39E4FB77_EP0_2024-07-25_16-12-27.log] success, handle = 16
2024-07-25 16:12:27.315 [INFO] database P0000013653 T0000000000000013664  rafil_file_init, rac_seqno:0, create new file and set last_arch_fil:/dm/arch/ARCHIVE_LOCAL1_0x39E4FB77_EP0_2024-07-25_16-12-27.log!

(1)两阶段提交参数 DPC_2PC 改变 
(2)数据库开始启动 
(3)ROLLSEG_POOLS参数改变 
(4)初始化临时表空间 
(5)rlog4_raft_info_set开始做恢复 
(6)plog_redo_init 做初始化 
(7)rlog4_apply_info_clear 日志应用信息清理 
(8)ndct db 加载 
(9)pseg_crash_trx_rollback 回滚段加载 
(10)nsvr_startup 启动 
(11)sys 初始化成功
(12)备份控制文件 
(13)系统打开 
(14)加载归档日志文件

戒掉贪嗔痴(薛双奇)
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
达梦DM读写分离集群搭建
Jkjt2022的博客
08-01 426
达梦DM读写分离集群搭建
python 连接达梦数据库
11-21
Python 连接达梦数据库是指在 Python 编程语言中连接达梦数据库，以便在 Python 应用程序中使用达梦数据库。下面是 Python 连接达梦数据库的详细步骤和知识点： 检查 Python 是否安装 在开始连接达梦数据库之前，...
达梦数据库学习总结
weixin_46865913的博客
01-13 324
在参加达梦三天的DCA培训课程后，受益良多，再此将自己的收获作简单分享，课程主要内容包括：安装、实例创建、参数修改、创建表空间、创建用户、角色、权限管理； 创建表、导入脚本数据、约束、索引、视图等；物理备份还原、逻辑备份还原；DM 作业、 ODBC 配置等。 1、数据库安装包挂载 （1）cd /opt （2）mount -o loop /opt/dm8_setup.iso /mnt （3）cd /mnt ，ls -ltr 2、初始化安装数据库 （1）增加组：groupad...
达梦数据库DM8备份、还原、恢复介绍
dcps75321的博客
01-16 1583
备份：将数据库中的数据进行拷贝。 还原：将备份导入数据库中，把数据库还原到备份时的样子。 恢复：经过还原的数据库，魔数可能有变，需要更新后才可启动。 【联机配置归档】 跟手动同理，参数都是动态的，因此无需重启，重启后也可生效。 --修改数据库状态为mount alter database mount; --添加归档 alter database add archivelog 'dest=/dmarch, TYPE=local, FILE_SIZE=1024, SPACE_LIMIT=102400'; AL
达梦数据库使用心得
Tiny_deerbro的博客
01-26 585
达梦数据库使用心得总结 1、先调优操作系统 （1）ulimit -a 检查open file 最大打开数，默认是1024，需要扩充 （2）需重启方式：vi /etc/security/limits.conf ，加入下面两行 * soft nofile 102400 * hard nofile 102400 （3）不需重启方式：ulimit -HSn 102400 2、挂在数据库镜像 （1）cd /opt （2）mount -o loop /opt/dm8_setup.iso /
达梦数据库DM8-表空间介绍和管理维护
weixin_42082084的博客
04-12 1086
达梦数据库DM8-表空间管理系列文章目录本文环境1、达梦数据库表空间介绍及查看2、达梦数据库表空间创建2.1 使用DM管理工具创建2.2 使用SQL语句创建3、 表空间维护3.1 表空间状态3.1 表空间扩容3.2 更换数据文件路径4、 表空间删除5、临时表空间 系列文章目录 第八章 达梦数据库DM8-表空间管理 这里再放一个达梦云适配中心链接，里面的文档模块有很多官方教程，社区模块也可以查询或者提出各类使用问题 达梦云适配中心 本文环境 系统环境： windows 7 sp1 软件镜像： dm8
达梦数据库中的各个日志文件
热门推荐
Neo
05-07 1万+
重做日志文件 重做日志（即REDO日志）指在DM数据库中添加、删除、修改对象，或者改变数据，DM都会按照特定的格式，将这些操作执行的结果写入到当前的重做日志文件中。重做日志文件以log为扩展名。每个DM数据库实例必须至少有2个重做日志文件，默认两个日志文件为DAMENG01.log、DAMENG02.log，这两个文件循环使用。 重做日志文件因为是数据库正在使用的日志文件，因此被称为联机日志文...
达梦数据库使用心得总结
Sniper_L的博客
07-01 1697
达梦数据库使用心得总结 1、先调优操作系统 （1）ulimit -a 检查open file 最大打开数，默认是1024，需要扩充 （2）需重启方式：vi /etc/security/limits.conf ，加入下面两行 * soft nofile 102400 * hard nofile 102400 （3）不需重启方式：ulimit -HSn 102400 2、挂在数据库镜像 （1）cd /opt （2）mount -o loop /opt/dm8_setup.is
关于达梦数据库认证练习的相关记录（一）
glsd234的博客
06-26 1323
写在开头，先谈感情。正值端午节，千百年来，屈原的爱国精神和感人诗辞，仍在人们心中广为流传。时值当下，将爱国之情融入到平凡的工作岗位中，支持软件国产化，支持自主可控，是吾辈IT人的历史使命，抛洒热血，苦练技术，为祖国的繁荣强大贡献力量！ 一、关于在本地虚拟机Linux中图形化界面的显示。 由于老师在讲课中是使用Xshell远程连接到主机的，所以需要用“export DISPLAY=IP:0.0”命令设置图形化界面打开的窗口，而如果我们只在本地虚拟机上运行，只需用root用户执行“xdpyinfo”命令，能查看
达梦数据库DSC搭建
zcn126的博客
03-17 1141
一、环境准备 硬件：两台相同配置机器、2G 内存、20G 本地磁盘、2 块网卡 操作系统：Red Hat Enterprise Linux Server release 7.2 (Maipo) 数据库版本：disql V8.1-1-66-20.03.10-118926-ENT 网络配置： DSC01：网卡1 192.168.73.* 网卡2 10.0.0.101 DSC02：网卡1 19...
Linux系统，启动达梦数据库
12-14
在Linux系统中启动达梦数据库(DM DB)是一项关键任务，尤其对于系统管理员和数据库管理员而言。达梦数据库是一款高效、安全的国产关系型数据库管理系统，适用于多种应用场景。以下是详细的启动流程，以及如何在Linux...
xxl-job适配达梦数据库
最新发布
02-02
在适配达梦数据库之前，XXL-JOB通常默认使用MySQL或者Oracle等常见数据库，但通过修改数据库脚本和配置，可以支持其他数据库系统，包括DM8。 为了将XXL-JOB与达梦数据库进行适配，你需要执行以下几个步骤： 1. **...
activiti适配达梦数据库教程
08-24
在 activiti 的源码中，需要修改 activiti-engine 项目的代码，以便支持达梦数据库。具体来说，需要添加 dm 对应的 sql 文件，并将其中的 NVARCHAR2 改成 NVARCHAR。 3. 编译和打包 activiti 修改代码完成后，需要...
达梦 6 数据库驱动 jar 包
05-05
达梦数据库是一款由中国达梦公司开发的国产关系型数据库管理系统，具有高性能、高安全性、高可用性等特点。本文主要围绕“达梦6数据库驱动jar包”进行深入解析，旨在帮助用户理解和使用达梦6数据库。 首先，达梦6...
微服务Nacos达梦数据库版本
10-31
在“微服务Nacos达梦数据库版本”中，Nacos进行了对国产达梦数据库的深度适配，这使得在使用Nacos的微服务项目中，可以更加便捷地集成和管理达梦数据库，提升整体系统的灵活性和可扩展性。 1. **Nacos核心功能** -...
达梦数据库驱动免费下载
05-22
达梦数据库是中国自主研发的一款高性能、高可用性的关系型数据库管理系统，广泛应用在政府、金融、电信等领域。它的驱动程序通常以JDBC（Java Database Connectivity）的形式存在，允许Java开发者通过编写代码来执行...
Nacos2.1.2适配达梦8数据库
10-21
nacos2.1.2修复上一个版本中注册服务...增加国产数据库达梦8的适配 需在conf/application.properties 文件中更新数据库配置，配置如下： db.jdbcDriverName=dm.jdbc.driver.DmDriver db.url.0=jdbc:dm://127.0.0.1:5236
国产数据库 达梦数据库管理工具
07-16
达梦数据库以其出色的并行处理能力、大规模数据处理能力和高安全性，在国内的政府、金融、电信、能源等多个关键领域得到了广泛应用。 达梦数据库管理工具的核心功能可以分为以下几个方面： 1. 数据库管理：工具...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值