20230718-达梦数据库无法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###
欢迎关注我的公众号《IT小Chen》