重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 达梦8 WINDOWS下命令方式启动停止数据库 [打印本页]

作者: 郑全 时间: 2025-3-2 10:20
标题: 达梦8 WINDOWS下命令方式启动停止数据库
本帖最后由郑全于 2025-3-2 10:59 编辑

比如数据库安装在 c:\dmdbms\

BIN文件目录为: c:\dmdbms\bin
数据文件目录：c:\dmdbms\data\
一、启动数据库

如果要启动达梦8数据库，使用以下命令：

1.cd c:\dmdbms\bin
2.执行 dmserver 初始化参数文件即可
如下：

c:\dmdbms\bin>dmserver.exe c:\dmdbms\data\DAMENG\dm.ini
file dm.key not found, use default license!
version info: develop
csek2_vm_t = 1344
nsql_vm_t = 328
prjt2_vm_t = 176
ltid_vm_t = 216
nins2_vm_t = 1136
nset2_vm_t = 272
ndlck_vm_t = 192
ndel2_vm_t = 776
slct2_vm_t = 208
nli2_vm_t = 192
aagr2_vm_t = 280
pscn_vm_t = 288
dist_vm_t = 896
DM Database Server 64 V8 03134284294-20241225-255012-20119 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2025-12-25
file lsn: 57716
ndct db load finished, code:0
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct fill fast pool finished
pseg_set_gtv_trxid_low next_trxid in mem:[64113]
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!
next_trxid in mem:[66115]
next_trxid = 68117.
pseg recv finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info finished, code:0.
nsvr_process_before_open begin.
nsvr_process_before_open success.
SYSTEM IS READY.

二、停止数据库命令

在启动数据库的命令工具中输入 exit ，然后回车，关闭 DM 数据库

exit
Server is stopping...
listener closed and all sessions disconnected
adjust undo_retention & wakeup purge thread...full check point starting...
generate force checkpoint, rlog free space[4294955008], used space[4096]
checkpoint begin, used_space[4096], free_space[4294955008]...
checkpoint end, 0 pages flushed, used_space[4096], free_space[4294955008].
full check point end.
shutdown audit subsystem...OK
shutdown schedule subsystem...OK
shutdown timer successfully.
pre-shutdown MAL subsystem...OK
shutdown worker threads subsystem...OK
shutdown logic log subsystem...OK
shutdown sequence cache subsystem...OK
wait for mtsk link worker to exit..OK
shutdown mpp session subsystem...OK
wait for rapply is all over... OK
rapply worker threads exit successfully.
pre ending task & worker threads...OK
shutdown dblink subsystem...OK
shutdown local parallel threads pool successfully.
shutdown pthd_pools...OK
shutdown session subsystem...shutdown aux session subsystem...OK
shutdown rollback segments purging subsystem...OK
shutdown transaction subsystem...OK
shutdown locking subsystem...OK
shutdown dbms_lock subsystem...OK
ending tsk and worker threads...OK
ckpt2_exec_immediately begin.
checkpoint begin, used_space[4096], free_space[4294955008]...
checkpoint end, 0 pages flushed, used_space[4096], free_space[4294955008].
checkpoint begin, used_space[4096], free_space[4294955008]...
checkpoint begin, used_space[0], free_space[4294959104]...
shutdown archive subsystem...OK
shutdown redo log subsystem...OK
shutdown MAL subsystem...OK
shutdown message compress subsystem successfully.
shutdown task subsystem...OK
shutdown trace subsystem...OK
shutdown svr_log subsystem...OK
shutdown plan cache subsystem...OK
shutdown database dictionary subsystem...OK
shutdown file subsystem...OK
shutdown mac cache subsystem...OK
shutdown dynamic login cache subsystem...OK
shutdown ifun/bifun/sfun/afun cache subsystem...OK
shutdown crypt subsystem...OK
shutdown pipe subsystem...OK
shutdown compress component...OK
shutdown slave redo subsystem...OK
shutdown kernel buffer subsystem...OK
shutdown SQL capture subsystem...OK
shutdown control file system...OK
shutdown dtype subsystem...OK
shutdown huge buffer and memory pools...OK
close lsnr socket
DM Database Server shutdown successfully.

c:\dmdbms\bin>

也可以在disql 中，使用

sql> shutdown immediate;

关闭数据库

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)