达梦数据库无法OPEN
问题现象：
[dmdba@cjc-db-03 ~]$ disql SYSDBA/******:5238 Server[LOCALHOST:5238]:mode is primary, state is mount login used time : 4.470(ms) disql V8
执行OPEN：
SQL> alter database open; alter database open; [-720]:Error in line: 1 Dmwatcher is active, or current configuration(ALTER_MODE_STATUS) not allowed to alter database. used time: 1.371(ms). Execute id is 0.
报错：
Dmwatcher is active, or current configuration(ALTER_MODE_STATUS) not allowed to alter database.
测试环境可以直接修改状态：
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); DMSQL executed successfully used time: 21.775(ms). Execute id is 0.
启动数据库:
SQL> alter database open; alter database open; [-516]:Error in line: 1 None normal mode open force needed. used time: 1.845(ms). Execute id is 0.
force方式启动:
SQL> alter database open force; executed successfully used time: 239.480(ms). Execute id is 0.
###chenjuchao 20230718###
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29785807/viewspace-2964890/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
