注册

DM8部署主备实时集群启动dmwatcher失败

DM青铜级新手 2023/02/03 980 4 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:CentOS7.9
【CPU】:x86_64
【问题描述】*:DM8主库启动dmwatcher失败

[dmdba@localhost bin]$ ./dmwatcher /dm8/data/DAMENG/dmwatcher.ini 
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
The number of remote messages received by local dmwatcher is more than the number of archive destinations configured in dmarch.ini, please check local dmarch.ini configuration!

主库启动dmwatcher报错如上

备库启动正常

[dmdba@localhost bin]$ ./dmwatcher /dm8/data/STANDBY/dmwatcher.ini 
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY

主库dmarch.ini配置如下

[dmdba@localhost ~]$ cat /dm8/data/DAMENG/dmarch.ini 
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = STANDBY
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0
[dmdba@localhost ~]$ cd /dm8/arch/
[dmdba@localhost arch]$

备库dmarch.ini配置如下

[dmdba@localhost ~]$ cat /dm8/data/STANDBY/dmarch.ini 
[ARCHIVE_REALTIME]
  ARCH_TYPE = REALTIME
  ARCH_DEST = DMSERVER
[ARCHIVE_LOCAL1]
  ARCH_TYPE = LOCAL
  ARCH_DEST = /dm8/st/arch
  ARCH_FILE_SIZE = 128
  ARCH_SPACE_LIMIT = 0
[dmdba@localhost ~]$ cd /dm8/st/arch/

主库数据库及实例名

SQL> select name from v$database;

行号     NAME  
---------- ------
1          DAMENG

已用时间: 268.084(毫秒). 执行号:200.
SQL> select instance_name from v$instance;

行号     INSTANCE_NAME
---------- -------------
1          DMSERVER

已用时间: 23.535(毫秒). 执行号:201.

备库数据库及实例名

SQL> select name from v$database;

行号     NAME  
---------- ------
1          DAMENG

已用时间: 174.601(毫秒). 执行号:101.
SQL> select instance_name from v$instance;

行号     INSTANCE_NAME
---------- -------------
1          STANDBY

已用时间: 27.443(毫秒). 执行号:102.

安装完成数据库之后,我曾手动开启过归档模式,操作记录如下

[dmdba@localhost ~]$ mkdir -p /dm8/arch
SQL> alter database mount;
SQL> alter database archivelog;
SQL> alter database add archivelog 'type=local,dest=/dm8/arch,file_size=64,space_limit=20480';
SQL> alter database open;

不知道是否与这一步有关系,请各位专家帮忙分析。

回答 0
暂无回答
扫一扫
联系客服