注册
达梦数据库无法OPEN的运维问题
专栏/培训园地/ 文章详情 /

达梦数据库无法OPEN的运维问题

2023/12/22 1112 0 0
摘要

问题现象:
[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.

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服